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 Essentials
course content

Contenido del Curso

Excel Essentials

Excel Essentials

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

Hiding 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.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 7. Capítulo 5

Elige tu plan

Hiding 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.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 7. Capítulo 5

Elige tu plan

Hiding 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.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

¿Todo estuvo claro?

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.

Tarea

  • Select columns H & I and right-click and choose Hide.
  • Select a row header and right-click to choose Hide.
  • Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
  • Select row 6 and go to the View tab and click Freeze Panes.

Sección 7. Capítulo 5
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
We're sorry to hear that something went wrong. What happened?
some-alt