Tricks for Hiding and Unhiding Excel Rows and Columns

By David H. Ringstrom, CPA

Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set. Other users don't know simple keystroke commands that can streamline hiding and unhiding columns or rows. In this article, I'll explore these techniques as well as discuss two powerful alternatives to manually hide and unhide rows and columns. I'll also discuss how to re-enable an Excel keyboard shortcut that's disabled in any operating system subsequent to Windows XP.

 
Hiding Rows and Columns
 
Let's first explore the traditional approaches to hiding rows and columns. Going forward, I'll only explain rows – simply replace the word Row with Column in any menu commands that I describe if you want to hide or unhide columns. First, select the row or rows that you wish to hide or unhide, and then carry out these steps:

You may like these other stories...

More and more businesses are adopting the cloud in order to take advantage of benefits such as greater efficiency, increased productivity and lower costs. Companies in general are flocking to the cloud for email hosting,...
A great way to increase business for your accounting firm is to remain at the front of your clients' minds all throughout the year. One of the best ways to do that is through an email newsletter. Perhaps you send out a...
Cybersecurity is no longer the domain of an organization's IT staff. It's moved to the boardroom, and in a big way. Accountants and financial managers may have been thinking it's just the province of the tech...

Already a member? log in here.

Upcoming CPE Webinars

Oct 9In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards.
Oct 15This webinar presents the requirements of AU-C 600, Audits of Group Financial Statements (Including the Work of Component Auditors).
Oct 21Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience’s communication style.
Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.