Thứ Sáu, Tháng Hai 7, 2025
spot_img
HomeFinanceExcel 2016 - Lesson 7: Excel spreadsheet format

Excel 2016 – Lesson 7: Excel spreadsheet format

All cell contents use formatting by default, which can make reading a spreadsheet containing a lot of information more difficult. Basic formatting can customize the look and feel of your spreadsheet, allowing you to focus attention on specific sections and making the content in your spreadsheet easier to see and understand. Here it is Instructions for formatting data cells in Excel 2016. We invite you to consult!

Format 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.

Select the cell(s) you want to modify.

2. On the Home tab, click the drop-down arrow next to the command Font Size (font size), then select the font size you want. In the example, we will choose a 24 font to make the text larger.

Select the font size you desire

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

The text will change to the selected font size.

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

Font size

Change the font

By default, each new spreadsheet's font is set to Calibri. However, Excel 2016 offers 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.

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

2. On tab Home (Home), click the drop-down arrow next to the command Fontthen select the font you want. In the example, we choose Century Gothic.

Choose Century Gothic

3. The text will change to the selected font.

Xem thêm  8 best X (Twitter) alternatives

The text will change to the selected font.

When creating spreadsheets at work, you'll want to choose a font that's easy to read. With Calibristandard reading fonts included Cambria, Times New Roman and Arial.

Change font color

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

Select the cell(s) you want to modify.

2. On tab Home (Home), click the drop-down arrow next to the command Font Colorthen select the desired text color. In the example, we choose blue.

Choose blue

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

The text will change the selected font color.

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

Select More Colors

Use Bold, Italic and Underline commands

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

Select the cell(s) you want to modify.

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

Bold selected cells

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

The selected style will be applied to the text.

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

Cell border and fill color

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

Add fill color

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

Select the cell(s) you want to modify.

2. On tab Homeclick the drop-down arrow next to the command Fill Color (Fill), then select the fill color you want to use. In the example, we will choose dark gray.

Select the fill color you want to use

3. The selected fill color will appear in the selected cells. We also changed the font to white so it can be read with darker colors.

Xem thêm  How to download certificates and certificates of merit Trang Nguyen Vietnamese

The selected fill color appears in the selected cells

Add borders

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

Select the cell(s) you want to modify.

2. On the Home tab, click the drop-down arrow next to the command Bordersthen choose the border style you want to use. In the example, we will choose display All Borders.

Select show All Borders

3. The selected border style appears.

The selected border style appears.

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

Cell format types (Cell)

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

Apply Cell styles

In the example, we'll apply a new cell style to the title cell and the current title cell.

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

Select the cell(s) you want to modify.

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

The selected cell style appears.

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

Align text

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 allows you to choose how content is displayed in any cell, which can make your cell content easier to read.

  • Left Align: Left alignment.

Left Align

  • Center Align: Center alignment.

Center Align

  • Right Align: Align right.

Right Align

  • Top Align: Align the content with the top border of the cell.
Xem thêm  What do the heart colors on Messenger mean?

Top Align

  • Middle Align: Center the content with equal distance from the top and bottom of the cell

Middle Align

  • Bottom Align: Align the content with the cell's bottom border.

Bottom Align

Align text horizontally

In the example below, we'll modify the header cell arrangement to make it easier to see and distinguish from the rest of the spreadsheet.

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

Select the cell(s) you want to modify.

2. Choose one of the three horizontal alignment commands on the tab Home. In the example, we will choose Center Align (Center aligned).

Select Center Align

3. The text will be realigned.

The text will be re-aligned.

Align text vertically

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

Select the cell(s) you want to modify.

2. Choose one of three vertical alignment commands on the Home tab. In the example, we will choose Middle Align (Center aligned).

Select Middle Align

3. The text will be realigned:

The text will be re-aligned.

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

Copy formatting (Format Painter)

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

Format Panter in Excel

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

Have fun!

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments