Hi - Dave here.
Sometimes, you want to change some numbers in Excel, but you'd rather not use formulas.
Maybe you don't want to make room on the spreadsheet for the formulas, or maybe you just feel lazy :)
One option to keep in mind is Paste Special. The Paste Special operation can do many things in Excel, including simple math operations. This means you can use Paste Special to change cell values
without formulas.
Watch the short video below to see how this works:
[
Watch video - 2m30s]
This video comes from our
Core Formula training, which is basically everything you should know about Excel Formulas but were probably never taught :)
More videos
We have more free videos
here.
If you need practice worksheets, see our paid
video training.
Have a nice weekend!
Dave
