About Gridlines

[Analyst_Kumar]

How to disable the Gridlines for the unused cells in excel sheet.
(My data is located in cell range A1 to E900.)
Is there a VBA code for this ?
Is there any benefit of disabling Gridlines for unused cells ?

 

[NARAYANK991]

Hi ,

I doubt that you can disable the gridlines only for unused cells.

Show Gridlines is an option for the worksheet as a whole.

You can disable gridlines for the entire worksheet , and then use borders for the cells in the range A1 : E900.

Narayan

 

[Analyst_Kumar]

Hi ,

I doubt that you can disable the gridlines only for unused cells.

Show Gridlines is an option for the worksheet as a whole.

You can disable gridlines for the entire worksheet , and then use borders for the cells in the range A1 : E900.

Narayan

How it works in a Worksheet that has Pivot table ?

 

[NARAYANK991]

Hi ,

I have not understood your question ; what is the problem ?

Upload your workbook , if possible.

Narayan

 

[Deepak]

Analyst_Kumar

In a workaround you may just change the fill color to white/ else depending on your layout to hide the same.