Filter
Top Products
193
UUSSIINNGG TTHHEE PPOOCCKKEETT EEXXCCEELL FFIILLEE LLIISSTT
Pocket Excel contains a list of the files stored on your
device. The file list is the default window when you open
Pocket Excel. Every time you tap
OOKK
in an open
workbook, the file list will again be displayed.
!
Tap a file in the list to open it.You can open only one
workbook at a time; when you open a second workbook,
you'll be asked to save the first.
!
To delete, make copies of, and send files, tap and hold
a file in the list, then select the appropriate action from
the pop-up menu.
PPRROOTTEECCTTIINNGG YYOOUURR WWOORRKKBBOOOOKKSS
If your workbook contains sensitive information, you can
protect it with a password. Follow the steps below:
1. Open the workbook.
2. Tap
EEddiitt
, then
PPaasssswwoorrdd
.
3. Enter a password, then verify it.
192
4. Tap
OOKK
.
Every time you open the workbook, you will need to
enter the password, so choose one that is easy for you
to remember but hard for others to guess.
TTIIPPSS FFOORR WWOORRKKIINNGG IINN PPOOCCKKEETT EEXXCCEELL
Note the following when working in large worksheets in
Pocket Excel:
!
View in full-screen mode to see as much of your
worksheet as possible.
- Tap
VViieeww
, then
FFuullll SSccrreeeenn
.
- To exit full screen mode, tap
RReessttoorree
.
!
Show and hide window elements.
- Tap
VViieeww
, then tap the elements you want to show
or hide.
!
You might want to freeze the top and left-most panes
in a worksheet to keep row and column labels visible as
you scroll through a sheet.
1. Select the cell where you want to freeze panes.
2. Tap
VViieeww
, then
FFrreeeezzee PPaanneess
.
!
Split panes to view different areas of a large
worksheet.
1. Tap
VViieeww
, then
SSpplliitt
.
2. Drag the split bar to where you want it.
To remove the split, tap
VViieeww
, then
RReemmoovvee SSpplliitt
.
!
Show and hide rows and columns.
- To hide a row or column:
1. Select a cell in the row or column you want to
hide.
2. Tap
FFoorrmmaatt
,
RRooww
or
CCoolluummnn
, then
HHiiddee
.
- To show a hidden row or column:
1. Tap
TToooollss
, then
GGoo TToo
.
2. Type a reference that is in the hidden row or
column.
3. Tap
FFoorrmmaatt
,
RRooww
or
CCoolluummnn
, and then
UUnnhhiiddee
.
Tap to return to the spreadsheet list
(changes are saved automatically).
Cell contents appear
here as you enter them.
Zoom button
AutoSum button