You might like
CTRL+S Saves the active file with its current file name, location, and file format.
CTRL+P Displays the Print tab in Microsoft Office Backstage view. CTRL+SHIFT+P opens the Format Cells dialog box with Font tab selected.
CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+A Selects entire worksheet. If worksheet contains data, CTRL+A selects current region. CTRL+A a second time to select entire worksheet.
F11 Creates a chart of the data in the current range in a separate Chart sheet. SHIFT+F11 inserts a new worksheet.
F9 Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet.
F4 Repeats last command or action. When a cell reference is selected, F4 cycles between combinations of absolute & relative references.
F1 displays Help. CTRL+F1 displays/hides ribbon. ALT+F1 creates embedded chart of data in current range. ALT+SHIFT+F1 inserts worksheet.
To calculate someone's age as of today, type; =INT((TODAY() – DATE(2001,1,1))/365.25) , but putting their D/O/B in the DATE brackets.
Press Alt key to see the keyboard shortcuts for each tab on the ribbon. Press the key that's related to tab to see map of keyboard shortcuts
To add custom lists: choose 'File | Options' > Select 'Excel Options | Popular | Edit Custom Lists' > 'New List' > 'List Entries' column.
To copy a chart or cells as a picture to a location outside Excel; Select range > click arrow below 'Paste' > As Picture | Copy As Picture
To add a SUM function and do it with a simple keystroke; Type Alt + = and Excel adds the function automatically to the current cell.
To resize multiple charts; click on first chart > hold down Ctrl > click other charts > right-click any of them > choose Size & Properties
Press "Ctrl" then "[" to highlight all cells referenced by a formula & move to first of the cells. Press Enter to move to the next cell.
Press CTRL and X to "cut" an object; CTRL + C to "copy"; CTRL + V to "paste"; CTRL + Z to "undo"; CTRL + Y to "redo".
Press CTRL key plus number 2 to embolden a cell; CTRL + 3 for italics; CTRL + 4 for underlining; CTRL + A to select whole worksheet.
To select a range of cells without having to click and drage the mouse: Click in first cell > press F8 > click in last cell > press F8 again
To insert a fixed date into a cell (a date that you don't want to change), hold down the CTRL key while you press the semicolon key ( ; )
![thewhiskeymonk's profile picture. [Insert profound bio statement.]](https://pbs.twimg.com/profile_images/1204435280855552003/pN9eEOm6.jpg)
United States Trends
- 1. Packers 91.8K posts
- 2. Packers 91.8K posts
- 3. Caleb Williams 36.7K posts
- 4. Malik Willis 15.1K posts
- 5. DJ Moore 27.2K posts
- 6. #BearDown 4,492 posts
- 7. Nixon 12.1K posts
- 8. Ben Johnson 9,655 posts
- 9. Doubs 8,889 posts
- 10. Oregon 35.7K posts
- 11. Clippers 8,096 posts
- 12. Jordan Love 12.8K posts
- 13. Bowen 12.4K posts
- 14. #GoPackGo 7,813 posts
- 15. #GBvsCHI 3,197 posts
- 16. Cher 36.6K posts
- 17. Tulane 32.2K posts
- 18. #Toonami 2,183 posts
- 19. GOOD BETTER BEST 3,740 posts
- 20. LaFleur 4,341 posts
Something went wrong.
Something went wrong.