Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 34
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Freeze Cell Once Information is Entered SuzieT Excel Discussion (Misc queries) 4 November 8th 07 06:36 PM
protect cells only after information is entered Sean Campbell Excel Discussion (Misc queries) 0 April 24th 07 04:08 PM
Formatted Cell Changes Format When Information Is Entered SundanceKidLudwig Setting up and Configuration of Excel 1 September 29th 05 09:59 PM
Clearing entered information Ducatisto Excel Discussion (Misc queries) 4 September 6th 05 10:11 AM
click on a cell to expand with more information Dodge Lisa New Users to Excel 1 May 6th 05 09:56 AM


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"