Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

If you have read the article about Microsoft Word, you must have grasped some basic knowledge about text alignment. Let's refer to the article on formatting spreadsheet data in Excel 2016 in this article!

All cell contents use default formatting, which can make it more difficult to read a spreadsheet with a lot of information. Basic formatting can customize the look of your spreadsheet, allowing you to focus your attention on specific parts and making the contents of your spreadsheet easier to see and understand. Here are instructions for formatting data cells in Excel 2016. Let's take a look!

 

Formatting in Excel 2016

Watch the video below to learn more about cell formatting in Excel 2016.

Change font size

1. Select the cell(s) you want to modify.

 

Picture 1 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. On the Home tab, click the drop-down arrow next to the Font Size command , and then select the font size you want. In our example, we'll choose 24 to make the text larger.

Picture 2 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The text will change to the selected font size.

Picture 3 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using the keyboard.

Picture 4 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Change font

By default, the font of each new spreadsheet is set to Calibri . However, Excel 2016 provides many other fonts that you can use to customize your cell text. In the example below, we'll format the header cell to help differentiate it from the rest of the spreadsheet.

 

1. Select the cell(s) you want to modify.

Picture 5 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. On the Home tab , click the drop-down arrow next to the Font command , and then select the font you want. In our example, we'll choose Century Gothic .

Picture 6 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The text will change to the selected font.

Picture 7 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

When creating spreadsheets at work, you'll want to choose a font that's easy to read. Along with Calibri , standard reading fonts include Cambria , Times New Roman , and Arial .

Change font color

1. Select the cell(s) you want to modify.

Picture 8 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. On the Home tab , click the drop-down arrow next to the Font Color command , and then select the desired font color. In our example, we choose blue.

Picture 9 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The text will change to the selected font color.

Picture 10 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

 

Select More Colors at the bottom of the menu to access additional color options. We changed the text to bright pink.

Picture 11 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Using Bold, Italic and Underline Commands

1. Select the cell(s) you want to modify.

Picture 12 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. Click the Bold ( B ), Italic ( I ), or Underline ( U ) command on the Home tab. In our example, we'll bold the selected cells.

Picture 13 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The selected style will be applied to the text.

Picture 14 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

You can also press Ctrl + B on your keyboard to bold selected text, Ctrl + I to italicize text, and Ctrl + U to underline text.

Cell borders and fill color

Cell borders and fills allow you to create clear, defined borders between different parts of your spreadsheet. Below, we'll add cell borders and fills to header cells to help distinguish them from the rest of your spreadsheet.

Add fill color

1. Select the cell(s) you want to modify.

Picture 15 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. On the Home tab , click the drop-down arrow next to the Fill Color command , and then select the fill color you want to use. In our example, we'll choose dark gray.

Picture 16 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The selected fill color will appear in the selected cells. We also change the font to white for readability with darker colors.

Picture 17 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

 

Add border

1. Select the cell(s) you want to modify.

Picture 18 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. On the Home tab, click the drop-down arrow next to the Borders command , and then select the border style you want to use. In our example, we'll choose to show All Borders .

Picture 19 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The selected border style will appear.

Picture 20 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

You can draw borders, change the border style and color of the border using the Draw Borders tool at the bottom of the Borders drop-down menu .

Cell Formatting Styles

Instead of formatting cells manually, you can use Excel's predefined cell styles. Cell styles are a quick way to add professional formatting to different parts of your spreadsheet, such as titles and headings.

Apply Cell styles

In the example, we will apply a new cell style to the current title cell and header cell.

1. Select the cell(s) you want to modify.

Picture 21 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. Click the Cell Styles command on the Home tab, and then select the desired style from the drop-down menu.

Picture 22 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Note : Applying a cell style replaces any existing cell formatting, except for text alignment. You may not want to use a cell style if you've added a lot of formatting to your spreadsheet.

Text alignment

By default, any text entered into a spreadsheet will be aligned to the bottom left of a cell, while numbers will be aligned to the bottom right. Changing cell content alignment lets you choose how the content is displayed in any cell, which can make your cell content easier to read.

  1. Left Align : Left Align.

Picture 23 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

  1. Center Align : Center Align.

Picture 24 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

  1. Right Align : Right Align.

Picture 25 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

  1. Top Align : Aligns the content with the top border of the cell.

Picture 26 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

  1. Middle Align : Centers the content with equal distance from the top and bottom of the cell.

 

Picture 27 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

  1. Bottom Align : Aligns the content with the bottom border of the cell.

Picture 28 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Align text horizontally

In the example below, we will modify the header cell arrangement to make it more visible and distinguishable from the rest of the spreadsheet.

1. Select the cell(s) you want to modify.

Picture 29 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. Choose one of the three horizontal alignment commands on the Home tab . In our example, we'll choose Center Align .

Picture 30 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The text will be realigned.

Picture 31 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Align text vertically

1. Select the cell(s) you want to modify.

Picture 32 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

2. Choose one of the three vertical alignment commands on the Home tab. In our example, we'll choose Middle Align .

Picture 33 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

3. The text will be realigned:

Picture 34 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Note : You can apply both vertical alignment and horizontal alignment to any cell.

Copy Format (Format Painter)

If you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click Format Painter, it will copy all the formatting from the selected cells. You can then click and drag across any cells you want to paste the formatting into.

Picture 35 of Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016

Watch the video below to learn two different ways to use Format Painter :

Have fun!

Update 29 December 2024
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile