I am using Excel 2000
I am having a senior moment. How do you get excel to print the light gray
lines, around all of the cells, not the black lines. I tried page setup,
but get black lines. I tried format cell and used the little dotted line,
but it still came out dark.
I want the lines to look like they do on the screen. I swear I have done
this before, but just because someone asked me how I do this - I can't think
of what I have done.
Can someone please help me?
Aurora
Click on FILE in the menu, select PAGE SETUP and click the SHEET tab. Locate
the GRIDLINES check box and turn it on.
Remove the borders, if any. from the cells in the worksheet, otherwise
you'll get the solid black borders.
--
Kevin Backmannquot;Auroraquot; wrote:
gt; I am using Excel 2000
gt; I am having a senior moment. How do you get excel to print the light gray
gt; lines, around all of the cells, not the black lines. I tried page setup,
gt; but get black lines. I tried format cell and used the little dotted line,
gt; but it still came out dark.
gt; I want the lines to look like they do on the screen. I swear I have done
gt; this before, but just because someone asked me how I do this - I can't think
gt; of what I have done.
gt; Can someone please help me?
gt; Aurora
gt;
gt;
Kevin: Thank you for answering, I tried this but still get black lines and
not the gray lines like they appear on the screen. I want what is on the
screen - light gray lines.
Do you have anyother ideas?
Aurora
quot;Kevin Bquot; wrote:
gt; Click on FILE in the menu, select PAGE SETUP and click the SHEET tab. Locate
gt; the GRIDLINES check box and turn it on.
gt;
gt; Remove the borders, if any. from the cells in the worksheet, otherwise
gt; you'll get the solid black borders.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Auroraquot; wrote:
gt;
gt; gt; I am using Excel 2000
gt; gt; I am having a senior moment. How do you get excel to print the light gray
gt; gt; lines, around all of the cells, not the black lines. I tried page setup,
gt; gt; but get black lines. I tried format cell and used the little dotted line,
gt; gt; but it still came out dark.
gt; gt; I want the lines to look like they do on the screen. I swear I have done
gt; gt; this before, but just because someone asked me how I do this - I can't think
gt; gt; of what I have done.
gt; gt; Can someone please help me?
gt; gt; Aurora
gt; gt;
gt; gt;
It sounds to me like you have border lines around your cells. Go to the
worksheet you're having difficulty with, and press Ctrl A, which selects
all the cells on the sheet.
From the menu click FORMAT and select CELLS. In the formatting dialog box,
click the BORDERS tab and in the PRESETS panel, click the NONE button to
remove any border lines you might have assigned.
Do a print Preview to see if the solid black border lines have left the
building.
--
Kevin Backmannquot;Auroraquot; wrote:
gt; Kevin: Thank you for answering, I tried this but still get black lines and
gt; not the gray lines like they appear on the screen. I want what is on the
gt; screen - light gray lines.
gt; Do you have anyother ideas?
gt;
gt; Aurora
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; Click on FILE in the menu, select PAGE SETUP and click the SHEET tab. Locate
gt; gt; the GRIDLINES check box and turn it on.
gt; gt;
gt; gt; Remove the borders, if any. from the cells in the worksheet, otherwise
gt; gt; you'll get the solid black borders.
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;Auroraquot; wrote:
gt; gt;
gt; gt; gt; I am using Excel 2000
gt; gt; gt; I am having a senior moment. How do you get excel to print the light gray
gt; gt; gt; lines, around all of the cells, not the black lines. I tried page setup,
gt; gt; gt; but get black lines. I tried format cell and used the little dotted line,
gt; gt; gt; but it still came out dark.
gt; gt; gt; I want the lines to look like they do on the screen. I swear I have done
gt; gt; gt; this before, but just because someone asked me how I do this - I can't think
gt; gt; gt; of what I have done.
gt; gt; gt; Can someone please help me?
gt; gt; gt; Aurora
gt; gt; gt;
gt; gt; gt;
If none of the other suggestions work, look for conditional formats in
the affected cells.Or check the print preview and printer settings. Is your printer setup to
print in grayscale or black and white?
quot;Mark Lincolnquot; wrote:
gt; If none of the other suggestions work, look for conditional formats in
gt; the affected cells.
gt;
gt;
Aurora, I know just what you mean. That has always bothered me too. And the
more you mess with the border settings the farther away you get from what you
want. Are you not wanting to print those nice light gray lines but you want
them to show up on screen like they do before you cleared them somehow? I
haven't figured out the solution yet but wanted you to know someone
understands.
quot;Auroraquot; wrote:
gt; I am using Excel 2000
gt; I am having a senior moment. How do you get excel to print the light gray
gt; lines, around all of the cells, not the black lines. I tried page setup,
gt; but get black lines. I tried format cell and used the little dotted line,
gt; but it still came out dark.
gt; I want the lines to look like they do on the screen. I swear I have done
gt; this before, but just because someone asked me how I do this - I can't think
gt; of what I have done.
gt; Can someone please help me?
gt; Aurora
gt;
gt;
- Dec 25 Tue 2007 20:41
Gray cell lines
close
全站熱搜
留言列表
發表留言