ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gridlines on Excel Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/122486-gridlines-excel-spreadsheet.html)

Office Jnr

Gridlines on Excel Spreadsheet
 
I want to Border an area on a spreadsheet and remove the gridlines does
anyone know how I can manage this.


Mia

Gridlines on Excel Spreadsheet
 
Hi


Border:
Mark the area and then choose either from borders in format-toolbar or
Format - cells - borders

Gridlines:

Tools - options - View, in this dialog uncheck Gridlines.

Mia



"Office Jnr" skrev:

I want to Border an area on a spreadsheet and remove the gridlines does
anyone know how I can manage this.


Gord Dibben

Gridlines on Excel Spreadsheet
 
Turning off gridlines from ToolsOptions turns them off on the entire sheet.

If you just want the area inside the bordered range to have no gridlines, format
the cells as White, not No Color which is the default.


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 06:17:01 -0800, Mia wrote:

Hi


Border:
Mark the area and then choose either from borders in format-toolbar or
Format - cells - borders

Gridlines:

Tools - options - View, in this dialog uncheck Gridlines.

Mia



"Office Jnr" skrev:

I want to Border an area on a spreadsheet and remove the gridlines does
anyone know how I can manage this.




All times are GMT +1. The time now is 05:02 AM.

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