excel computer training - paste formulas

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - Paste formulas

excel computer training - Paste formulas

resolvedResolved · Low Priority · Version Standard

Kenieek has attended:
Excel Introduction course

Paste formulas

How do I paste formulas to show values?

RE: paste formulas

Hi Kenieek

Thank you for your question.

If you copy the cells with formulas in them, then use Edit - Paste Special and choose the Values option and click OK, this will paste the formula results as values.

Amanda


 

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips


Server loaded in 0.12 secs.