An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Topic Options
#9201 - 04/04/10 01:52 PM Excel borders
Gregg Offline


Registered: 08/04/09
Loc: Milwaukee, WI (USA)
Office for Mac 2004
Excel 11.5.6
Epson Stylus Color 740

No matter what line style I choose, the output is the same - just a narrow solid line. I want to have some borders print with thicker lines, and some with dashed or dotted lines. Is this an Excel setting, or something with my printer?

(Also posted on Mr. Excel Message Board)

Top
#9204 - 04/04/10 03:31 PM Re: Excel borders [Re: Gregg]
Virtual1 Offline


Registered: 08/04/09
Loc: Iowa
The style changes should be visible immediately, and show up in preview, in addition to the printout. Are you even seeing the changes on the spreadsheet in excel?

Sometimes to change a border you have to remove the border entirely and then re-add it. Try selecting the no borders for the area to clear them all, and then set them again.
_________________________
I work for the Department of Redundancy Department

Top
#9208 - 04/04/10 05:27 PM Re: Excel borders [Re: Virtual1]
Gregg Offline


Registered: 08/04/09
Loc: Milwaukee, WI (USA)
No, they look the same on the screen also.

Yeah, did that. Cleared it, changed the line style, saved the file, made new border.

(No response yet on Mr. Excel, but about 40 threads jumped ahead of mine.)

Top
#9221 - 04/05/10 10:37 AM Re: Excel borders [Re: Gregg]
Virtual1 Offline


Registered: 08/04/09
Loc: Iowa
can you upload screen shots of the issue and maybe a copy of a spreadsheet having this problem? have you tried using excel on another machine to see if the problem goes away? try with a new xls and with the xls you are using.

_________________________
I work for the Department of Redundancy Department

Top
#9269 - 04/06/10 03:42 PM Re: Excel borders [Re: Virtual1]
Gregg Offline


Registered: 08/04/09
Loc: Milwaukee, WI (USA)
Finally an answer from "Mr. Excel"

In the Format > Cells dialog, Borders tab:
Select the style you want for the current cell. Now click one of the icons showing the position desired, then click OK.

I was selecting the style of line, then OK. Then I was going to the cells where I wanted that style and creating the borders. That didn't work.

Top

Moderator:  alternaut, dianne, dkmarsh