Apply Percent Formatting

This Excel tip covers applying Percent formatting to selected cells in an Excel spreadsheet using a keyboard shortcut.

The key combination that can be used to apply currency formatting to data is:

• Ctrl + Shift + 5

Example of How to Apply Percent Formatting using a Keyboard Shortcut

Note: For help with this example, see the image to the right.

1. Add the following data to cells A1 to B2: .98, -.34, 1.23, .03
   
   
2. Drag select cells A1 to B2 to highlight them.
   
   
3. Press and hold down the Ctrl and Shift keys on the keyboard.
   
   
4. Press and release the number five key ( 5 ) on the keyboard without releasing the Ctrl and Shift keys.
   
   
5. In cells A1 to B2 the data should be converted to a percent with the percent sign ( % ) added to the data.

Other Keyboard Shortcuts

• Apply Currency Formatting
• Applying Italics Formatting
• Add Borders in Excel