Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
alanb
 
Posts: n/a
Default How do I resize a cell in Excel to display two lines of data

I am trying to adjust an excel sheet to show two lines of data below each
other. How do I resize the cell to allow two lines to display?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I resize a cell in Excel to display two lines of data

You can use alt-enter to force a new line within a cell.

The rowheight should adjust if you've never manually changed it.

But you can select the row
format|row|autofit

Or just drag the line below the number in the row "header" up or down.

alanb wrote:

I am trying to adjust an excel sheet to show two lines of data below each
other. How do I resize the cell to allow two lines to display?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
mantha09
 
Posts: n/a
Default How do I resize a cell in Excel to display two lines of data

Hi Alanb

To resize a cell for two lines of data you
hold down ALT and press ENTER

"alanb" wrote:

I am trying to adjust an excel sheet to show two lines of data below each
other. How do I resize the cell to allow two lines to display?

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
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 03:04 PM


All times are GMT +1. The time now is 08:35 PM.

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

About Us

"It's about Microsoft Excel"