ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL (https://www.excelbanter.com/excel-worksheet-functions/65708-re-gridlines-some-sheet-not-othr-parts-excel.html)

Patti

GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL
 
How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks

Dave Peterson

GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL
 
Remove all the gridlines
(Tools|Options|View tab)

Then add borders where you want them:
format|Cells|border tab


Patti wrote:

How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks


--

Dave Peterson

Gord Dibben

GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL
 
Patti

Select some cells and FormatCellsPattern set to "white".

The gridlines in that area will be covered over.


Gord Dibben MS Excel MVP

On Tue, 17 Jan 2006 12:15:03 -0800, "Patti"
wrote:

How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks




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

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