Augustana College printing logo

Formatting Cells in Excel 2011 (Mac Version)

Cell Formatting

Font color, cell color, tab color, borders, and merging cells

Changing the Font Color

1) Select the cell(s) with the text that you want to change

2) Go to the Home tab

3) Go to the Font group

4) Click on the drop down arrow next to the box with the "A"

Change Font Color in Excel

Changing the Cell Color

1) Select the cell(s) you want to shade

2) Go to the Home tab

3) Go to the Font group

4) Click on the drop down arrow next to box with the paint can

5) Choose a color

Changing Cell Color in Excel

Change Tab Color

1) Right click (or ctrl + click) on the tab name

2) Choose "Tab Color" and pick the color you prefer

Change Tab Color in Excel

Adding Borders to Cells

1) Select the cells to which you want to apply a border

Note: If you hit command + "A" it will select your whole worksheet

2) Go to the Home tab

3) Go the Font group

4) Click on the drop down arrow next to the border icon (looks like four small squares that make up one larger square) and then choose what type of border you want to apply

Adding Borders to Cells in Excel

If you want to fine-tune the border settings:

1) Follow the preceding steps for "Adding Borders to Cells"

2) Click on "Border Options"

3) Choose the presets, borders, line styles, and line colors that you would like

Merging Cells

1) Select the cells you want to merge into one

2) Go to the "Home" tab

3) Go to the "Alignment" group

4) Click on "Merge"

If you want to unmerge your cells:

1) Select the cell that you want to unmerge

Note: If you want to merge the cells but not center the text - click the drop down arrow next to Merge and choose Merge Across

2) Click on Merge or click the drop down arrow next to Merge & Center and click Unmerge Cells