How to unhide or show columns & rows in Excel?
In order to prevent affecting other cells in calculations or other works, sometimes we need to hide unwanted columns and rows. This article explains how to unhide or show all columns & rows in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Step 1: Select the range containing the hidden column and rows, or press Ctrl + A to select the entire worksheet.
Step 2: Move to Home > Format > Hide/Unhide > Unhide Rows or Unhide columns. See screenshot:
Note: You cannot unhide all the rows and columns at a time but have to display them individually.
Excel does not support you with one option to unhide all the hidden columns and rows, but the third party Kutools for Excel does.
After installing Kutools for Excel, apply Unhide All Ranges according to these steps:
Kutools> Show/Hide > Unhide All Ranges. See screenshot:
The following examples shows how the function works. We have hided 3, 4, 5 rows before, and then after clicking Unhide All Ranges, the hidden rows are displayed as normal.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 3 years agoHidden columns and rows at a time open suggestion simple superb, thanks 2 u
To post as a guest, your comment is unpublished.· 3 years agoThanks helped me to much
To post as a guest, your comment is unpublished.· 3 years agoThank you.. helped me to much.
To post as a guest, your comment is unpublished.· 4 years agoI am not able to unmhide a FILES ROW IN MY SYSTEM
To post as a guest, your comment is unpublished.· 4 years agoHi, Is it possible to include a show / hide instruction as part of an IF statement? Ie make it so that if the response is YES, the show data in column D and E and if response is NO, then hide columns D and E.