Expand sheet as information is entered

  • Thread starter Thread starter akkrug
  • Start date Start date
A

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.
 
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
 
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.
 
Back
Top