ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I edit gridlines in one row (https://www.excelbanter.com/excel-discussion-misc-queries/11794-how-do-i-edit-gridlines-one-row.html)

JPeterH

how do I edit gridlines in one row
 
I want to create chart heading. When doing this, I need to erese the column
sperators in the first two rows, only. I tried it, in "format cells," but to
no avail. Is there some way to do this or do I need to create my accounting
chart, then edit it in Powerpoint?

JulieD

Hi

unless you've selected otherwise gridlines don't print (file / page setup /
sheet tab) ... however you CAN merge the cells - select them and choose
format / cells / alignment tab - merge cells but a better option (merged
cells can cause you problems if you ever want to sort or filter) would be to
select the cells where you want your heading (say A1:D1) and then choose
format / cells / alignment and in horizontal - "choose center across
selection" - now type your heading in A1 and it will appear centered across
the cells without them being merged.

- if you want borders to print but not gridlines - turn the printing of
gridlines off (file / page setup / sheet tab) - then select the cells you
want to put borders around and then use format / cells / borders to do this.

Hope this helps
Cheers
JulieD

"JPeterH" wrote in message
...
I want to create chart heading. When doing this, I need to erese the
column
sperators in the first two rows, only. I tried it, in "format cells," but
to
no avail. Is there some way to do this or do I need to create my
accounting
chart, then edit it in Powerpoint?





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

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