ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   text on worksheet with no gridlines (https://www.excelbanter.com/excel-worksheet-functions/184555-text-worksheet-no-gridlines.html)

Carol

text on worksheet with no gridlines
 
I have a word document that I want to put into excel (due to some
calculations that need to be done now). I have text at the top of the
document that I don't want to have gridlines in...so how do I get rid of
gridlines for the text portion of this document only. I need gridlines in
the body of the document due to the columns I have.

thanks to anyone that can answer this for me

Pimamedic

text on worksheet with no gridlines
 
You could use separate sheets and do gridlines on the one and no gridlines on
the other

"Carol" wrote:

I have a word document that I want to put into excel (due to some
calculations that need to be done now). I have text at the top of the
document that I don't want to have gridlines in...so how do I get rid of
gridlines for the text portion of this document only. I need gridlines in
the body of the document due to the columns I have.

thanks to anyone that can answer this for me


BoniM

text on worksheet with no gridlines
 
Select the range that contains text and apply a white fill color to the cells
- or any color, actually - gridlines are not displayed when there is a fill
color in the cell.

"Carol" wrote:

I have a word document that I want to put into excel (due to some
calculations that need to be done now). I have text at the top of the
document that I don't want to have gridlines in...so how do I get rid of
gridlines for the text portion of this document only. I need gridlines in
the body of the document due to the columns I have.

thanks to anyone that can answer this for me



All times are GMT +1. The time now is 02:45 PM.

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