Fill in the Blanks in Microsoft Excel

This is so much easier that it might seem. Suppose you have "headings" only in certain cells in A1 because someone sent you a report that was designed this way. Now you want to sort or subtotal the data properly, and you can't unless you put headings in each row. So, effectively, you need to copy the "abc" in A2 into A3 through A6, and the "bcd" in cell A7 to cells A8 through A10, etc.

Click on the letter A to select the entire column. Hit EditŕGo to Special, Blanks, OK. Type the = sign, and then hit the up arrow one time. In our sample here, the formula becomes =A2.

Now, just hit Ctrl+Enter. Here's our result. debuted on May 26, 2005. provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved