pasting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pasting

Pasting

resolvedResolved · Low Priority · Version 2003

Sarah has attended:
Excel Intermediate course

Pasting

Can you tell me how to copy and paste a worksheet within a workbook so that it retains the same look and formulae and format?

Thanks

RE: Pasting

Hi Sarah

Instead of using paste, use the paste special function. You then have an option of pasting formulae and formatting.


 

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips


Server loaded in 0.09 secs.