loverakp.blogg.se - Microsoft excel shortcut keys

Alt or F10: Press this key if you want to turn off key tips.Shift+F9: Perform calculations of all active worksheets.F9: For those who want to calculate every worksheet in all opened workbooks.

Alt+Q: When you want to go to the “Tell me what you want to do” box.Ctrl+F2: Want to switch to Print Preview? This shortcut will get the job done.Shift+F11: If you want to insert a new worksheet then use this shortcut.For example, if you type “TWC” in a cell or change the color of a font, you can perform those same actions in another cell by clicking the F4 key.

F4: This one is interesting because it allows the user to repeat the last command or action with just a single key.

Ctrl+W: When it’s time to close a workbook.

F12: If you want to open the Save As dialog box.

Ctrl+S: Use this shortcut to save a workbook.

Ctrl+O: This is for opening an existing workbook.

Ctrl+N: All about creating new workbooks.