Excel global command?

Posted on 2009-02-22
Last Modified: 2012-05-06
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
Question by:tinman2372
    LVL 92

    Accepted Solution

    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?

    Author Comment

    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

    Author Comment

    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.

    Author Closing Comment

    Thanks a lot, it was pretty simple after all. Usually is when finally explained.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This article will show you how to use shortcut menus in the Access run-time environment.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now