Monday, April 8, 2013

Filling blank cells

I want to fill the blank values with the cell value in the above cell, eg. A1 contains IBM, A12 contains HP, A24 contains Cisco etc. So, I want to fill cell values A2:A11 with IBM, A13:A23 with HP etc. This will help me create a flat file from a locked pivot shared by the syndicate research provider. Is there a way to do it without using macros?

A. Yes, it can be done even without using macros. Just follow the below steps:

Select the data range (ex: A1:A24)
Home Tab >> Editing section >> Find & Select >> Go To Special
Choose “Blanks”
Click Ok
Now, the selected cell will be the first blank cell (in this example: A2)
Type “=A1” (i.e. we are linking cell A2 with value in cell A1)
Press Ctrl+ Enter

No comments:

Post a Comment