Apply Global Formula

D

Donna K.

I want to take a range of numbers in separate cells and divide them all by 2
and have the results replace the numbers listed. Is this possible in Excel?
 
P

Pecoflyer

Donna said:
I want to take a range of numbers in separate cells and divide them all
by 2
and have the results replace the numbers listed. Is this possible in
Excel?
Click to expand...

Hi,
enter 2 in an empty cell - Copy this cell

Select the cells you want to divide ( holding down shift or Ctrl key if
needed

Right-Click/Paste Special/Under "Operations" check " divide" / OK


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
VBA multiple list of values for variable 1
Combining three files when middle file has sections with endnotes 2
Possible to Combine reports to's to a single box? 0
Sumif apllying to all sheets in workbook 2
Divide a # into 3 #'s rounded to a whole # 9
How to get range names to Apply across multiple tabs 1

Top