ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I resize a cell in Excel to display two lines of data (https://www.excelbanter.com/excel-discussion-misc-queries/60351-how-do-i-resize-cell-excel-display-two-lines-data.html)

alanb

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?

Dave Peterson

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

mantha09

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?



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com