So my office has some reports we do regularly which have a six column list of figures that need totalling. As the reports are amended, the #s can change, so they asked if I could set up an embedded excel table to help make the process a lot faster and less error-prone. So far so good. The problem is that sometimes those numbers have to be marked as "tentative" and I'm not sure how to achieve this, or if I even can.
- I can't add a column because it can appear in any cell and my 6 column table would turn into a 12 column table and be very very tiny on the word page.
- There's too great a diversity in computer knowledge to just teach people "insert a row and add the word there and then remove the border between the row above it to make it all look like one cell" - plus of course this kind of kills the time savings again!
- I found this set of instructions, but whether in an excel table (which I'd prefer for the can't-mess-it-up "total" row) or just plain cells, I can't make it work - either it ignores the number altogether and the total stays $0.00 or I get a "#VALUE!" error.
I've attached a sample file with attempts I've made - please be gentle, all my excel knowledge is self-learned over decades of just "I need to do a thing, let's figure out how to do it using a combination of google, trying stuff until it works, and as a last resort, begging for help from people who actually know what they're doing, and then if it still confuses me, trying to reverse-engineer it in case I need to do it again in the future!"
- I can't add a column because it can appear in any cell and my 6 column table would turn into a 12 column table and be very very tiny on the word page.
- There's too great a diversity in computer knowledge to just teach people "insert a row and add the word there and then remove the border between the row above it to make it all look like one cell" - plus of course this kind of kills the time savings again!
- I found this set of instructions, but whether in an excel table (which I'd prefer for the can't-mess-it-up "total" row) or just plain cells, I can't make it work - either it ignores the number altogether and the total stays $0.00 or I get a "#VALUE!" error.
I've attached a sample file with attempts I've made - please be gentle, all my excel knowledge is self-learned over decades of just "I need to do a thing, let's figure out how to do it using a combination of google, trying stuff until it works, and as a last resort, begging for help from people who actually know what they're doing, and then if it still confuses me, trying to reverse-engineer it in case I need to do it again in the future!"