145 Sheet
the sort case sensitive.
Sorting from left to right
You can also sort from left to right. Use this type of sorting if you want to
change the order of the columns in a table.
To sort from left to right:
1. Highlight the range of information that you want to sort, rows and
columns. Sheet doesn't sort information outside this range.
2. Select Sort Left-to-right on the Tools menu.
3. In the dialog, select the row that you want to use to order the columns and
specify the way that you want to sort. Click Options if you want to make
the sort case sensitive.
Changing the number format
Select Number on the Format menu to change the number format. You can
set the formats for the current highlighted range or all cells in the worksheet.
The number formats include general, triad (e.g. 3 000 000) and scientific
number display, as well as special formats for displaying text, currency, dates
and times, percentages, and also for a format for hiding the contents of cells.
Note! Some settings for the way numbers are displayed, e.g. the thousands
separator, are set on the Desktop screen.
You can use Sheet to create, format and print graphs based on information on
the worksheet, for example to show annual sales figures, or the distribution of
revenue.
You can create many types of graphs including line graphs, bar and column
graphs, scatter charts and pie charts, and can add to or alter many aspects of
the graph’s appearance by tapping on the area of the graph you wish to
change.
To create a graph:
1. Highlight a column or row of numbers in the Sheet view. This will be the
first range that your graph depicts. You can add other ranges later on to
build up your graph.
2. Tap the Graph button on the toolbar to move to the graph view. You will
see your graph displayed on the screen.
Use the Sheet and Graph buttons on the toolbar to switch between the two
views.
Replacing the graph range
When you create a graph, it is set to the range you first specified. It will reflect
changes to the data within that range, but will not reflect other ranges you
highlight on the worksheet.
GRAPHS
To Next Page
Loading...