Formatting Cells
Formatting Cells
Customizing Fonts
Format Numbers
format_numbers
Change Column Widths
Align Data
Applying Shading
Applying Borders
Apply Borders
To distinguish among different data in a worksheet, you can apply borders to cells, shade cells with a background color, or shade cells with a color pattern. As with other types of formatting, cell borders may be applied to all or part of your spreadsheet.
To define a border for a cell(s):
- Format Cells Drop Down Menu
- Select the cell(s) to configure.
- Navigate to the Home Tab/Font Group pull down arrow.
- Click on the Border tab.
- Choose the appropriate settings (color, size, and style of cell border).
- Click OK.
EXCEL EXTRAS
You may also use the Borders Icon on the Home Tab/Font Group to apply a border to a cell.
