Зміст курсу
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
.
Завдання
- 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.
Завдання
- 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.
Все було зрозуміло?
Choose your 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
.
Завдання
- 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.
Завдання
- 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.
Все було зрозуміло?
Choose your 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
.
Завдання
- 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.
Завдання
- 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.
Все було зрозуміло?
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
.
Завдання
- 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.