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.
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.
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
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. 😊
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.
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
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
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.
Love the way she explain everything so clearly. Thank you dear. A hug from Puerto Rico. 🇵🇷
Thank you!!🤗
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.
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?
And it doesn't, it only gives you the last row. Nevertheless a very nice tip all the same.
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.
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
So great for me. Solved most of my table issues. Thank you.
Thank you so much
😇😎
You are very welcome! Thanks for watching 😃
thank you very much i like your style of teach its systematic and its in a manner that new beginner can comrehend
Glad it was helpful! 🤩 Learn more Microsoft Word Tips and Tricks here 👉ruclips.net/p/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
Explain in very easy way, Thanks
Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉ruclips.net/p/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
Superb
That's awesome! Thanks for watching 🙂
Great tutorial.
Glad you liked it!
Thank you!
You're welcome!
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. 😊
Very informative, thanks dear, Keep it up
So nice of you
I have more columns than rows. Is there a way to have the column go over multiple pages ?
Thank you
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.
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
Good job informativ tutorial
Why Thank you.
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
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
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.
Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉 ruclips.net/p/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
none of this works
Great tutorial