![]() ![]() (white interior color will wipe out adjacent gridlines, but not borders) Select all cells, format, cells, patterns, Cell shading: no color ![]() Tools|customize|commands Tab|Forms category (near the bottom),įormatting of interior or background color: (#pattern)įormatting of interior (background color) will suppress affected gridlines.: You can create put your macro on a toolbar button. Page Setup, Sheet (tab), (uncheck) Draft Quality option Display of gridlines: (#display)ĭisplay of gridlines: File, Page Setup, SheetĪctiveWindow.DisplayGridlines = Not ActiveWindow.DisplayGridlines Your printer and your print drivers may have "Draft Quality", but Turn off Draft quality to see gridlines (#draft) ![]() ![]() Select All cells (Ctrl+A), Format, Borders (tab), Borders (none), Color (automatic) To Make sure you do not have color borders Select All cells (Ctrl+A), Format, Patterns (tab), cells color shading (none) To Make sure you do not have color within a cell (#wipeout)Ĭells with color override gridlines, to remove: Printing of gridlines: Tools, Options, View,Ĭell color and/or Borders wipe out gridlines:Īny color within a cell such as white, or any color borders such as white,ĭraft quality wipes out gridlines and interior color as can be previewed in Print Preview. Borders will always print with normal printing. This includes changes done withīorders can have various width, or doubling of lines, and canīe colored (format, Cells, borders). You can change the color with Tools, Options, ViewĪ very frequent complaint is loss of gridlines in display Purpose is so that you can see the cell boundaries when working on the worksheet. Gridlines are 1 pixel wide and you can have them visible or not you can have them print or not. Gridlines and Borders Gridlines and Borders ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |