Formatting

There is a lot of information in this spreadsheet, but it is not very accessible. Customizing the formatting can make it more usable and nicer looking as well.

Cells can be selected individually, in blocks, or as entire rows, columns, or sheets.

To select thisDo this
A single cellClick on the cell.
A group of cellsClick on the first cell, and drag to the last cell.
A whole columnClick on the letter at the top of the column.
A whole rowClick on the number on the side of the column.
Multiple columns or rowsClick on a column letter or row number, and drag to select additional columns or rows.
All cells in a data regionClick on a cell in the region and push ctrl-A.
All cells in the entire sheetClick on a cell in the region and push ctrl-A twice.

Once cells are selected, they can be modified using the formatting tools in the formatting bar below the menu.

To do thisDo this
Make the text bold or italicClick on format_bold or format_italic.
Change the text colorClick on format_color_text to select a color.
Change the cell colorClick on format_color_fill to select a color.
Set the number of decimal placesClick on .0 and/or .00.
Set the format of a numberClick on 123 to format the data as plain text, dates, percentages, etc.
Align the textClick on format_align_left to choose left, center, or right alignment.
Set other aspects of the textUse the settings in the Format menu.
    ➜ Try it
  1. Select row 1, and make the text bold.
  2. Select rows 1 through 3, and change the cell color and/or the text color to your liking.
  3. Select column H, and align the text on the right. Also do this for the other columns with numerical data.
  4. Select column H again, and set the cells to have 2 decimal places.
  5. Position the curser on the line between A and B at the top of the columns so that the curser changes to a horizontal arrow. Adjust the width of the columns automatically by double-clicking, or manually by dragging. Also do this for the other columns.