At 0:50 when using the paste special to paste only the formulas; When pasting SUM(D9:D10) why doesn't it show the actual summary of the numbers existing in the cells D9 and D10? Why is it showing 0 instead?

Hi MIchael, The cells in D9 and D10 are empty and hence the formula shows 0. Best, Ned

Oh ok, it seems that I identified the cells incorrectly. Thanks for the quick reply.

How many Project should to as a beginner in Excel , SQL , Poer Bi - Tablue, R Basic , Python Basics ?

What is the concept of "formula" while using special paste? How come the formula 136 and 129 came for the given exercise?

Hello, A formula is the operation that we've specified in the formula bar. Best, Ned

Follow this topic

Last answered:

26 Dec 2021

Posted on:

07 May 2021

Paste Special; Pasting only the formulas

5 answers ( 0 marked as helpful)

Posted on:

07 May 2021

Posted on:

07 May 2021

Posted on:

08 May 2021

Posted on:

26 Dec 2021

Posted on:

26 Dec 2021