Help with unformatting

Posted by Caractacus Potts PM | on Wed, 03/08/2011 - 09:14  937  3 comments | report

Hi Everyone

Please please can someone help.  I've received an excel file that has been formatted and I want to remove it.  It is probably simple but I don't know how to do it.  The file has page numbers, blue dotted lines and a thick blue line around the outside.  Can I remove it to just have the plain simple spreadsheet that I'm used to seeing and being able to manipulate.  I could live with it but when I print preview it is 28 pages long, although in truth it would only be about 8-10 if some of the pages were the correct length etc.

I'm using an older version of Excel, if anyone would be so kind as to point me in the right direction.

 

Thanks to all who read this.

 

Comments
completebookkeeping's picture

excel past format

completebookkeeping | Wed, 03/08/2011 - 09:24 | Permalink

Hi, have you tried copy and past special Values only !

kind regards Donna

You are in page preview mode

paulwakefield1 | Wed, 03/08/2011 - 09:28 | Permalink

It sounds as if you are in Page preview mode. To see the normal view, Select "View" "Normal view" (for versions up to Excel 2003).

 

Excel formatting

Caractacus Potts | Wed, 03/08/2011 - 09:30 | Permalink

Thanks, all solved, feel a bit stupid when it was so simple.

Kind regards

Add comment
Log in or register to post comments
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.
View all posts in this group
More posts from this group

Pages