Format data by using shortcut keys:Format data by using shortcut keys:The following is a table of shortcut keys available for formatting data in a Microsoft Excel spreadsheet. The left column gives the desired action and the right column gives the associated shortcut key.
| Desired Action | Shortcut Key |
|---|---|
| Display the Style command (Format menu). | ALT+' |
| Display the Cells command (Format menu). | CONTROL+1 |
| Apply the General number format. | CONTROL+SHIFT+~ |
| Apply the Currency format with two decimal places (negative numbers appear in parentheses). | CONTROL+SHIFT+$ |
| Apply the Percentage format with no decimal places. | CONTROL+SHIFT+% |
| Apply the Exponential number format with two decimal places. | CONTROL+SHIFT+^ |
| Apply the Date format with the day, month, and year. | CONTROL+SHIFT+# |
| Apply the Time format with the hour and minute, and indicate A.M. or P.M. | CONTROL+SHIFT+@ |
| Apply the Number format with two decimal places, 1000 separator, and – for negative values. | CONTROL+SHIFT+! |
| Apply the outline border. | CONTROL+SHIFT+& |
| Remove all borders. | CONTROL+SHIFT+_ |
| Apply or remove bold formatting. | CONTROL+B |
| Apply or remove italic formatting. | CONTROL+I |
| Apply or remove an underline. | CONTROL+U |
| Apply or remove strikethrough formatting. | CONTROL+5 |
| Hide rows. | CONTROL+9 |
| Unhide rows. | CONTROL+SHIFT+( |
| Hide columns. | CONTROL+0 |
| Unhide columns. | CONTROL+SHIFT+) |
Contact us at infotechaccess@server.rehab.uiuic.edu