📞 01223 214177 ✉️ karen@roem.co.uk
There are various ways to insert rows and columns in a table. Come to think of it, I might list them at some point in a future tip. (Watch this space.) But time and time again I notice people don't know - what I believe is - the fastest way to insert a row at the end of a table, underneath the last row.
Here's how:
If you have the total row switched on in a table in Excel, make sure you click in the last cell above the total row.
Simply hold down the TAB key (no need to release it) to add multiple rows.
Finally, I want you to know that I plan to continue to publish my tips during these tricky times. I hope you find them helpful and a welcome respite among all the information about the evolving COVID-19 (coronavirus) outbreak. Stay safe!
Related tips
.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.