• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Excel global command?

I want to be able to print gridlines (Excel 2007) on each worksheet in a workbook of several sheets. I realize I can go to Page Layout and get the Print Gridlines command, but seems this has to be done on each sheet, one at a time.
Other than create a macro for this purpose, is there a simple way to accomlish this?
Thank you
0
tinman2372
Asked:
tinman2372
  • 3
1 Solution
 
Patrick MatthewsCommented:
If you select multiple worksheets at one time, you can modify the page setup on all of them to print gridlines.

You can also use the workbook's BeforePrint event to enforce the setting.  ARe you interested in that approach?
0
 
tinman2372Author Commented:
I am not familiar with the BeforePrint event. Also, not sure how you select more than one sheet at a time. Sorry I must appear not too bright. I tried clicking on the sheet tabs and using the Ctrl key when selecting the next, but that didn't work. Maybe you could enlighten me further. Thanks
0
 
tinman2372Author Commented:
Matthew. I discovered that by right clicking any sheet tab I get the option to "select all sheets", then was able to use Page Layout and select Print Gridlines on the first and it held up for all, I think you solved my problem.
0
 
tinman2372Author Commented:
Thanks a lot, it was pretty simple after all. Usually is when finally explained.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now