Home >Topics >excel >How to set the borders and shading of a worksheet

How to set the borders and shading of a worksheet

藏色散人
藏色散人Original
2020-03-20 11:59:066467browse

How to set the borders and shading of a worksheet

How to set the border and shading of the worksheet?

Open Microsoft Excel2016 software.

Recommended: "excel tutorial"

How to set the borders and shading of a worksheet

Then click [Blank Workbook].

How to set the borders and shading of a worksheet

Enter the interface and enter some text and data.

How to set the borders and shading of a worksheet

#After selecting all, right-click and select the [Format Cells] option.

How to set the borders and shading of a worksheet

Then select the solid border line you want to add in the border options.

How to set the borders and shading of a worksheet

Then select the fill tab to add the shading color or pattern and click the [OK] button.

How to set the borders and shading of a worksheet

At this time, you will see the effect of adding borders and shading in the worksheet.

How to set the borders and shading of a worksheet

The above is the detailed content of How to set the borders and shading of a worksheet. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn