Separating excel pages out (2007)

otuatail · #1 05-03-2017, 03:18 AM

I have an excel spreadsheet and one of the forms has a page with cell calculations. I hi-lighted a page and copied it (ctrl+c)

When I pace it into a new excel file. it does all this.
Adjust column widths
Copy the font correctly
Put borders around the correct cells

Even background and font colour.

What it fails to do is copy the cell calculations. All I get is the current value in the cell.

This seems stupid. I can't use paste special as there is no option for paste EVERYTHING.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
separating business and personal	Newmarket2	Outlook	0	01-11-2016 10:17 AM
Separating path from file name	KBo	Word	4	03-11-2015 01:45 PM
Excel 2007 Prints Multiple pages On 1 page overwriting everything	Persong	Excel	7	05-17-2013 02:24 PM
Separating endnotes from text	kenglade	Word	22	09-14-2012 04:10 PM
Separating accounts	aka252	Outlook	0	02-23-2006 07:55 PM