HOW TO FILL THE MISSING VALUES IN EXCEL SPREADSHEETS

An easy method to fill the missing values in excel is to make use of the ‘Go to special’ option.

Step1: Select the rows and columns to be filled

1-min

Step 2: Now press Ctrl+G to open the ‘Got to’ dialog box

2-min

Click in the ‘Special’ button

(or)

Step 3: select the ‘Go To Special’ button from the ‘Find and Search’ tab in the left corner of the excel.

4-min

Step 4: Click the Blanks option and click OK

5-min

Step 5: Press F2 button in the keyboard (or) click the formula bar.

6-min

Now you can enter the value you want in the space provided. The active cell (blank cells) will get this value. If you want the same value in all the blank cells, Press Ctrl+Enter

7-min

Now you are done!

Advertisements

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