Share this article
Improve this guide
How to Unhide All Rows and Columns in Microsoft Excel
The Unhide option is under the Format toolbox
3 min. read
Published onOctober 4, 2024
published onOctober 4, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
There are several methods to unhide all rows in Excel if you forgot about them or mistakenly hidden them. First, make sure to disable sorting or allow the sorting to select all rows. At the same time, make sure that no rows are frozen.
How do I unhide all rows in Microsoft Excel?
1. Use the Unhide all option
This is the most simple way to unhide all rows or columns in Excel. If you prefer using shortcuts, pressCtrl+Ato select all the cells, then pressCtrl+Shift+9to unhide all the rows.
Again, make sure that no cells are frozen and the sheet is not locked.
2. Unhide rows or columns using the contextual menu
This is another quick way to unhide rows or columns in Excel. However, the option will appear in the context menu only if you have actual hidden rows or columns in your selection. If not, it will not appear at all or it will be grayed out.
3. Unhide specific rows or columns
Obviously, this method is not so efficient as the first two if you have a long and wide spreadsheet. However, it can be pretty useful if you only want to unhide a certain row or column and leave all the others hidden.
This concludes our guide on how to unhide all rows and columns in Excel using different methods. If you want more guides, we have an article about thebasic Excel formulasthat will help you be more efficient. We also have a must-knowlist of Excel shortcutsthat may come in handy.
Did you manage to unhide all rows and columns in Excel? Let us know in the comments below.
More about the topics:Microsoft Excel
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, Claudiu is focused on whatever comes new from Microsoft.
His abrupt interest in computers started when he saw the first Home Computer as a kid. However, his passion for Windows and everything related became obvious when he became a sys admin in a computer science high school.
With 14 years of experience in writing about everything there is to know about science and technology, Claudiu also likes rock music, chilling in the garden, and Star Wars. May the force be with you, always!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, with 14 years of experience in writing on everything there is to know about science, technology, and Microsoft
