Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Hiding and Unhiding Columns and Rows in Excel | Working with Excel Worksheets and Workbooks
Excel for Beginners
course content

Course Content

Excel for Beginners

Excel for Beginners

1. Introduction to Excel
2. Mastering Data Entry and Formatting in Excel
3. Mastering Basic Excel Formulas and Functions
4. Advanced Excel Formulas and Functions
5. Excel Data Management and Analysis
6. Mastering Data Visualization in Excel
7. Working with Excel Worksheets and Workbooks

book
Hiding and Unhiding Columns and Rows in Excel

This chapter teaches you how to hide and unhide columns and rows, helping you declutter your view and focus on what's important.

Hiding and unhiding columns and rows can make your worksheets cleaner and easier to navigate, especially when sharing with others.

These techniques are great for managing large datasets and protecting sensitive information without deleting it.

Key Points

  • Hide a column by selecting the column header, right-clicking, and choosing Hide or using Ctrl + 0;
  • Hide a row by selecting the row header, right-clicking, and choosing Hide or using Ctrl + 9;
  • Unhide columns by selecting adjacent columns, right-clicking, and choosing Unhide or using Ctrl + Shift + 0;
  • Unhide rows by selecting adjacent rows, right-clicking, and choosing Unhide or using Ctrl + Shift + 9.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 7. Chapter 5
We're sorry to hear that something went wrong. What happened?
some-alt