If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel: How do I get rid of these lines?

Random · 2009-02-19 20:22:13

See the dotted lines going across and then down? They seem to show the print area. How do I hide these or whatever? Thanks

19-02-2009 8:22pm

#1

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

See the dotted lines going across and then down? They seem to show the print area. How do I hide these or whatever?

Thanks

0

Comments

#2 19-02-2009 8:25pm

10-10-20

Registered Users, Registered Users 2 Posts: 8,073 ✭✭✭

Join Date: March 2007

Posts: 7888

Goto 'File', 'Print Area', 'Clear Print Area'.

0
#3 19-02-2009 8:38pm

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

Tried that but it doesn't work.

0
#4 19-02-2009 8:44pm

Shocking

Closed Accounts Posts: 36 ✭

Join Date: February 2009

Posts: 33

Options>Advanced>Display options for this workbook>Untick Showpage breaks

0
#5 19-02-2009 8:56pm

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

Will try that one in work tomorrow!

0
#6 20-02-2009 8:26pm

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

The only "options" i could find was under Tools and I couldn't see an "advanced" option in there.

It's Excel 2003 if that helps.

Thanks

0
Advertisement
#7 20-02-2009 10:28pm

slimjimmc

Registered Users, Registered Users 2 Posts: 7,786 ✭✭✭

Join Date: January 2003

Posts: 7434

Random wrote: »

The only "options" i could find was under Tools and I couldn't see an "advanced" option in there.

It's Excel 2003 if that helps.

Thanks

Tools --> Options --> "View" tab. Untick "Page breaks"

0
#8 21-02-2009 4:34pm

Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

Will try it again in work on Monday.

0
#9 22-02-2009 11:40pm

fletch

Registered Users, Registered Users 2 Posts: 7,423 ✭✭✭

Join Date: July 2004

Posts: 6987

Are they printing out or you just want to stop them displaying??

0