Conteúdo do Curso
Excel Essentials
Excel Essentials
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
.
Tarefa
- 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.
Tarefa
- 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.
Tudo estava claro?
Escolha seu plano
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
.
Tarefa
- 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.
Tarefa
- 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.
Tudo estava claro?
Escolha seu plano
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
.
Tarefa
- 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.
Tarefa
- 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.
Tudo estava 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
.
Tarefa
- 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.