Tips for working in pocket excel – Asus P505 User Manual

Page 260

8-16

P505 Smart PDA Phone

Tips for working in Pocket Excel

Take note of the following when working in large spreadsheets in
Pocket Excel:

• View in full-screen mode

View in full-screen mode

View in full-screen mode to see as much of your spreadsheet
as possible. Tap View

V i e w

V i e w, then tap Full Screen

Full Screen

Full Screen. To exit full-screen

mode, tap Restore

Restore

Restore.

• Show and hide window elements.

Show and hide window elements.

Show and hide window elements. Tap View

V i e w

V i e w, then tap the

elements to show or hide.

• Freeze panes on a spreadsheet.

Freeze panes on a spreadsheet.

Freeze panes on a spreadsheet. First select the cell where
you want to freeze panes. Tap View

V i e w

V i e w, then tap Freeze Panes

Freeze Panes

Freeze Panes.

You might want to freeze the top and leftmost panes in a
spreadsheet to keep row and column labels visible as you scroll
through a sheet.

• Split panes

Split panes

Split panes to view different areas of a large spreadsheet. Tap
V i e w

V i e w

V i e w, then tap Split

Split

Split. Drag the split bar to where you want it. To

remove the split, tap View

V i e w

V i e w, then tap Remove Split

Remove Split

Remove Split.

• Show and hide rows and columns.

Show and hide rows and columns.

Show and hide rows and columns. To hide a row or column,
select a cell in the row or column that you want to hide. Tap
Format

Format

Format, then tap Row

R o w

R o w or Column

Column

Column, and tap H i d e

H i d e

H i d e. To show a

hidden row or column, tap Tools

Tools

Tools, then tap Go To

Go To

Go To, and type a

reference that is in the hidden row or column. Tap Format

Format

Format, then

tap Row

Row

Row or Column

Column

Column, and tap Unhide

Unhide

Unhide.

For more information on using Pocket Excel, tap

, then tap H e l p

H e l p

H e l p.