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

Зміст курсу

Excel for Beginners

Excel for Beginners

1. Working with Worksheets and Workbooks
2. Basic Formulas and Functions
3. Data Management and Analysis
4. Visualizing Data with Charts and Graphs
5. Entering and Formatting Data
6. Advanced Formulas and Functions
7. Introduction to Excel

bookHiding and Unhiding Columns and Rows

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.

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 1. Розділ 5
some-alt