+ Reply to Thread
Results 1 to 5 of 5

How to apply one column formula to entire column ?

  1. #1
    Registered User
    Join Date
    01-04-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    33

    How to apply one column formula to entire column ?

    Example i got the 2 column of data, A2 to A6, B2 to B6. I had seen a macro before tat apply one cell formula to entire column. How can I make it if I only set C1 is =Sum(A1,B1), then the rest column will hav the same formula but without showing out the formula?
    Isaac Koh

  2. #2
    Registered User
    Join Date
    01-21-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: How to apply one column formula to entire column ?

    This is just a really simple one that may get you on track.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to apply one column formula to entire column ?

    Another:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-04-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: How to apply one column formula to entire column ?

    Quote Originally Posted by scottlutes View Post
    This is just a really simple one that may get you on track.

    Please Login or Register  to view this content.
    Tq.. this formula working.. but when I click in C2.. the formula will been seen... i trying to make when I click in C2..what I only c is the value..not the formula..have any idea?

  5. #5
    Registered User
    Join Date
    01-21-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: How to apply one column formula to entire column ?

    Depending on a couple things, you can try this one. It will change the Format Cells-->Protection option to Hidden, and then Protect the Sheet (No Password). To modify, just click on the Unprotect Sheet under Review.

    Please Login or Register  to view this content.
    Another way, if you don't need the formulas to remain, just the result, would be to just copy/paste special. This will keep the result, but discard the formula. The down-side is that you would have to re-apply the formula later if needed. For that, you can just modify the code to this.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-28-2012, 09:58 PM
  2. Apply formula to entire column macro
    By aznprod517 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2009, 10:41 AM
  3. Apply MONTH formula to entire column
    By aspen_gal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 01:42 PM
  4. Formula that will apply to entire column???
    By borbafett in forum Excel General
    Replies: 2
    Last Post: 04-29-2008, 03:40 PM
  5. I want to apply a formula to an entire column.
    By kitcox in forum Excel General
    Replies: 3
    Last Post: 11-27-2005, 09:50 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1