+ Reply to Thread
Results 1 to 5 of 5

Maintain formulae in table headings (Dynamic column headings)

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    13

    Maintain formulae in table headings (Dynamic column headings)

    Hiya! I have been trying to maintain my formulae above my columns while converting my clusters of numbers to a table. As far as I have worked out, this is not possible.

    Anyone care to contradict me?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Maintain formulae in table headings (Dynamic column headings)

    Do you mean that you are converting data to an Excel Table and Excel is wiping out your formulas and replacing them with table headers?

    You can create the table by selecting the data starting with the row below your formulas. The formulas will be untouched.

    If I have misunderstood your question then please see yellow banner at the top of the page and attach a file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    13

    Re: Maintain formulae in table headings (Dynamic column headings)

    Yes, that's what I thought as well. However, what happens when I start the table under my headers, Excel shifts the whole thing one row down and imposes headers - which is also not what I want. Also, Excel doesn't necessarily wipe out my headers. Rather, it converts to static text, defeating the whole purpose of a dynamic text, example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,422

    Re: Maintain formulae in table headings (Dynamic column headings)

    It is not possible to have formulae as column headers in Excel tables.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Maintain formulae in table headings (Dynamic column headings)

    Quote Originally Posted by QuieT View Post
    [...]what happens when I start the table under my headers, Excel shifts the whole thing one row down and imposes headers - which is also not what I want.
    Do what you just described. Then afterwards, click anywhere in the table, and go to the Design menu in the ribbon. In the Table Style Options panel, uncheck "headers". The table headers will disappear. Then select all of the cells in your table and drag up one row to fill the space.

    If this is not what you want or it's not clear please attach your file; see yellow banner at top of page.

+ 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. Hiding column headings but NOT row headings
    By krus54 in forum Excel General
    Replies: 6
    Last Post: 11-14-2018, 05:00 PM
  2. [SOLVED] Transfer data with Horizontal headings to sheet with vertical headings
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2018, 10:33 AM
  3. How to make a Templates column headings dynamic with the Pivot table headings
    By DashBD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2017, 05:20 PM
  4. [SOLVED] Sumproduct with Dynamic Column Headings
    By lipper79 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-25-2016, 09:54 PM
  5. VBa Dynamic Monthly Column Headings
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2014, 05:03 AM
  6. Dynamic column headings
    By ianh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 10:53 AM
  7. Can I invert a table so row headings are now column headings etc
    By Sharon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2005, 04:06 PM

Tags for this Thread

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