CtrlP to print directly to printer


How can you set up the ctrlP shortcut to print directly to the printer?  If I am in excel and I hit ctrlP it will bring up the File-Print page but I still need to click the print button to send it to the printer.

I know seems like a small thing but I have people who print all day and this is an extra step.

I am using Win7 Professional and MS Office 2010

Any help appreciated!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ken ButtersCommented:
Excel 2010  doesn't allow you to change shortcut keys via the customize Ribbon the same way that Word 2010 does.

Excel 2010 also does not allow you to override predefined Shortcut keys at all.

But there is a work-around.  You can create a macro to do it for you.

Steps :
1. Click on View tab
2. Click on Macros Button
3. Select Record Macro...
4. Give the macro a name, maybe something like "PrintActiveSheet"
5. Type p in the "Shortcut key:" box.  it should say "Ctrl+" and have a box next to it to type the 'p'.  make sure you don't hold down the shift key or any other key while typing the p.
6. "Change the Store macro in:" dropdown from "This Workbook" to "Personal Macro Workbook".  

Selecting to store it in "Personal Macro Workbook" will make the macro you are recording available to every workbook that you open on this particular PC.

7.  Add Description (Optional)
8.  Print this worksheet exactly how you want the macro to work.
9. Reselect the Macros / and select Stop Recording

CTRL-P should now print current sheet directly to printer.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MeowserMAuthor Commented:
Thank you for the detailed solution.  this worked for us
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.