| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gray cell lines
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
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 Backmann "Aurora" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
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 "Kevin B" wrote: 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 Backmann "Aurora" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
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 Backmann "Aurora" wrote: 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 "Kevin B" wrote: 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 Backmann "Aurora" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
If none of the other suggestions work, look for conditional formats in
the affected cells. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
Or check the print preview and printer settings. Is your printer setup to
print in grayscale or black and white? "Mark Lincoln" wrote: If none of the other suggestions work, look for conditional formats in the affected cells. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gray cell lines
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. "Aurora" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I resize a cell in Excel to display two lines of data | Excel Discussion (Misc queries) | |||
| How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| ?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
| Multiple lines in 1 cell | Excel Discussion (Misc queries) | |||
Linear Mode
