Hi! I want set default gridlines in excel 2010. I do check gridlines but when I open new book then it no gridlines. Help me! Thanks!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Default gridlines
0
Answers
0
for displaying on the screen - go to File, Options, Advanced tab, Display options for this worksheet (make sure 'Show Gridlines' box is/has check mark in it.
there is also a Gridlines box on the View Tab. There is also a way to print grid lines on worksheets/ print out ranges - go to Print, Page Setup, Sheet tab (last one) and below 'Print' there is a check box for "Gridlines" which will print the gridlines on your output. I wasn't clear exactly what/where you are looking for gridlines....so have em all!
Give me some credit if you choose this. Thank you