ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Remove border (https://www.excelbanter.com/excel-discussion-misc-queries/449123-remove-border.html)

Stephen Wolstenholme[_3_]

Remove border
 
Excel 2007

How do I remove a border around cells that has been added previously?

The instructions in Help removes the border from the visible sheet but
not from Print Preview or the resulting print out.

Steve

--
EasyNN-plus. Neural Networks plus. http://www.easynn.com
SwingNN. Forecast with Neural Networks. http://www.swingnn.com
JustNN. Just Neural Networks. http://www.justnn.com


Ron Rosenfeld[_2_]

Remove border
 
On Wed, 07 Aug 2013 11:37:12 +0100, Stephen Wolstenholme wrote:

Excel 2007

How do I remove a border around cells that has been added previously?

The instructions in Help removes the border from the visible sheet but
not from Print Preview or the resulting print out.

Steve


Perhaps you are seeing gridlines?

On the Page Layout tab, in the Sheet Options group, DEselect the Print check box under Gridlines

Stephen Wolstenholme[_3_]

Remove border
 
On Wed, 07 Aug 2013 07:56:37 -0400, Ron Rosenfeld
wrote:

On Wed, 07 Aug 2013 11:37:12 +0100, Stephen Wolstenholme wrote:

Excel 2007

How do I remove a border around cells that has been added previously?

The instructions in Help removes the border from the visible sheet but
not from Print Preview or the resulting print out.

Steve


Perhaps you are seeing gridlines?

On the Page Layout tab, in the Sheet Options group, DEselect the Print check box under Gridlines


I have gridlines on because that's what want. I don't want a line
surrounding individual print pages. They must have been turned on
sometime is the past but I can't find a way to turn them off.

Steve

--
EasyNN-plus. Neural Networks plus. http://www.easynn.com
SwingNN. Forecast with Neural Networks. http://www.swingnn.com
JustNN. Just Neural Networks. http://www.justnn.com


Ron Rosenfeld[_2_]

Remove border
 
On Wed, 07 Aug 2013 13:16:25 +0100, Stephen Wolstenholme wrote:

I have gridlines on because that's what want. I don't want a line
surrounding individual print pages. They must have been turned on
sometime is the past but I can't find a way to turn them off.


Oh, I thought you wrote that you were concerned about a border around cells, not around the entire page (but I guess that could be considered around all of the cells).
I would check to see if someone has placed a drawing object -- rectangle -- on that page.

sumesh pk

Remove border
 
On Wednesday, August 7, 2013 2:37:12 PM UTC+4, Stephen Wolstenholme wrote:
Excel 2007

Hi,


U can select particular cells then click right button then format cells, border , dis select lines



How do I remove a border around cells that has been added previously?



The instructions in Help removes the border from the visible sheet but

not from Print Preview or the resulting print out.



Steve



--

EasyNN-plus. Neural Networks plus. http://www.easynn.com

SwingNN. Forecast with Neural Networks. http://www.swingnn.com

JustNN. Just Neural Networks. http://www.justnn.com



All times are GMT +1. The time now is 11:10 PM.

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