Excel - How To Unhide A Specific Row - Episode 2561b
Microsoft Excel Tutorial - How to Unhide a Specific Row in Excel.
Welcome to my Excel tutorial on how to unhide a specific row in Excel. In this video, I will show you a simple and quick way to unhide a specific row without revealing any other hidden rows.
Have you ever encountered a situation where you have hidden multiple rows in your Excel sheet, but you only want to unhide a specific row? For example, in this sheet, rows seven through 12 are hidden, but I only want to unhide row nine. Well, I have the solution for you.
First, press the F5 key on your keyboard. This will bring up the Go To window in Excel. Alternatively, you can also go to the Home tab, click on the Find & Select button, and select Go To. In the Go To window, type in the cell reference of the row you want to unhide, in this case, A9, and click OK.
Now, you will see that only row nine is selected. To unhide this row, simply press the shortcut key Control + Shift + Left Parenthesis. This will unhide only the selected row, in this case, row nine. This method ensures that no other hidden rows are revealed, giving you complete control over which rows you want to unhide.
If you found this tutorial helpful, please consider giving this video a thumbs up, subscribing to my channel for more Excel tips and tricks, and don't forget to hit the notification bell to stay updated with my latest videos. Thank you for watching, and I'll see you in the next one!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
#excel
#exceltutorial
#exceltips
#microsoftexcel
#exceltricks
#excelhacks
This video answers these common search terms:
How to unhide a specific row in Excel.
can you unhide a specifc row in excel
excel how to unhide a specific row
how do you unhide specific rows in excel
how to unhide a specific row in excel
how to unhide certain rows in excel
how to unhide selected rows in excel
how to unhide some rows in excel
how to unhide specific rows in excel
how to unhide a few rows in excel
how to unhide a group of rows in excel
how to unhide a range of rows in excel
Table of Contents
(0:00) Problem Statement: Unhide a specific row in Excel
(0:10) Use Go To to select a cell in the hidden row
(0:20) Clicking Like really helps the algorithm
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel - How To Unhide A Specific Row - Episode 2561b online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 26 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,086 once and liked it 56 people.