ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   expanding cell size (https://www.excelbanter.com/excel-discussion-misc-queries/145219-expanding-cell-size.html)

Missywhirlwind

expanding cell size
 
I was wondering if the cell size can be expanded without adding any characters?
The cell will not expand with a hard return (enter button).
Thank you



bucbanzai

expanding cell size
 
Using the F2 key will allow you to expand the information in a cell to view
its full contents including formulas. You can then edit as needed. hope
This helps.

"Missywhirlwind" wrote:

I was wondering if the cell size can be expanded without adding any characters?
The cell will not expand with a hard return (enter button).
Thank you



Gord Dibben

expanding cell size
 
Type some text then hit Alt + Enter a few times to add carriage returns.

Set for wrap text and autofit the row.


Gord Dibben MS Excel MVP

On Tue, 5 Jun 2007 07:12:04 -0700, Missywhirlwind
wrote:

I was wondering if the cell size can be expanded without adding any characters?
The cell will not expand with a hard return (enter button).
Thank you




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

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