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.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com 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