LinkBack URL
About LinkBacks
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?
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?
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.
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:
Please Login or Register to view this content.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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.Originally Posted by QuieT
If this is not what you want or it's not clear please attach your file; see yellow banner at top of page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks