Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort changes row height
How can I keep row height from changing when I perform a sort? When I sort, I
lose sight of some of my information in my cells and then have to resize my row height when I re-sort. Thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort changes row height
Christyr;344662 Wrote: How can I keep row height from changing when I perform a sort? When I sort, I lose sight of some of my information in my cells and then have to resize my row height when I re-sort. Thank you for your help.Well without VBA you could simply click the "Home" square (next to A and above 1 top left of your worksheet) then press and hold Alt then press O, R & A one after the other whilst holding Alt, this will autofit your rows, or using the mouse, click the home square, Format, Rows, Autofit. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96428 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
the row height should be excatly the height of the data | Excel Discussion (Misc queries) | |||
need to dbl row height without changing height of cell next to it | New Users to 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 |