Home
Posted By: Gregg Excel borders - 04/04/10 08:52 PM
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)
Posted By: Virtual1 Re: Excel borders - 04/04/10 10:31 PM
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.
Posted By: Gregg Re: Excel borders - 04/05/10 12:27 AM
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.)
Posted By: Virtual1 Re: Excel borders - 04/05/10 05:37 PM
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.

Posted By: Gregg Re: Excel borders - 04/06/10 10:42 PM
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.
© FineTunedMac