Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to hide and unhide columns and rows in Excel

How to hide and unhide columns and rows in Excel

Transcript 

In this lesson, we'll look at how to hide and unhide columns and rows. Hiding rows or columns is a good way to visually simplify a worksheet without removing important information.

Let's take a look.

One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon.

Notice that when a column is hidden, its heading is also hidden, so that there is a gap in the column letters that run across the top of the worksheet.

To unhide a column, you need to select columns on both sides of the hidden column. Then, choose Unhide Columns from the Format menu.

You can also hide and unhide columns using the right-click menu. Select one or more columns, right-click in the selection, and choose Hide from the menu.

To unhide the columns, make sure to select columns on both sides of the hidden columns. Then, right-click and choose Unhide from the menu.

Rows work in much the same way as columns. You can hide and unhide rows using Hide Rows and Unhide Rows in the Format menu.

Or, you can use the right-click menu, which is faster.

Notice the gap in row numbers when rows are hidden.

As with columns, you need to select rows on both sides of the rows you want to unhide. Then, right-click in the row selection and choose Unhide from the menu.

If you'd like to unhide all rows and columns in a worksheet, first, select the entire worksheet. You can then right-click on row and column headings and select Unhide for each. With the entire sheet selected, it doesn't matter where in the headings you right-click.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
My Lord where have you been all my life?...I've learned more awesome tricks/functions in one afternoon from you than in the last 10 years.
Robert
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page