Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printing gridlines on part of sheet - Excel 2000

Status
Not open for further replies.
cahelmster

cahelmster

MIS
Jan 15, 2002
126
Is there any way to set a print area and specify part of the area to print gridlines and part of the area not to print gridlines?

Thanks!

----------------
Thanks!
CH [lookaround]
 
Sort by date Sort by votes
Under Print Setup go to the Sheet tab and there is a box to print Gridlines.

Thanks!
Barb E.
 
Upvote 0 Downvote
I've experimented with that and it looks like it applies to the whole sheet, not a specific cell range....



----------------
Thanks!
CH [lookaround]
 
Upvote 0 Downvote
Highlite the area you want and apply boxes around them...



Blue [dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Yes do that. Sorry I misunderstood your question. There is a border under formatting cells that is almost like a gridline (ie. not solid black, kind of grey and it looks like dashes).

Thanks!
Barb E.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
849
bs6600
bs6600
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
497
mintjulep
M
C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
1K
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
431
SkipVought
S
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
284
combo
combo

Part and Inventory Search

Sponsor

Back
Top