Expand sheet as information is entered

[akkrug]

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.

 

[Gord Dibben]

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

 

[JLatham]

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

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.