ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I hide cell outlines? (https://www.excelbanter.com/excel-discussion-misc-queries/210106-how-do-i-hide-cell-outlines.html)

MmhCC

How do I hide cell outlines?
 
I'm in Excel 2003. I have a workbook I inherited full of graphs that doesn't
show the cell outlines. When I add a new worksheet the cells are outlined.
Even if I copy and past one of the other sheets the outlines still show up.
How do I make them go away so all my sheets match?

Shane Devenshire[_2_]

How do I hide cell outlines?
 
Hi,

I'm not sure what you mean?

If you are talking about gridlines - you turn these on and off by choosing
Tools, Options, View tab, and checking or unchecking Gridlines.

If you are talking about border - click the top left corner of the
spreadsheet, above and to the left of cell A1 and choose Format, Cells,
Borders, None

If these help, please click the Yes button,

Cheers,
Shane Devenshire

"MmhCC" wrote:

I'm in Excel 2003. I have a workbook I inherited full of graphs that doesn't
show the cell outlines. When I add a new worksheet the cells are outlined.
Even if I copy and past one of the other sheets the outlines still show up.
How do I make them go away so all my sheets match?


Mike Rogers[_2_]

How do I hide cell outlines?
 
MmhCC

Those lines that outline a cell are called gridlines or cell borders. To
have them not show, goto ToolsoptionsView tab remove the check mark from
"Gridlines". If you do not want to print them either gotoFilePage
setupsheet Tab and remove the check mark from "gridlines". Now if you add
a color to the Borders (via FormatcellsBorder tab) neither of these will
work because excel will always take your changes of the border color and go
with it. I hope this helps

Mike Rogers

"MmhCC" wrote:

I'm in Excel 2003. I have a workbook I inherited full of graphs that doesn't
show the cell outlines. When I add a new worksheet the cells are outlined.
Even if I copy and past one of the other sheets the outlines still show up.
How do I make them go away so all my sheets match?



All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com