1) Select the used range (Select A1, then type Shift-Ctrl-End)
2) On the Formatting palette, Border and Shading section, click the
Type pop-up button and choose the icon that looks like a window pane.
3) Click the Style button and choose the thicker line just below the
double line.
4) Click on the color button and select Gray-25%.
Takes me about 15 seconds on a 500 x 40 sheet. I suppose that could
be ridiculous...
Of course, if you had other borders, that would make it much more
labor intensive.
JE:
Sorry let me get this straight.
When you make a webpage of an Excel document Excel will not put the
gridlines in, correct?
But you can put the gridlines in manually.
So if I have a list of my favorites 5000 cd's with Artist info, I could
manually make a border around each name in 15 seconds or so? And then it
will look like my original excel document with gridlines? I would think
that would take a whole day to do.[/QUOTE]
No - it would take me a grand total of about 15 seconds to put the
borders around all 5000 records using the steps above.
You could also do it even faster (~ 1 second) using this macro (not
counting the time to paste in the macro) which I modified after
recording steps 1 - 4:
Public Sub GridBordersForWebPage()
With ActiveSheet.UsedRange
With .Borders
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 15
End With
End With
End Sub