Workbook default for borders

  • Thread starter Thread starter balogi
  • Start date Start date
B

balogi

I have a number of workbooks which began their lives in
Excel and the cell border setting is just fine. Nice dark
lines, etc.

Howver, I have other Excel files that were created from
Lotus 1-2-3 files. The cell border settings in these
files is not the same as the other files. The cell
border line is gray.

When I set a cell with a border and then click on Format,
cell, border and then click on Choose the black color,
the cell in question gets the desired format. But, no
where can I find a way to set the default cell border
this way for the whole workbook.

Isn't there a menu option to set cell border settings for
a whole workbook?
-gtb
 
Yes. You can make a template called Book.xlt or Sheet.xlt and put i
into your XLSTART folder when its contents will become your defaults.

You will still have to format it/them yourself. To format all cells i
a worksheet first selet them by clicking the grey box top left wher
row/column headings meet.

I guess that this will not solve this particular problem because Exce
is *changing the format when importing a 123 file*. (It is probably "
feature, not a bug" <grin>). You may prefer to record a macro and us
that
 
Back
Top