📞 01223 214177 ✉️ karen@roem.co.uk
There are various ways to insert multiple rows and up to now there were two methods I stuck with. This week I read about a new approach and as I like it I thought I'd list my (now) three favourite ways. Find the one that works best for you.
Here's how:
Using these two methods the new rows go above the selected rows. Check out this third way, where it's you rather than Excel that's in control.
Oh, and look out for the Insert Options button ("Clippy in disguise") if you want to format on the fly.
Finally, I wouldn't worry too much where to insert your rows... simply sort your column once you're done!
By the way, if any of you are looking for a short demo and are on LinkedIn, check out Ajay Anand's post. Credit where credit is due! Thanks for this week's tip inspiration, Ajay!
Related tips
This week's CleverClogsTipTime on LinkedIn, in case you missed it...
*
Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016.
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.