Excel Random Row Heights

By -
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

Comments

Post a Comment

Popular posts from this blog

Stay COVID Meeting Safe

By -
I've had a number of people asking me recently about using recently popularised Apps due to COVID-19 in personal situations. In my personal opinion, I would steer away from both Zoom and Houseparty in particular, use something that is tried and tested like Messenger , Hangouts , Facetime or WhatsApp and ensure they're up to date as the latter two have also had hacking issues in the past due to people not updating after identified security breaches. Both Apps are very popular at the moment and have had security and privacy concerns raised. Houseparty has been reviewed by security experts which have said: "it's probably safe". It has safe security options but it is up to the end-user to implement them correctly. Having said that if you read the fine print Houseparty uses your personal data and advertising as their income (nothing is free), there have been reports of users having their login details for Netflix and Spotify accounts compromised but these ar
Read more

Cyber Security Awareness 002: Understanding PII (Personally Identifiable Information)

By -
Image
PII (Personally Identifiable Information) What is PII and what should I be aware of? What is PII? In terms of Cyber Security PII (Personally Identifiable Information) is any information associated with the target that could be used as potential leverage for an attack against that individual, an associate, or the company they work for as well as any clients and suppliers the business deals with.
Read more