Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
QDE QDE is offline
external usenet poster
 
Posts: 2
Default I need finer (thinner) borders

Is there a way to make the borders finer so that they look as they do when
you opt to "print gridlines" without specifying each cell's border style? In
the "borders" selection, the finest line is too heavy for my form, but I
can't merely choose "print gridlines" because I don't want all gridlines to
print. (I'm using Excel 2002.)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 860
Default I need finer (thinner) borders

Hi QDE,

You can't make them any finer than the options in borders
in the formatting dialog box but you can drop the
color down to Gray-10% which will make them very pale.

HTH
Martin


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 860
Default I need finer (thinner) borders

I should also mention that the standard color palette only
offers Gray-25% as it lightest shade. To get it paler you
have to go to ToolsOptionsColor tab click on a color
patch and click on the modify button.

HTH
Martin


  #4   Report Post  
Posted to microsoft.public.excel.misc
QDE QDE is offline
external usenet poster
 
Posts: 2
Default I need finer (thinner) borders

Martin, thanks for your suggestion, but the effect was still too "heavy." I
kept pondering this and found that I can specify white borders where I don't
want the gridlines to print and that worked, since in this instance I'm
printing on white stock.

I do appreciate your taking the time to respond. Now maybe you can help me
with another problem that I'll put in a separate post!

"MartinW" wrote:

Hi QDE,

You can't make them any finer than the options in borders
in the formatting dialog box but you can drop the
color down to Gray-10% which will make them very pale.

HTH
Martin



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Borders not Printing L Lightner Excel Discussion (Misc queries) 0 July 18th 06 11:33 PM
Conditioning Formatting - Thicker Borders Fancy1 Excel Worksheet Functions 2 May 21st 06 04:35 PM
Print cell borders with special 'skin' DavieM Excel Discussion (Misc queries) 0 March 25th 06 10:52 PM
Cell borders and fill Marietta Excel Worksheet Functions 4 August 6th 05 04:29 PM
Using angled column headings and borders Lisa H Excel Discussion (Misc queries) 3 July 5th 05 04:30 PM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"