+ Reply to Thread
Results 1 to 5 of 5

Auto create a formula to apply to the whole column without dragging

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Auto create a formula to apply to the whole column without dragging

    Please see the attached sheet...

    Columns Q & R have formulae in them that i have written and dragged down, and i dont want people to have to carry on dragging down the page to make it work. Is there a way i can put the formula in that allows it to auto-populate the answer from what appears to be a blank field?

    i want to make this sheet as automatic as possible..

    thanks very much in advance

    Sheet attached
    Attached Files Attached Files

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Auto create a formula to apply to the whole column without dragging

    convert your entire tableau into an Excel Table:

    1. select the range A1:S2
    2. navigate to Insert > Table
    3. follow prompts (keep the 'table has headers' checkbox on)

    after that, whenever you start entering a new row of record, the formulae in column Q and R will be copied over from the row above.
    Last edited by icestationzbra; 08-07-2012 at 07:36 AM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Re: Auto create a formula to apply to the whole column without dragging

    you, my dear are fantastic! THANK YOU!
    Question... why has my sheet gone blue now? where the table applies?

  4. #4
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Auto create a formula to apply to the whole column without dragging

    that is a "table" theme or style. if you want to change it, select a cell within the table. now, look for a new tab on the ribbon; it is called "Design". there should be a section within it called Table Styles. select a less intrusive one, if you please, by scrolling through the various options..

  5. #5
    Registered User
    Join Date
    08-02-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Office 2010 (Excel)
    Posts
    50

    Re: Auto create a formula to apply to the whole column without dragging

    Thanks very much! This case is closed! Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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