Monday, December 05, 2011

Multiply and Divide a group of cells in Excel

I just now realised that it has been more than a month since I have posted anything on my blog. So here I am with the most recent tip I learnt in Excel.

If you have a column of cells that need to be divided by 1000 for example. Here are the steps that you need to follow.




  • Type 1000 in a cell lets say A2


  • Copy the cell A2 using Ctrl+C


  • Select the cells in the column where you would like to let us say multiply the values by 1000.


  • Right click and select Paste Special


  • Click on Multiply as shown below.










You can do the same for adding or subtracting a specific value from a group of cells.

This tip is particularly useful if you want to show the data that is in millions but want to reduce the number of digits by dividing them by 1000.

Hope this heps.



No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...