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.
Transcript of the video:
The MrExcel podcast is sponsored by Easy-XL.
Learn Excel From MrExcel, Podcast Episode 1783: Macro Faster Than CONTROL+P.
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Boy, this question got me scratching my head.
They said, hey, we would like a way to print that's faster than CONTROL+P, and I’m like, CONTROL+P, that's one keystroke, but I guess it's not really one keystroke anymore because it now brings up the print dialog and then you have to click PRINT again.
So, not really the way to go, but there is already a way to print with one click if you go to right into the quick access toolbar here, open this up, and choose QUICK PRINT.
Now, you have one-click access to printing.
You don't have to go through the print dialog, and I guess you could hold down the ALT key, and this keyboard shortcut will be different depending on where it is in your quick access toolbar, but if it's one of the first 7 or first 10, then, you know, it's simply just ALT and then 7.
So, ALT+7 will do a quick print, alright, but if you really wanted a macro, if you wanted to replace CONTROL+P, then let's go ahead and record a macro.
So, VIEW, MACROS.
We’ll RECORD A MACRO.
We’ll call it QUICKPRINT, and we'll assign it to CONTROL+P so that way it replaces CONTROL+P, and we're going to store it in the PERSONAL MACRO WORKBOOK, click OK, and all we’ll do is click the quick print icon, and then stop recording, alright, and we'll take a look at that code.
We’ll do ALT+F11, although you won't even have to take a look at this code.
It's there in MODULE2.
Just ACTIVEWINDOW.SELECTEDSHEETS.PRINTOUT COPIES = 1.
There we go.
So, now, we should just be able to come back here, select our sheet, CONTROL+P, and it does the old print the way they used to back in Excel 2007 without having to do the second click inside.
So, there you have it, a faster way to print, then CONTROL+P in Excel 2010 and 2013.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Learn Excel From MrExcel, Podcast Episode 1783: Macro Faster Than CONTROL+P.
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
Boy, this question got me scratching my head.
They said, hey, we would like a way to print that's faster than CONTROL+P, and I’m like, CONTROL+P, that's one keystroke, but I guess it's not really one keystroke anymore because it now brings up the print dialog and then you have to click PRINT again.
So, not really the way to go, but there is already a way to print with one click if you go to right into the quick access toolbar here, open this up, and choose QUICK PRINT.
Now, you have one-click access to printing.
You don't have to go through the print dialog, and I guess you could hold down the ALT key, and this keyboard shortcut will be different depending on where it is in your quick access toolbar, but if it's one of the first 7 or first 10, then, you know, it's simply just ALT and then 7.
So, ALT+7 will do a quick print, alright, but if you really wanted a macro, if you wanted to replace CONTROL+P, then let's go ahead and record a macro.
So, VIEW, MACROS.
We’ll RECORD A MACRO.
We’ll call it QUICKPRINT, and we'll assign it to CONTROL+P so that way it replaces CONTROL+P, and we're going to store it in the PERSONAL MACRO WORKBOOK, click OK, and all we’ll do is click the quick print icon, and then stop recording, alright, and we'll take a look at that code.
We’ll do ALT+F11, although you won't even have to take a look at this code.
It's there in MODULE2.
Just ACTIVEWINDOW.SELECTEDSHEETS.PRINTOUT COPIES = 1.
There we go.
So, now, we should just be able to come back here, select our sheet, CONTROL+P, and it does the old print the way they used to back in Excel 2007 without having to do the second click inside.
So, there you have it, a faster way to print, then CONTROL+P in Excel 2010 and 2013.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
