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 趨勢
- 1. zendaya 5,328 posts
- 2. trisha paytas 1,826 posts
- 3. Apple TV 10.2K posts
- 4. No Kings 223K posts
- 5. #FanCashDropPromotion 1,434 posts
- 6. #เพียงเธอตอนจบ 1.94M posts
- 7. LINGORM ONLY YOU FINAL EP 1.91M posts
- 8. #FridayVibes 7,689 posts
- 9. #Yunho 28.6K posts
- 10. #SlideToMe 18K posts
- 11. GAME DAY 33K posts
- 12. Mamdani 290K posts
- 13. Arc Raiders 5,001 posts
- 14. Cuomo 125K posts
- 15. Good Friday 63.8K posts
- 16. Eli Roth N/A
- 17. Bolton 295K posts
- 18. Ramesh 4,540 posts
- 19. Justice 337K posts
- 20. Happy Friyay 1,727 posts
Something went wrong.
Something went wrong.