Click here for AnswerPool.com Home page


Google

    AnswerPool.com  Hop To Forum Categories  Computers  Hop To Forums  Software    Another Excel question

Moderators: Dwight
Go
Post
Find
Notify
Tools
Reply
  
  Login/Join 
Diamond
Enthusiast

Picture of Tree
Posted
I know that you can switch gridlines off and on in page set-up, but I want to create 2 separate sets of columns on the same page - with gridlines only around these and NOT the entire page.

I know I can do it, but dunno where to look. I've been all over the place in excel tonite, without much luck on this! Roll Eyes

Thank you.
 
Posts: 5142 | Location: Not of this planet | Registered: 06-16-02Reply With QuoteEdit or Delete MessageReport This Post
Diamond Enthusiast

Picture of Georgia85
Posted Hide Post
The way I would do it would be to take off the gridlines in the Page Setup section. Then I would hi-light the 2 columns you wanted gridlines to appear in...and I'd use the border option for the look of gridlines. Do Format, Cells, select the Border tap and then in the Style box select the first style under None...it will look like a gridline when it prints. Make sure that you have selected all your border buttons where you want the border to appear.
 
Posts: 9192 | Location: Atlanta, GA, USA | Registered: 06-03-02Reply With QuoteEdit or Delete MessageReport This Post
Diamond
Enthusiast

Picture of Tree
Posted Hide Post
Thank Georgia!

It worked perfectly! Smile
 
Posts: 5142 | Location: Not of this planet | Registered: 06-16-02Reply With QuoteEdit or Delete MessageReport This Post
Diamond Enthusiast

Picture of Georgia85
Posted Hide Post
Yeh! Glad to hear it Tree. Sorry you had to wait so long for an answer tho.
 
Posts: 9192 | Location: Atlanta, GA, USA | Registered: 06-03-02Reply With QuoteEdit or Delete MessageReport This Post
Diamond
Enthusiast

Picture of Tree
Posted Hide Post
I didn't wait long, Georgia!

I posted it last nite and went to bed, then checked this morning and POOF there was your answer! Wink

Thanks again!
 
Posts: 5142 | Location: Not of this planet | Registered: 06-16-02Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

    AnswerPool.com  Hop To Forum Categories  Computers  Hop To Forums  Software    Another Excel question

© 2002-2008 AnswerPool.com



Visit DiscussionPool.com!