Cells in Microsoft Excel 2010 can be formatted in many ways.
Cells in an Excel spreadsheet can be formatted in a number of ways. Text attributes such as font family, size, color and style can be changed. Numbers can be formatted for particular uses such as zip codes, phone numbers or social security numbers, or can be stored using scientific notation or a set number of decimal places. The borders and shading of a cell can be formatted as can the alignment of the cell contents. Cells can also be locked or hidden to provide a certain level of data protection and ease of use.
Instructions
Select the Cells to Be Formatted
1. Click on a single cell to select the individual cell or move the active cell by using the keyboard arrow keys, "Enter" key or "Tab" key.
2. Click on a cell in one corner of a rectangular range of cells to be selected, and hold the mouse button down while dragging the cursor to the cell in the opposite diagonal corner. Release the mouse button to select the entire range of cells.
3. Click once on the row number or column letter to select an entire row or column, or select an entire sheet by clicking on the square button between the row 1 button and the column A button.
4. Click in the first cell of a range and hold down the "Shift" key while clicking on a cell at the other end of the range. Make multiple selections by holding down the "Ctrl" key and selecting various ranges.
5. Highlight advanced combinations of cells to select them by using the "Find & Select" tool from the "Editing" group of the "Home" tab on the ribbon.
Formatting Selected Cells
6. Right-click on one of the selected cells and choose "Format Cells" from the menu, or alternately choose one of the individual formatting options from the "Home" tab on the ribbon such as Font, Alignment or Number, or choose a predefined style from the "Styles" menu. Advanced formatting options are found under the "Format" button in the "Cells" group, including cell size, visibility and a link to the "Format Cells" dialog box.
7. Click one of the formatting tabs at the top of the "Format Cells" dialog box to access the options for the particular group of choices. These groups include Number, Alignment, Font, Border, Fill and Protection.
8. Change the format to reflect the best display of the particular data, and save the spreadsheet.
Tags: Format Cells, select entire, Cells dialog, Format Cells dialog, formatting options, Home ribbon