What are the small details that make your Excel look professional

Source: Internet
Author: User

Note that these small details make your issue of Excel look professional.

1. Keep only the sheet pages used

Create a new workbook, by default there are 3 sheet pages, if you only use 1, then delete the other two.

2. Font consistency

Unless you need to, keep the font size of the entire workbook as consistent as possible.

3. Numerical processing

For the convenience of the report, the number of decimal digits in a column is consistent and the Chiphi is used as much as possible.

4. Be careful with the cell background fill

In general, do not use cell background padding, if you want to emphasize some of the data, you only need to make these data font bold or font color to bright.

5. Name the sheet tabs

If you have 2 or more worksheets in a workbook, you need to name each worksheet.

6. Set the active cell location

Before you close Excel, move the cursor to the beginning of the data and save it so that others can open it and see the data you want to show, rather than moving the mouse.

7. Freeze Panes If necessary

If there are more rows of data that cannot be displayed on one page, you need to freeze the panes.


If you are interested in Excel, you can watch my course

Free courses:

Flexible application of Excel scatter bubble chart

Fee Courses:

Excel to learn advanced skills with simple tables

This article from the "12087654" blog, reproduced please contact the author!

What are the small details that make your Excel look professional

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.