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

Watch on YouTube

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