Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Subtract Number From Column of Numbers

  1. #1
    Join Date
    4th October 2006
    Posts
    2

    Subtract Number From Column of Numbers

    I am a new user of Excel. I am wondering if someone here could kindly help me on this simple task. Thanks!

    I have data on A1 to A100. How can I subtract a same number (for example 10)from each cell of A1:A100?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,287

    Re: Calculation On Column

    Try the following...

    1) Enter 10 in an empty cell, let's say B1

    2) Select B1

    3) Edit > Copy

    4) Select A1:A100

    5) Edit > Paste Special > Subtract > Ok

    Hope this helps!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

  4. #4
    Join Date
    4th October 2006
    Posts
    2

    Re: Subtract Number From Column of Numbers

    It works. Domenic, thank you very much!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Count the number of unique Numbers in a column
    By ajajmannen in forum EXCEL HELP
    Replies: 11
    Last Post: December 15th, 2010, 00:27
  2. Multiply Column Of Numbers By Fixed Number
    By txheart in forum EXCEL HELP
    Replies: 2
    Last Post: March 2nd, 2008, 15:59
  3. Replies: 10
    Last Post: October 15th, 2007, 11:50
  4. Replies: 2
    Last Post: July 27th, 2005, 13:52
  5. Replies: 3
    Last Post: May 30th, 2005, 16:47

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno