Most of you use Microsoft Word frequently in your day-to-day work. See Below some of the most common use short-cuts for us typists. I would much rather keep my hands on my keyboard if I am typing a long or even short document than to stop and pick up that mouse......OR better yet –you can get around if your mouse breaks or runs out of batteries in the middle of a Document.
Most used EXCEL Short-cuts for Financial Analyst
- Ctrl+W. Close the active window / document.
- Ctrl+Z. Undo an action.
- Ctrl+Y. Redo the last action or repeat an action.
- Ctrl+S. Save a document.
- Ctrl+P. Print a document.
- Ctrl+K. Insert a hyperlink.
- Alt+Left. Arrow Go back one page.
- Alt+Right. Arrow Go forward one page.
- Ctrl+C. Copy selected text or graphics to the Office Clipboard.
- Ctrl+V. Paste the most recent addition to the Office Clipboard.
- Ctrl+Shift+A. Format all letters as capitals.
- Ctrl+B. Applies or removes bold formatting.
- Ctrl+I. Applies or removes italic formatting.
- Ctrl+=. Apply subscript formatting (automatic spacing).
- Alt, F, A. Save As.
- Alt, S, T, I. Insert Table of Contents.
- Alt, S, T, R. Remove Table of Contents.
- Alt, W, F. Full Screen Reading – View > Document Views > Full Screen Reading.
- Alt, W, R. Ruler. View > Show/Hide > Ruler.
- Alt, F, X. Exit Word.
- Ctrl + Shift + C (Copies the formatting of selected text)
- Ctrl + Shift + V (Pastes the formatting on selected text)
- Ctrl + Shift + > increase the point size of the font
- Ctrl +Shift + < decreases the point size
Most used EXCEL Short-cuts for Financial Analyst
- Alt+Enter: To insert a new line within a cell
- F2: To edit within a cell
- Shift+F2: Allows you to add comments in the cell.
- Ctrl+F2: Opens the print preview
- Ctrl+Enter: To fill selected cells with an entry you have typed in another cell.
- Ctrl+D or Ctrl+R: This key will help you to fill the data right or down through selected cells.
- Ctrl+F3: To create a name
- Ctrl ; (semi-colon) or Ctrl : (colon): To enter the current date and time
- F11: To create a chart from a range of the data
- Ctrl ~: Toggles the display of formulas.
- Ctrl+Z: Undo
- Ctrl+V: Multiple paste
- Ctrl+*: Select current region
- Shift+F11: Insert new work sheet
- Ctrl+N: Open new workbook
- Ctrl+X: Cut
- Ctrl+spacebar: select
- Shift+spacebar: Columns select rows
- Ctrl+B, Ctrl+U: Cells, Bold, Underline
- Ctrl+A: This shortcut is useful when you want to select the entire sheet or the current area.
- Ctrl+C, Ctrl+V: These shortcuts are useful when you want to copy and paste anything after selecting the region or anywhere else in the entire worksheet.
- Ctrl+Y: This helps you redo any of your previous action.
- Ctrl+F: This shortcut helps in finding any dialogue box.
- Ctrl+H: This shortcut will automatically help you in replacing any dialogue box. This is very useful when you want to find any text in Excel worksheet.
- Ctrl+Shift+Right / Ctrl+Shift+Down: Is for filling across the columns and rows. Use this shortcut instead of clicking and dragging within the cell to the right/ down.
- Alt+’: This shortcut is for applying the style quickly to your models as this shortcut brings up the style dialogue box.
- Ctrl+End: This shortcut helps you get to the end of your worksheet in a flash.
- F7: This shortcut helps you quickly check your spelling.