Excel Keyboard Shortcut

Keyboard Shortcut to Open Print Preview Window In Excel

As an Excel user, you may find yourself frequently printing worksheets, charts, or tables. But what if you need to preview your printouts before actually sending them to the printer? That’s where the Open Print Preview Window comes in handy, allowing you to preview your document’s layout and make any necessary adjustments before printing.
The good news is that there is an Excel keyboard shortcut to quickly open the Print Preview window: Ctrl + F2. Here’s how to use it:
Select the worksheet or table you want to print.
Press Ctrl + F2 on your keyboard.
The Print Preview window should appear, allowing you to view your document’s layout, adjust margins, and make any other necessary changes before printing.
That’s it! With just a few simple keystrokes, you can easily preview your document and ensure that it looks exactly how you want it to before sending it to the printer.
Points to Remember:
The Ctrl + F2 keyboard shortcut works in Excel for Windows. If you’re using Excel on a Mac, the keyboard shortcut is Command + Option + P.
You can also access the Print Preview window by clicking on the “File” menu and selecting “Print Preview” from the options.
If you need to make any adjustments to your document’s layout in the Print Preview window, you can do so by clicking on the “Margins” button and selecting the appropriate margin settings.

Excel Keyboard Shortcut

Keyboard Shortcut to Print file In Excel

Printing an Excel file is an essential task for professionals and students alike. It allows you to share your data with others and create hard copies for reference. But, clicking through the Excel menus to print a file can be time-consuming. Luckily, there is an Excel keyboard shortcut that can save you time and effort. By pressing Ctrl + P (Windows) or ⌘ + P (Mac), you can quickly open the Print menu and start printing your file.
To use this shortcut, you need to have your Excel file open and ready to print. Once you are ready, press the keyboard shortcut combination, and the Print menu will appear. From there, you can select your printer and set your printing preferences, such as the number of copies, page orientation, and page size.
Notes and Points to Remember:
If you want to print a specific area or selection of cells, highlight the area before pressing the keyboard shortcut. This will open the Print menu with the selection pre-defined.
If you need to print multiple Excel files at once, you can select them all in File Explorer or Finder and press the keyboard shortcut. This will open the Print menu for all selected files simultaneously.
Be aware that the keyboard shortcut for Print may be different in other programs or applications. Always check the program’s documentation or help section for the correct shortcut.
In conclusion, the Excel keyboard shortcut for Print file is an excellent way to save time and streamline your printing process. By using this shortcut, you can open the Print menu with just a few keystrokes and quickly print your file. Remember to take note of the tips and points to remember to make the most out of this keyboard shortcut.

Excel Keyboard Shortcut

Keyboard Shortcut to Save workbook In Excel

Saving your Excel workbook regularly is crucial to prevent any data loss in case of unexpected events like power outages, system crashes, or accidental closures. While saving your workbook manually can be done by navigating through the ribbon, Excel provides a simple keyboard shortcut to save your workbook quickly.
To save your workbook using a keyboard shortcut on a Windows system, simply press Ctrl + S. On a Mac, use the ⌘ + S shortcut instead. When using the shortcut, Excel will save the current workbook to its current location, overwriting any previous versions of the file.
It’s important to note that using this shortcut won’t bring up the Save As dialog box, which allows you to change the filename or save location of your workbook. If you need to use Save As, you can either navigate to File > Save As from the ribbon or use the F12 keyboard shortcut on Windows (or ⌘ + Shift + S on Mac).
In conclusion, using the Ctrl + S (Windows) or ⌘ + S (Mac) keyboard shortcut is a quick and easy way to save your Excel workbook without the need to navigate through the ribbon. Remember to save your work regularly to prevent any data loss, and use the Save As option if you need to change the filename or save location of your workbook.

Excel Keyboard Shortcut

Keyboard Shortcut to Open workbook In Excel

