| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
the row height should be excatly the height of the data
I an excel sheet I want all the rows to fit the data without using the mouse
or the row height audjustment |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
the row height should be excatly the height of the data
Hi,
Right click your sheet tab, view code and past this in Private Sub Worksheet_Change(ByVal Target As Range) Target.EntireRow.AutoFit End Sub Mike "jaggu" wrote: I an excel sheet I want all the rows to fit the data without using the mouse or the row height audjustment |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
the row height should be excatly the height of the data
CTRL + a(twice in 2003) to select all cells.
Alt + o + r + a to autofit all rows. Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 02:46:00 -0800, jaggu wrote: I an excel sheet I want all the rows to fit the data without using the mouse or the row height audjustment |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can buffer the row height of my data. | Excel Discussion (Misc queries) | |||
| need to dbl row height without changing height of cell next to it | New Users to Excel | |||
| Height (in points) of data point in chart above x-axis | Charts and Charting in Excel | |||
| Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
| resize row height and column height | Setting up and Configuration of Excel | |||
Linear Mode
