Filter
Top Products
3.
Do one of the following:
●
On the Number tab, select a category and then specify the related formatting options.
●
On the Font tab, select the text formatting you want.
4. Tap OK.
Adjust column widths and row heights
1.
Select the column or row you want to change.
2.
Do one or both of the following:
●
If you selected a column or columns, adjust the width of the selected columns by dragging the
right border of the column heading.
●
If you selected a row or rows, adjust the height by dragging the lower border in the row
heading.
TIP: To specify an exact column width and row height, tap and hold the column or row, tap Format
Cells, enter the measurements on the Size tab, and then tap OK.
Fit rows and columns to data
1.
Select the rows or columns you want to automatically fit to their contents.
2.
Double-tap the lower border of the selected rows or the right border of the selected columns.
View the data you want
Adjust the view of the worksheet
In an Excel Mobile workbook, you can display and hide window elements such as scroll bars, view two
areas of a worksheet and lock rows or columns in one area by splitting or freezing panes, and use the
full screen to see as much data as possible.
▲
Do any of the following:
●
To display and hide window elements such as column headings and scroll bars, tap View >
Show, and then tap the elements you want displayed or hidden. A check mark appears next
to the element when it is visible in the workbook.
●
To lock rows and columns so that they remain visible while you scroll to see the rest of the
data, tap the cell where you want to freeze the panes. Then tap View > Freeze Panes. To
unlock the rows or columns, tap Unfreeze Panes.
●
To split the window into two scrollable areas, tap View, tap Split, and then drag the split
bar to a new location. To remove the split bar, tap View, and then tap Remove Split.
●
To see as much data on the screen as possible, tap View > Full Screen. To return to the
usual view, tap View > Full Screen again.
●
To zoom in on data, tap View > Zoom, and then tap the percentage you want.
80 Chapter 16 Use productivity tools