Opening a workbook in Excel can be done quickly and easily using a keyboard shortcut. For Windows users, the shortcut is Ctrl + O, while Mac users can use ⌘ + O. Here’s how to use this keyboard shortcut:
Launch Microsoft Excel on your computer.
Press and hold the Ctrl key (Windows) or ⌘ key (Mac) on your keyboard.
While still holding the Ctrl/⌘ key, press the O key.
This will open the “Open” dialog box, where you can select the workbook you want to open.
Notes and Points to Remember:
The Ctrl + O (Windows) and ⌘ + O (Mac) shortcuts can be used not just in Excel, but also in many other programs to open a file.
The keyboard shortcut can save you time by eliminating the need to go to the File menu and click on Open.
If you frequently work with a particular workbook, consider pinning it to the Recent Documents list in Excel for even faster access.
Make sure to save your work regularly to avoid losing any changes.
Using keyboard shortcuts can help you work more efficiently in Excel and other programs. Give the Ctrl + O/⌘ + O shortcut a try next time you need to open a workbook in Excel!

Excel Keyboard Shortcut

Keyboard Shortcut to Create new workbook In Excel

Creating a new workbook in Excel is a task that is frequently performed. Using a keyboard shortcut to create a new workbook can help you save time and increase productivity. In this post, we will focus on how to create a new workbook in Excel using a keyboard shortcut.
The keyboard shortcut to create a new workbook in Excel is Ctrl + N for Windows and ⌘ + N for Mac. By pressing these two keys simultaneously, you can quickly create a new workbook without having to navigate through the Excel menus.
Here’s how to use the keyboard shortcut to create a new workbook in Excel:
Open Excel on your computer.
Press Ctrl + N on Windows or ⌘ + N on Mac.
A new workbook will be created, and you can start working on it right away.
Points to Remember:
The keyboard shortcut to create a new workbook in Excel is Ctrl + N for Windows and ⌘ + N for Mac.
This keyboard shortcut can be used to create a new workbook in all versions of Excel.
If you already have a workbook open, using this keyboard shortcut will create a new workbook without closing the existing one.
You can also create a new workbook by clicking the “File” tab in the Excel ribbon, then selecting “New” and “Blank workbook”. But, using a keyboard shortcut can save you time and make you more efficient.
In conclusion, using a keyboard shortcut to create a new workbook in Excel can help you save time and increase productivity. The keyboard shortcut to create a new workbook is Ctrl + N for Windows and ⌘ + N for Mac. Remember to use this shortcut the next time you need to create a new workbook in Excel.

Excel Keyboard Shortcut

Keyboard Shortcut to Toggle formulas on and off In Excel

Excel is a powerful tool for analyzing and organizing data. One of its most valuable features is the ability to display formulas in cells, which allows users to better understand how data is being calculated. However, constantly toggling between formulas and values can be time-consuming. That’s why knowing the Excel keyboard shortcut to toggle formulas …

Keyboard Shortcut to Toggle formulas on and off In Excel Read More »

Excel Keyboard Shortcut

Keyboard Shortcut to Save as In Excel

Saving your Excel file with a different name is a common task that many users perform frequently. One easy way to accomplish this task is by using a keyboard shortcut. In Excel, the keyboard shortcut to save a file with a new name is “F12” for Windows and “⌘ + ⇧ + S” for Mac.
To use the keyboard shortcut, simply follow these steps:
Open the Excel file you want to save with a new name.
Press “F12” on your keyboard (Windows) or “⌘ + ⇧ + S” (Mac).
A “Save As” dialog box will appear. Enter the new file name and choose the location where you want to save the file.
Click the “Save” button.
That’s it! You have now saved your Excel file with a new name using a keyboard shortcut.
Points to Remember:
The keyboard shortcut for “Save As” is not exclusive to Excel. You can use this shortcut in other Microsoft Office applications such as Word and PowerPoint as well.
The keyboard shortcut for “Save As” is different from the shortcut for simply saving the file. The shortcut to save a file without changing its name is “Ctrl + S” for Windows and “⌘ + S” for Mac.
Keyboard shortcuts can save you time and increase productivity, but it’s important to remember to use them in the correct context. Be sure to use the “Save As” shortcut only when you need to save the file with a different name or location.
If you have trouble remembering keyboard shortcuts, you can always find them listed in the Excel menu under “File > Save As” (Windows) or “File > Save As” (Mac), where the keyboard shortcut is also listed next to the command.

Scroll to Top