[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

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?
0
RATPICK100
Asked:
RATPICK100
1 Solution
 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now