Filter
Top Products
Extra programmes
251
• Freeze panes on a worksheet. First select the cell
where you want to freeze panes. Tap
View
and then
Freeze Panes
. You might want to freeze the top and
leftmost panes in a worksheet to keep the row and
column labels visible as you scroll through a sheet. To
exit, tap
View
and then
Unfreeze Panes
.
• Split panes to view different areas of a large
worksheet. Tap
View
and then
Split
. Then drag the
split bar to where you want it. To remove the split, tap
View
and then
Remove Split
.
• Show and hide rows and columns. To hide a hidden
row or column, select a cell in the row or column you
want to hide. Then tap
Format
, then
Row
or
Column
,
and then
Hide
. To show a hidden row or column, tap
Tools
→
Go To
, and then type a reference that is in the
hidden row or column and tap
OK
. Then tap
Format
→
Row
or
Column
→
Unhide
.