How to automatically enter decimal points in Microsoft Excel 2016 - Automatically enter decimal points tutorial

Time: 2022-08-19Source: Huajun Software TutorialAuthor: Xiaoyuer

Recently, some friends have consulted the editor about how to automatically enter decimal points in Microsoft Excel 2016? The following is a guide to Microsoft Excel Friends who need it can learn more about the method of automatically inputting decimal points in 2016.

Step 1: Open excel 2016 and create a new blank table (as shown in the picture).


Step 2: Click [File - Options] in the title bar (as shown in the picture).


Step 3: The "Options" dialog box will pop up (as shown in the picture).


Step 4: Click "Advanced" in the left column of the dialog box (as shown in the picture).


Step 5: Then check "Automatically insert decimal point" on the right. The default number of digits is 2 (as shown in the picture).


Step 6: Click "OK" in the lower right corner of the "Options" dialog box to complete the setting of automatic decimal point input (as shown in the figure).


The above is the entire content of how to automatically enter decimal points in Microsoft Excel 2016 brought to you by the editor. I hope it can help you.

Related articles更多>>

Popular recommendations