Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Art
 
Posts: n/a
Default How do I multipy a range of cells by a common number?


  #2   Report Post  
Kevin H. Stecyk
 
Posts: n/a
Default

Hi Art,

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

HTH.

Kevin


  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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:


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
How can I dynamically eliminate blank cells in a given range in E. Scott Steele Excel Worksheet Functions 6 December 17th 04 03:23 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
index to a range of cells Frank Kabel Excel Worksheet Functions 0 October 27th 04 05:39 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"