Advanced Tables in Word: Table Styles, Breaks and Formulas

[@LaneWyrick]

Excellent tutorial! I just found a way that you can find the number of the rows rather than just guessing. Instead of selecting the entire table, just click and drag from the first cel of the table all the way down to the cel you want in your formula. Right click, choose Table Properties and click on Row. Now instead of showing Rows 1 - 124, it will say Rows 1 - 55 (or whatever cel you are choosing). Do this again for your final cel if necessary and input them into your formula.

[@dolittlediehard1670]

And of course the same works if you select say rows 52-56 only. I haven't tried but i wonder if you could choose non adjacent rows?

[@dolittlediehard1670]

And it doesn't, it only gives you the last row. Nevertheless a very nice tip all the same.

[@dolittlediehard1670]

I don't know if Debbie covered this or not but if we suppose you wanted to add up all the sales for the USA only. How would you do it? The answer is to sort the table in acending order, so USA would appear at the bottom and then just add up these rows. You would need to select these rows and use Lane Wyrick's trick above to find out the address values for your formula.

[@dolittlediehard1670]

Yes, this works 🎉. One little side problem. I copied and pasted USA sales into excel but even after changing the format of the cells to numbers it gave a sum of 0 because it didn't like the $ sign. After removing the $ sign it worked

[@MM-uw4lc]

Love the way she explain everything so clearly. Thank you dear. A hug from Puerto Rico. 🇵🇷

[@SimonSezIT]

Thank you!!🤗

[@DaleBhagwagar]

Superb

[@joshuamanampiu6489]

So great for me. Solved most of my table issues. Thank you.

[@AyoubShinab]

Thank you so much 😇😎

[@SimonSezIT]

You are very welcome! Thanks for watching 😃

[@rajeevsinghbais1727]

Explain in very easy way, Thanks

[@SimonSezIT]

Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉kzbin.info/aero/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj

[@rogerskipleting1901]

thank you very much i like your style of teach its systematic and its in a manner that new beginner can comrehend

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Word Tips and Tricks here 👉kzbin.info/aero/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj

[@mdshibli1009]

Thank you

[@weston.weston]

Great tutorial.

[@SimonSezIT]

Glad you liked it!

[@lieslswanepoel2563]

Thank you!

[@SimonSezIT]

You're welcome!

[@ma7moudabaza638]

Good job informativ tutorial

[@SimonSezIT]

Why Thank you.

[@user-dn9vd9xg9p]

If have drop down list within a table in a form. The ldrpp down list that has data that is too long to show on one line. How do I get the drop down list formatted to wordwrap and move down (not across). I really need assistance with this. Thank you. 😊

[@lawrencekazibwe9751]

Very informative, thanks dear, Keep it up

[@SimonSezIT]

So nice of you

[@tomnolan4406]

I have more columns than rows. Is there a way to have the column go over multiple pages ?

[@Ytremz]

Very comprehensive - would be interesting to know how to handle the formatting (i.e. font, shading) of a title row that is _merged_ across several (or all) columns of the table. Word doesn't seem to handle the formatting of merged cells very well.

[@denisekobrin9338]

This was an excellent video. I was hoping it would show me how to format numbers in tables as you do in MS Excel. I have numbers in a table where I don't need a formula, I need to format the numbers as an Accounting number. Is there a way to accomplish this? I'd like to format an entire column at once. thanks

[@rksingh8447]

I tried to add the same way you taught with row numbers but not getting correct total. Updated the field but still not. Pls reply

[@lisalansing1881]

In the past, I have been able to create styles in the style menu for tables. I can't remember how I did that so if anyone know could you let me know. Thanks

[@jonzillaz]

Could you not have said the word 'use' instead of 'utilize?' One syllable is more efficient than three. Ignore me! Fantastic tutorials, I really am learning so much. I'm very grateful.

[@SimonSezIT]

Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉 kzbin.info/aero/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj

[@Tomtriandoch]

none of this works

[@eddietaia8310]

Great tutorial