Need to print an Excel worksheet? Instead of going to the File tab, you can use the Ctrl + P keyboard shortcut to open Excel’s Print screen.
From there, you can preview your worksheet, choose a printer, adjust the print settings, and print your data.
How to Use Ctrl + P in Excel?
Follow these steps to print your worksheet using the keyboard shortcut.
1. Open your Excel workbook and select the worksheet you want to print.
2. Press Ctrl + P on your keyboard.
3. Excel opens the Print screen, where you can preview your worksheet and adjust the print settings.
4. Select your printer and make any necessary changes.
5. Click Print to print your worksheet.
Tip: Always check the print preview before printing to make sure your data fits properly on the page.
For more printing options, including page orientation, scaling, and print areas, read our complete guide on printing in Excel.
How to Print an Excel Worksheet Without a Keyboard Shortcut?
You can also open the Print screen using Excel’s File menu.
1. Click File.
2. Select Print.
3. Choose your printer and review the settings.
4. Check the preview.
5. Click Print.
Both methods take you to the Print screen. Ctrl + P is simply a quicker way to access it.
Ctrl + P vs. Ctrl + F2 in Excel:
Both Ctrl + P and Ctrl + F2 open Excel’s Print screen, where you can preview your worksheet and adjust the print settings.
| Keyboard shortcut | What it does |
| Ctrl + P | Opens the Print screen |
| Ctrl + F2 | Opens the same Print screen |
Both shortcuts let you review your worksheet before printing. Choose the shortcut that is easier for you to remember and use.
Note: The behavior of function keys can vary depending on your keyboard and laptop settings. You may need to press Fn + Ctrl + F2 on some keyboards.
Ctrl + P vs. Ctrl + S in Excel:
| Keyboard shortcut | What it does |
| Ctrl + P | Opens the Print screen |
| Ctrl + S | Saves changes to the current workbook |
Use Ctrl + P when you want to print your worksheet. Use Ctrl + S when you want to save your work.
Remember, Ctrl + P opens the Print screen. It doesn’t print your worksheet automatically. You need to click Print to send it to your printer.
Frequently Asked Questions:
1. What does Ctrl + P do in Excel?
Ctrl + P opens Excel’s Print screen, where you can preview your worksheet, choose a printer, adjust settings, and print your data.
2. Does Ctrl + P print the worksheet immediately?
No. It opens the Print screen, where you can review the preview and settings before clicking Print.
3. Can I print only selected cells using Ctrl + P?
Yes. Select the cells you want to print, press Ctrl + P, and choose Print Selection from the print settings.
4. Can I print all worksheets in a workbook?
Yes. Press Ctrl + P and select Print Entire Workbook from the print settings dropdown.
5. Why are some columns missing in the print preview?
Your worksheet may be wider than the selected paper size. Try Landscape orientation or use a scaling option such as Fit All Columns on One Page.
6. Does Ctrl + P save my Excel file?
No. Ctrl + P opens the Print screen. To save changes to your workbook, use Ctrl + S.
7. Can I save a worksheet as a PDF using Ctrl + P?
Yes. If your Excel version provides a PDF printer or a PDF option in the printer list, you can use it to save your worksheet as a PDF instead of printing on paper. You can also use Excel’s export options to create a PDF.
8. Where can I learn more about printing in Excel?
For detailed instructions on print settings, page orientation, scaling, print areas, and other printing options, read our [How to Print in Excel: Complete Guide](https://excellopedia.com/how-to-print-in-excel-complete-guide.html).
Final Thoughts:
The Ctrl + P shortcut is a quick way to open Excel’s Print screen without navigating through the File menu. Check the print preview, adjust the settings if needed, and click Print when you’re ready.
For more printing tips and step-by-step instructions, explore our complete guide to printing in Excel.
Explore more useful shortcuts in our Excel Keyboard Shortcuts guide.
Discover more from Excellopedia
Subscribe to get the latest posts sent to your email.