Print your spreadsheet with the formulas. With your formulas displayed, you can print the spreadsheet just like you normally would. You can find the Print button on your Home tab, or in the File menu. You can also press Ctrl+P (Windows) or ⌘ Command+P (Mac) to open the Print window.
Hello,
It is about Invoice Sheet.
I wrote a macro for saving the actual sheet in a specific name format (Number of invoice_Name of client_Today Date) and in .xls and .pdf
It worked fine.
But if I try to print the sheet (CTRL P) before clicking my macro button, the macro saves only in .xls and not in .pdf and I have the 1004 Error : Method Exportasfixedformat of _Worksheet object failed
I have to reboot excel to avoid this 1004 error.
I would really really appreciate some help in order to print and then using my saving macro.
Home > Documents > Excel > Where is Print Preview in Microsoft Excel 2010 and 2013
Where is the Print Preview in Microsoft Excel 2010 and 2013
How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365? Just download Classic Menu for Office 2007 or Classic Menu for Office Kutools for Excel: 120 Powerful New Features for Excel. Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. |
In Microsoft Excel 2003, users can edit a worksheet before printing under “Print Preview” mode, such as zoom in and zoom out, set up pages, and provides an X button to close Print Preview. When upgrade to Microsoft Excel 2010 and 2013, they may be greatly different. Do you imagine use the Excel 2010/2013/2016/2019 function under the Excel 2003 interface? This article provides the ways to get the Print Preview, both with an add-in Classic Menu for Excel and in New Ribbon.
If you have Classic Menu for Excel 2010 installed, you can …
Method A:
With Classic Menu for Excel 2010 and 2013 installed, there will be a fast way in finding the Print Preview button. Click the Menus tab, and get the Print Preview button in the toolbars. The following picture shows its position as clear as possible.
Method B:
- Click Menus tab
- Click File tab, move to Print Preview.
- Click Print Preview, and there will be a Print Preview window popping up, just as what you use in Excel 2003.
![Preview Preview](/uploads/1/2/5/8/125878806/519775423.png)
If you have not Classic Menu for Excel 2010 and 2013 installed, you can …
Excel 2010/2013/2016/2019 improves and redesigns the backstage, which has added Print option into it. It combines the Print dialog, the most common Page Setup elements, and Print Preview. To get Print Preview, here is a simple way to go.
- Click File tab.
- Move to Print tab
- Or use the shortcut key Ctrl + P.
In this window, there are much more things you can do. By default you can set up printer, paper size , pages, and so on. The Print Preview function lies on the right of the window.
More Related Articles...
Classic Menu for Office
Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.
Classic Menu for OfficeIt includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. |
Classic Menu for Office 2007It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007. |