Filling ‘blank/empty cells’ using data from the cell that is above the blank/empty cell

 

Steps:

1. Select the row header (select the entire colum)
2. Press F5
3. Press Alt+S or click on “Special…”
4. Select “BLANK”
5. Click OK
(Blank cells will be selected)
6. Enter ‘=’ and select the above cell
7. Press CNTRL+ENTER

If you wish to delete blank cells:

Follow Step 1 through to step 4 as mentioned above
Step 5. Right click on your mouse and select “Delete”
Step 6. Select “Shift cells up” or other options as required

If you wish to count all the blank cells:

In any cell that is outside your selection area type “=countblank(select your area)” ENTER

If you wish to colour all the blank cells:

1. Select your area
2. Select “Conditional Formatting” from the main menu
3. Select “Highlight cells rules”
4. Select ” More rules”
5. Under ‘Edit the rule description’ > ‘Format only cells with’ Choose ‘BLANKS’
6. Click on “Format”
7. Under FILL chose any colour of your choice
8. Click OK
9. Click OK again!

Advertisements
This entry was posted in Excel tips and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s