ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make only some gridlines print and some that wont? (https://www.excelbanter.com/excel-discussion-misc-queries/170413-how-make-only-some-gridlines-print-some-wont.html)

Captainbaldy

How to make only some gridlines print and some that wont?
 
I am making spreadsheets and at the top i need to have a few cells worth that
do not have gridlines and the rest in the sheet that do. Just about 6 or so.

Can anyone help me?

Bob I

How to make only some gridlines print and some that wont?
 
Put white background color in cells you want to suppress the grid on.

Captainbaldy wrote:

I am making spreadsheets and at the top i need to have a few cells worth that
do not have gridlines and the rest in the sheet that do. Just about 6 or so.

Can anyone help me?



Marcelo

How to make only some gridlines print and some that wont?
 
Hi another way, Tools | Options | View | uncheck the gridline, make the
borders as you want.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Captainbaldy" escreveu:

I am making spreadsheets and at the top i need to have a few cells worth that
do not have gridlines and the rest in the sheet that do. Just about 6 or so.

Can anyone help me?



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

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