Working with Spreadsheets

Formatting Text

In Spreadsheets, you can access cell and text formatting options in the Edit toolbar. From there, you can format text, select cell alignment, and change number options. You can also insert, remove, hide, and lock rows and columns from this toolbar.

The Edit Toolbar

Using Colors in Cells

To add a background color to a cell:

1
Select a cell or group of cells.
2
From the Edit toolbar, click the drop-down arrow for Background Color
3
Select a color to fill the cell(s).

Background fill

If you'd like to use a color that is not in the color selector, enter the six-digit hexadecimal code for that color in the Custom Colors field. Click Add to save the color to the bottom of the color selection menu.

Adding custom colors

Sorting Data

You can sort data for one column or the entire table using the Sort feature.

To sort data in a column:

1
Click a column header to select the column.
2
From the Data toolbar, click Sort .

Sorting columns

To sort a range of data:

1
Select the range you want to sort.
2
From the Data toolbar, click Sort .
3
If the selection has a header row, check Selection includes header row.
4
Select the column you want to sort by from the drop-down menu and choose alphabetical (A → Z) or reverse alphabetical (Z → A).
5
Click Sort.

Sorting a data range