| WORKING WITH WORKSHEETS | |
| Move to the next sheet in the workbook | CTRL+PAGE DOWN |
| Move to the previous sheet in the workbook | CTRL+PAGE UP |
| DATA ENTRY | |
| Start a new line in the same cell | ALT+ENTER |
| Insert a hyperlink | CTRL+K |
| Insert a comment | SHIFT+F2 |
| Repeat the last action | F4 |
| MOVE AND SCROLL WITHIN WORKSHEETS | |
| Move to the beginning of the worksheet | CTRL+HOME |
| Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column | CTRL+END |
| Move one screen to the right | ALT+PAGE DOWN |
| Move one screen to the left | ALT+PAGE UP |
| FORMATTING | |
| Apply the General number format | CTRL+SHIFT+~ |
| Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values | CTRL+SHIFT+! |
| Apply the Currency format with two decimal places (negative numbers in parentheses) | CTRL+SHIFT+$ |
| Apply the Percentage format with no decimal places | CTRL+SHIFT+% |
| Apply the outline border to the selected cells | CTRL+SHIFT+& |
| Remove the outline border from the selected cells | CTRL+SHIFT+_ |
| BORDERING - in the FORMAT CELLS dialog box (CTRL+1) | |
| Apply or remove the top border | ALT+T |
| Apply or remove the bottom border | ALT+B |
| Apply or remove the left border | ALT+L |
| Apply or remove the right border | ALT+R |
| If cells in multiple rows are selected, apply or remove the horizontal divider | ALT+H |
| If cells in multiple columns are selected, apply or remove the vertical divider | ALT+V |
| Apply or remove the downward diagonal border | ALT+D |
| Apply or remove the upward diagonal border | ALT+U |
PS: please feel free to drop you excel/ word/ power point queries to mad.exceltips@gmail.com. I will try and respond as soon as I can. The more curious your question, the faster I respond.
This is useful list. I took a print out to keep at my desk. Thanks for sharing :)
ReplyDelete