Multiplying multiple cells of data at once

%3CLINGO-SUB%20id%3D%22lingo-sub-2401713%22%20slang%3D%22en-US%22%3EMultiplying%20multiple%20cells%20of%20data%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401713%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20multipy%20150%20individual%20cells%20by%20the%20same%20constant%2C%202.2%3C%2FP%3E%3CP%3EI%20am%20able%20to%20do%20it%20one%20cell%20at%20a%20time%20but%20can%20not%20figure%20out%20how%20to%20highlight%20100%2B%20cells%20and%20do%20them%20all%20at%20the%20same%20time.%20I'm%20a%20newbie%2C%20so%20thanks%20for%20a%20simple%20lesson%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2401713%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401733%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20multiple%20cells%20of%20data%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1067740%22%20target%3D%22_blank%22%3E%40Segalassoc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20how%20your%20data%20is%20structured.%20Let%20assume%20it's%20in%20A1%3AA100.%20In%20B1%20enter%20the%20formula%20%3DA1*2.2%3C%2FP%3E%0A%3CP%3EAfter%20when%20stay%20on%20B1%20double%20click%20the%20dot%20on%20the%20border%20around%20the%20cell%20at%20bottom%20right.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlternatively%20after%20entering%20the%20formula%20select%20B1%3AB100%20and%20Ctrl%2BD.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401796%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20multiple%20cells%20of%20data%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401796%22%20slang%3D%22en-US%22%3EThank%20you%20for%20replying.%3CBR%20%2F%3EWhen%20I%20highlight%20one%20cell%2C%20the%20formula%20bar%20shows%3A%20617.554245%3CBR%20%2F%3EThe%20617%20is%20the%20date%2C%20in%20this%20case%20the%20cost.%20I%20can%20type%20in%20the%20formula%20line%20%3D617.554245*2.2%20and%20when%20I%20hit%20return%20the%20result%20is%20correct.%20When%20I%20try%20and%20highlight%20a%20number%20of%20cells%2C%20that%20doesn't%20work%3F%3C%2FLINGO-BODY%3E
New Contributor

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 newbie, so thanks for a simple lesson?

 

4 Replies

@Segalassoc 

Depends how your data is structured. Let assume it's in A1:A100. In B1 enter the formula =A1*2.2

After when stay on B1 double click the dot on the border around the cell at bottom right.

 

Alternatively after entering the formula select B1:B100 and Ctrl+D.

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?

@Segalassoc  wrote: ``I am trying to multipy 150 individual cells by the same constant, 2.2``. And later: ``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``.

 

I wonder if the following is what you want to do.

 

1. Enter 2.2 into any cell.  Then select that cell, and press ctrl+c to copy.

2. Select the 150 cells (A1:A150), right-click and click Paste Special, select Multiply and click OK.

 

(If the cells are not a contiguous range, you can use ctrl+Click to select them.)

 

If you had 617.554245 in a cell, the cell value will become 1358.619339, not the formula =617.554245*2.2.

 

Is that acceptable?  Or do you insist on replacing the constant 617.554245 with the formula.

 

 

@Segalassoc 

First step

image.png

Double click on dot at the bottom right of B1. Result is

image.png

Another way - after first step select range in column B

image.png

Press Ctrl+D. Result will be the same.

If you'd like multiply numbers in column A substituting them with the result, when as @Joe User  advised.