View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
geerdad geerdad is offline
external usenet poster
 
Posts: 2
Default How do I stop Excel from automatically resizing my row height?

I have a spreadsheet with approximately 3800 rows and about 40 columns of
data that I'm constantly filtering and massaging data in. It's getting
frustrating to have my rows all of a sudden jump to a height of about 1/4 of
the screen when I shrink some column widths to fit more columns on the
screen. (Freeze panes won't allow me to split the screen also.)

How do I disable the autofit row height?