Working with Spreadsheets

Formatting Text

In Spreadsheets, the cell and text formatting options are in the Edit tab. From there, you can format text, select cell alignment, and change number options. You can also insert or remove rows and columns, as well as lock cells from this tab.

image alt text

Using Colors

Select a color from the Background Color selector. 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 field at the bottom of the color selector. These colors will be saved at the bottom of the color selection menu.

image alt text

Sorting Data

You can sort data in one column or for the entire table using the Sort feature from the Data tab. Select a column or data range to sort and click Sort from the Data tab.

image alt text

For a data range, specify if the range includes a header row or not, select which column you want to sort, and how you want the data sorted. Then click Sort.

image alt text