Is there a way in Excel to have the sheet expand as information is keyed and
the keyed information wraps to new lines. Also, can x of y page numbering be
used with this if it is possible?

Thanks!

Ken K.
--
akkrug

An Excel sheet contains millions of cells to enter data into.

What do you mean by "expand"?

What do you mean by "wraps to new lines"?

To start a new line just hit enter to move to next cell.

If want more lines in one cell you can employ "Wrap Text" formatting or hit
Alt + ENTER to start a new line within a cell.

You can also use Row Autofit to expand row height when a whack of data is
typed in one cell.

When printing you can add a footer or header with "page x of y"


Gord Dibben MS Excel MVP


On Thu, 18 Jun 2009 11:41:02 -0700, akkrug
wrote:

Is there a way in Excel to have the sheet expand as information is keyed and
the keyed information wraps to new lines. Also, can x of y page numbering be
used with this if it is possible?

Thanks!

Ken K.

If I understand the request correctly, I think what you need to look at a

Format -- Cells -- [Alignment] tab and make sure Wrap Text is checked.
That will get text to wrap to new lines when it hits the right edge of a
cell. Excel doesn't always automatically adjust the height properly, but you
can select the cell/row it is in and use Format-- Rows -- Height --Auto
Height to get them to adjust.

For the page numbering, look at View -- Headers and Footers, and choose
either custom Header or Custom footer. The tools for Page # of ## are in
there.

Hope this helps.

"akkrug" wrote:

Is there a way in Excel to have the sheet expand as information is keyed and
the keyed information wraps to new lines. Also, can x of y page numbering be
used with this if it is possible?

Thanks!

Ken K.
--
akkrug