This is one of my favorite tricks. If you need to quickly add, subtract, multiply, or divide a lot of cells, you can use the Paste Special feature. I find this comes in handy when I need to present something in thousands (so I divide all my numbers by 1,000). Changing negatives to positives by multiplying by -1 is also useful.
Subscribe to the Spreadsheet Nation Channel: / @spreadsheetnation
Follow Spreadsheet Nation:
Facebook: / ssnation
Instagram: / spreadsheetnation
Website: www.spreadshee...
#excelhelp
#spreadsheetmagic
#spreadsheets
Негізгі бет Excel Explained: Add, Subtract, Multiply, or Divide with Paste Special
No video
Пікірлер