Copy/Paste Functions and Formatting

  • Thread starter Thread starter aresar
  • Start date Start date
A

aresar

I have a slight problem.

I created a master spreadsheet and saved it as something else to run
test.

There were some functions that needed fixing and I decided to add som
formatting. The problem is that I made these changes in the test fil
and not the master file.

Is there any way to get these functions and formatting (which contain
patterns and conditional formatting) back into my master sheet? Th
reason I don not just make the test file the new master is becaus
there were some setups in the master that were taken out of the tes
file. Every time I try to copy anything, it wants to reference to th
test sheet.

Any help would be appreciated
 
Hi
you may try the following to copy only the formats:
- select the range in your test sheet and copy it
- insert the formats in your master sheet with 'Edit - Paste Special -
Formats'
 
Back
Top