EXCEL BORDERS

I AM TRYING TO ALTER THE CELL BORDERS ON A SPREADSHEET.  AFTER FOLLOWING THE 'FORMAT' ETC INSTRUCTIONS, THE BORDERS STILL REMAIN AS THEY WERE WHEN I STARTED.

THE AIM OF THE EXERCISE IS TO PRINT A SPREADSHEET WITH ALL THE BORDERS INTACT BUT OF A LESSER DENSITY THAN SEEMS TO BE THE DEFAULT.  HOW DO I ADJUST THEM PLEASE?
RATPICK100Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

StrudsCommented:
Hello,

I suggest making sure that when you're printing the spreadsheet with your custom borders, that you've disabled "gridlines" in File, Page Setup, Sheet. (i.e. File, Page Setup, click on Sheet tab, click OFF gridlines)

Also, check the line weight of the border(s) you're applying - perhaps they just need to be lighter.

Let us know how you go

Cheers
Struds
0
antratCommented:
Hi RATPICK100

To alter the cell borders do this

1:Highlight the area you want to format.

2:Right click and select "Format Cells" the click the "Border" tab.

3:From the "Color" box select the color you want.

4:from the "Style" box on the right select the type of line you want by clicking it.

4:Select the "Outline" box and then the "Inside" box. then click OK.


When you want to print, highlight the area again then go to File>Print Preview and select "Set Up" then click the "Sheet" tab and check the "Gridlines" box.


good luck

antrat

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RATPICK100Author Commented:
It was the checking on the border boxes that did the trick.  If you don't do that, it just returns to it's default.

Muchos Gracias and a very happy New Millenium!!


Thanks Patrick

p.s. don't quite understand the system, but this was Antrat's answer.

The Strud answer was what we were already doing, but thanks anyway.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.