In Excel, there are various ways to insert rows or columns. Whatever method you choose, by default the inserted row or column will be formatted in the same way as the row above or the column to the left.
So what if you don’t want to stick to that formatting? Simple! Do not ignore the Insert Options button.
Here’s how:
1. Insert your row(s) or column(s), as normal. (CTRL + SHIFT + plus sign, anyone?)
2. Click on the paint brush (the Insert Options button).
3. Select Format Same As Below for a row or Format Same as Right for a column. Or why not click on Clear Formatting to apply the default formatting?
By the way, the Insert Options button does not appear when you insert copied cells.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
25 May 2015
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
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
Please note: Cambridge Network's Learning Collaboration members have the opportunity to book places on Roem Ltd courses at a reduced rate.