Excel - Macro Faster than Ctrl+P - Episode 1783
1,391 views · Published 4 September 2013 · 2:09 · Indexed 4 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Print Faster in Excel: One-Click Printing and Macro Shortcut. Welcome to the MrExcel podcast. In this episode, we will be discussing a question that had me scratching my head - how to print faster than using the shortcut CONTROL+P. While it may seem like a simple keystroke, the print dialog that pops up and requires an additional click can slow down the process. But fear not, there is a solution that will allow you to print with just one click. If you go to the quick access toolbar and add the "Quick Print" option, you can easily print with just one click. No more going through the print dialog. And if you want to make it even faster, you can use the keyboard shortcut ALT+7 (or whichever number corresponds to the position of the "Quick Print" option in your toolbar). But if you really want to replace the CONTROL+P shortcut, then let's record a macro. To record a macro, go to VIEW, MACROS, and select "Record Macro". Name it "QuickPrint" and assign it to CONTROL+P. Make sure to store it in the Personal Macro Workbook. Then, simply click the "Quick Print" icon and stop recording. The code for this macro can be found in MODULE2, but you won't even need to look at it. It's just one line of code that will print the selected sheet with one copy. Now, when you select a sheet and use the shortcut CONTROL+P, it will print without the need for an additional click. This is a much faster way to print in Excel 2010 and 2013. Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe for more helpful tips and tricks for mastering Excel. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Episode Topic: Macro Faster Than CONTROL+P (00:19) One-Click Printing Option (00:29) Using ALT Key Shortcut (01:00) Creating a Macro for Faster Printing (01:12) Recording the Macro (01:25) Viewing the Macro Code (01:36) Using the Macro for Faster Printing (01:55) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: ALT key shortcut Code in MODULE2 Faster way to print in Excel 2010 and 2013 Learn Excel From MrExcel Macro Faster Than CONTROL+P Personal macro workbook Podcast Episode 1783 Quick access toolbar Quick print Record a macro Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153604/ Someone asked if I could create a macro that would print faster than Ctrl+P. I am guessing they are upset about the extra click required after pressing Ctrl+P starting in Excel 2010. In today's episode, how to add QuickPrint to your Quick Access Toolbar and how to record a macro to your personal macro workbook to print in one keystroke.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920