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

excel courses in london - how do i paste

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?

ResolvedVersion Standard

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?

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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.