Скачать или смотреть DO you have Microsift Excel Hidden Column and Rows? in 2 steps

How to Unhide Hidden Columns and Rows in Excel in 2 Simple Steps! #unhide #excel

Are your columns or rows missing in Microsoft Excel? Don’t worry! In this quick tutorial, I’ll show you how to unhide hidden columns and rows in Excel in just 2 easy steps. Whether you’re working with Excel for Microsoft 365, Excel 2021, or earlier versions, these methods will help you instantly reveal your hidden data.

What you’ll learn in this video:

How to quickly unhide columns using the right-click menu

How to unhide rows with a simple shortcut or ribbon command

Tips for unhiding the first column A or row 1

How to select the right area to make all hidden data visible

Step-by-step instructions:

Unhide Columns:

Select the columns next to the hidden ones, right-click, and choose Unhide.

Or, use the ribbon: Home, Format, Hide and Unhide, Unhide Columns.

Unhide Rows:

Select the rows above and below the hidden ones, right-click, and select Unhide.

Or, use the ribbon: Home, Format, Hide and Unhide, Unhide Rows.

Bonus Tips:

Use keyboard shortcuts:

Unhide rows: Ctrl plus Shift plus 9

Unhide columns: Ctrl plus Shift plus 0 (may not work on all Windows versions).

To unhide the first column or row, use the Name Box or Go To (type A1), then unhide from the Format menu.

If you found this video helpful, don’t forget to like, subscribe, and share for more quick Excel tips!

#excel #unhide #columns #rows #exceltips #productivity