Sometimes we get data that is downloaded from an external source and it is not formatted properly.

You may have cells with missing data and cases where you want to copy the cell directly above to fill in your empty cell in Excel.

This can be achieved with the following steps:

* Highlighting your data set

* In the ribbon menu select Home > Find & Select > Go to Special or just press the keyboard shortcut CTRL+G

* Select the Blanks option and press OK (This highlights all your blank cells);

* Then you need to press the = sign and reference the cell directly above

* Finally, and most importantly, you need to press CTRL+ENTER so that the formula can be filled in to all the selected blank cells.

 DOWNLOAD WORKBOOK

Copy the cells directly above

HELPFUL RESOURCE:

Chandoo - excel-school

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Table: Row Calculations One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.  To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.  From there you simply need to activate the Total Rows check box. This wil...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button. The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Data Bars, Color Scales & Icon Sets Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets. Data Bars: Includes graphic bars in a cell, proportional to the cell’s value - Good for Financial Analysis Color Scales: Includes a background color, proporti...
Extra Excel Table Styles The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark. There are over 50 choices depending on your favorite style or company standard but you are not only limited to those. You have extra Table styles in the Page Layout tab in y...