Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Expand sheet as information is entered
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Expand sheet as information is entered
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Expand sheet as information is entered
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Cell Once Information is Entered | Excel Discussion (Misc queries) | |||
protect cells only after information is entered | Excel Discussion (Misc queries) | |||
Formatted Cell Changes Format When Information Is Entered | Setting up and Configuration of Excel | |||
Clearing entered information | Excel Discussion (Misc queries) | |||
click on a cell to expand with more information | New Users to Excel |