Microsoft Excel Tips
and Tricks
Perform Quick Operations on Your Excel Data
Have you ever wanted to quickly perform an operation on your
Excel data, without replacing the data? For example, maybe
you have some yearly figures, and you want to see what the
daily ones look like. It's easy to do, using the Paste
Special command.
1.
Type =365 in a cell.
2.
Click Copy.
3.
Highlight the data for which you want the daily figures.
4.
On the Edit menu, click Paste Special.
5.
In the Paste Special dialog box, click Divide and
then click OK.
All of the data you have highlighted will be divided by 365.
If you click in any of the cells, you'll see the operation
that was performed displayed in the formula bar.
|