Basic operating ideas of Excel:
1. Decide the font according to the purpose and use. Consider resolution compatibility. It is best to use different fonts for numbers and text. The company or group department has unified font requirements.
Set the default font through excel, as follows
2. Pay attention to the idea of "blank space"
Leave the row height blank and do not use the default height.
Start the table from the second row and column. This will look better and make it easier to set the border, because the first row and column The border is often not visible when
Set column width
3, text is aligned to the left and values are aligned to the right
4, for numerical values
Numerical units, such as units, such as tons, use separate columns,
Use thousandths for numerical values, which looks better
5. The text should be indented. Use two columns to adjust to achieve the indentation effect.
6, set the border and color of the table according to the expression
7, set the background color of the protruding part
8. Name the worksheets and arrange them in order to remove useless worksheets.
9, try not to hide rows and columns, it is best to use the combination function
10, row, use cross-column centering to avoid merging cells.
11, reasonable use of comments
12. The wonderful use of slashes. Use slashes where there is no data. Hold down the Alt key while drawing a slash, which will automatically move closer to the cell.
13. When appropriate, double-click to start, hide the ribbon, expand the data display area, and double-click again to display it.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/Excel-de-ji-ben-cao-zuo-si-lu.html
支付宝扫一扫 
评论列表（196条）
测试