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 this||Do this|
|A single cell||Click on the cell.|
|A group of cells||Click on the first cell, and drag to the last cell.|
|A whole column||Click on the letter at the top of the column.|
|A whole row||Click on the number on the side of the column.|
|Multiple columns or rows||Click on a column letter or row number, and drag to select additional columns or rows.|
|All cells in a data region||Click on a cell in the region and push ctrl-A.|
|All cells in the entire sheet||Click 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 this||Do this|
|Make the text bold or italic||Click on format_bold or format_italic.|
|Change the text color||Click on format_color_text to select a color.|
|Change the cell color||Click on format_color_fill to select a color.|
|Set the number of decimal places||Click on .0 and/or .00.|
|Set the format of a number||Click on 123 to format the data as plain text, dates, percentages, etc.|
|Align the text||Click on format_align_left to choose left, center, or right alignment.|
|Set other aspects of the text||Use the settings in the Format menu.|