excel courses in london - how do i paste
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - How do I paste formulas to show values only?

excel courses in london - How do I paste formulas to show values only?

resolvedResolved · Low Priority · Version Standard

replyReply Thu 17 May 2007, 12:53Delegate Artur said...

Artur has attended:
Excel Intermediate course
Excel Advanced course

How do I paste formulas to show values only?

How do I paste formulas to show values only?

For upcoming training course dates see: Pricing & availability

replyReply Sat 19 May 2007, 06:32Trainer Tracy said...

RE: How do I paste formulas to show values only?

Hi Artur,

Thanks for the question.

To copy only the values of the cells instead of the formulas, simply go into the Edit menu and press copy as you normally would then when you go to paste click the "Paste Special" option on your edit menu and tick against the Value option.

I hope that answers your question, feel free to get back to me if there is anything else

Tracy

 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard