Extra programmes

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.

251