Forum Discussion
Multiplying multiple cells of data at once
I am trying to multipy 150 individual cells by the same constant, 2.2 I am able to do it one cell at a time but can not figure out how to highlight 100+ cells and do them all at the same time. I'm a...
Thank you for replying.
When I highlight one cell, the formula bar shows: 617.554245
The 617 is the date, in this case the cost. I can type in the formula line =617.554245*2.2 and when I hit return the result is correct. When I try and highlight a number of cells, that doesn't work?
When I highlight one cell, the formula bar shows: 617.554245
The 617 is the date, in this case the cost. I can type in the formula line =617.554245*2.2 and when I hit return the result is correct. When I try and highlight a number of cells, that doesn't work?
First step
Double click on dot at the bottom right of B1. Result is
Another way - after first step select range in column B
Press Ctrl+D. Result will be the same.
If you'd like multiply numbers in column A substituting them with the result, when as JoeUser2004 advised.