Can Get gridlines on A Web Page?

K

kevs

For the first time, I made a web page from an Excel document. I did, file,
save as web page. It put an html document on my desktop, but when it opened
it did not have gridlines. It's important that people see file with
gridlines, is this possible? For what it's worth, the gridlines box is
checked in page set up.
 
J

J.E. McGimpsey

kevs said:
For the first time, I made a web page from an Excel document. I did, file,
save as web page. It put an html document on my desktop, but when it opened
it did not have gridlines. It's important that people see file with
gridlines, is this possible? For what it's worth, the gridlines box is
checked in page set up.

AFAIK, gridlines are not rendered with Save As Web Page. You can
select your range and apply borders, which will be displayed. Note
that you may have to increase your border width to get an acceptable
rendering in HTML.
 
K

kevs

AFAIK, gridlines are not rendered with Save As Web Page. You can
select your range and apply borders, which will be displayed. Note
that you may have to increase your border width to get an acceptable
rendering in HTML.
Thanks JE:
Ok so you can get a border around the whole thing, but not gridlines on the
webpage? Is that correct?
 
J

J.E. McGimpsey

kevs said:
Ok so you can get a border around the whole thing, but not gridlines on the
webpage? Is that correct?

Yes, though if you put borders around each cell, the web page will
look like it has gridlines...

Again, the borders have to be fairly thick.
 
K

kevs

Yes, though if you put borders around each cell, the web page will
look like it has gridlines...

Again, the borders have to be fairly thick.

That¹s a ridiculous amount of work right? Kind of defeats the purpose of
why I use Excel in first place.
 
J

J.E. McGimpsey

kevs said:
That¹s a ridiculous amount of work right? Kind of defeats the purpose of
why I use Excel in first place.

Don't know about ridiculous...

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.
 
K

kevs

Don't know about ridiculous...

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.
 
J

J.E. McGimpsey

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
 
K

kevs

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.

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[/QUOTE]
JE:
Decided to hunker down and follow your instructions. Everything is great
except don't understand how to apply instanly the borders to the whole
document. I see a symbol for a pencil that you can apply a border piecemeal
one at a time, but don't see in your instructions method to get the border
around all cells in the file. Thanks!!!!!!!!!!
 
J

J.E. McGimpsey

kevs said:
Decided to hunker down and follow your instructions. Everything is great
except don't understand how to apply instanly the borders to the whole
document. I see a symbol for a pencil that you can apply a border piecemeal
one at a time, but don't see in your instructions method to get the border
around all cells in the file. Thanks!!!!!!!!!!

On the Formatting Palette, look for the Type button in the Borders
and Shading section. Click it and on the pop-up, select the second
button from the left on the top row - the All Borders button. This
will apply borders to all 4 sides of each cell in the Selection.

If you're not using the Formatting Palette, choose
Format/Cells/Border and click both the Outline and Inside Presets.
 
K

kevs

On the Formatting Palette, look for the Type button in the Borders and Shading
section. Click it and on the pop-up, select the second button from the left on
the top row - the All Borders button. This will apply borders to all 4 sides
of each cell in the Selection.

If you're not using the Formatting Palette, choose Format/Cells/Border and
click both the Outline and Inside Presets.
JE:
Yes! worked great. Thanks!!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top