How to Enable Automatic Percent Entry

When enter data with percentage, you can enable automatic percent entry. Whenever you type 555, the value in the cell will become 555% (or 5.55 before formatting). To enable automatic percentage entry, please following steps below:

Step 1: Click the "File" Tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu in the dialog box;

Step 4: Check "Enable automatic percent entry" under the section of "Editing options";

Step 5: Click "OK" at the bottom.

Leave a Reply