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.
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.
3. 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.
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.
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.
3. 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.
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.
3. The text will change to 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.
Use Bold, Italic and Underline commands
1. 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.
3. 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.
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.
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.
Add borders
1. 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.
3. 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.
2. Click the command Cell Styles on the Home tab, then select the desired style from the drop-down menu.
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.
- Center Align: Center alignment.
- Right Align: Align right.
- Top Align: Align the content with the top border of the cell.
- Middle Align: Center the content with equal distance from the top and bottom of the cell
- Bottom Align: Align the content with the cell's bottom border.
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.
2. Choose one of the three horizontal alignment commands on the tab Home. In the example, we will choose Center Align (Center aligned).
3. The text will be realigned.
Align text vertically
1. 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).
3. The text will be realigned:
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.
Watch the video below learn two ways to use it Format Painter different:
Have fun!