ExcelBanter - How do I multipy a range of cells by a common number?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I multipy a range of cells by a common number? (https://www.excelbanter.com/excel-worksheet-functions/8965-how-do-i-multipy-range-cells-common-number.html)

Art

How do I multipy a range of cells by a common number?

Kevin H. Stecyk

Hi Art,

Enter your number in the spreadsheet in a blank cell. Copy. Edit | Paste
Special...multiply.

HTH.

Kevin

Gord Dibben

In future please type your problem and requested solution in the body of your
posting.

Enter a number in an unused cell.

Copy that cell.

Select your range of data and Paste SpecialMultiplyOKEsc.

Delete the cell with the nunber.

Gord Dibben Excel MVP

On Mon, 10 Jan 2005 09:55:08 -0800, Art wrote:

All times are GMT +1. The time now is 08:41 PM.