Wednesday, 30 January 2013

Excel Random Row Heights

I've used Excel for at least 20 years now an I haven't come across this issue before.

Basically we use a shared document to track job processes and it has a header section with key details, summary data and flags for some Macros and the other day all the row heights in the header section reduced so that it looked like the rows were hidden.

I searched for a number things like:

  • Excel row height error
  • Set Excel row height
  • Excel row height issue
In the end I found this post (summarized version with appropriate details below):
  1. Increase the row heights so that they can be viewed
  2. Select/highlight the entire range that's effected
  3. On the Home Toolbar choose bottom alignment, then top alignment  then bottom alignment again....viola, all rows should recover their standard height
  4. Please note if you're working on a shared document with different versions of Excel you'll need to repeat the process
on Microsoft's Social Technet thread, thanks to Dick Bowers