Your Ad Here

Wednesday, April 15, 2009

How to Make A Strings of Number In Same Column in Excel?

In Microsoft Excel, user can make a string of numbers which are in the same column, all be multiplied by a number, for example 3 and done all in one step. Follow this tutorial, in the balnk cell, put the number 3. Then click Ctrl+C to copy it. After that select the cell block user wish to apply the multiplication. Then paste special, check on value, and check also on multiply. Click OK.

0 comments:

Post a Comment