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 about what I believe is the fastest way to insert a row at the end of a table, underneath the last row.
Here’s how:
1. Click anywhere in the last cell of the table.
2. Press TAB.
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
Quickly jump between the start and end of a row in a table (MS Word and Outlook)
Keyboard shortcut to move rows in a table (MS Word)
Quickly jump between the beginning and end of a document or email (MS Office)
Total the data in a table (MS Excel)
Book with confidence during coronavirus outbreak
Our current course schedule can be found online. Our focus is to continue to carry on business as usual, whilst protecting the health of our staff and our customers. If you are unable to attend your course or want to change your date, we are happy to rearrange your course at no extra cost. This applies to existing as well as new bookings, up to six months from the original date of your course.
23 March 2020
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk