exceltoxl.com

Hi there,

This tip will help you to fill the blank cells while in a filtered mode. I am using this quite some time now. I thought it might help you as well. 

Let me proceed now.

Say, you have to fill the column with Country Name where the other column has state names.

Filtering all Indian states and update the country name as INDIA. You can do this by selecting the blank cells and typing in one cell as INDIA and before clicking on ENTER, hold CTRL button and hit ENTER.

...

Important: This trick will help to avoid pasting the values to unfiltered cells.

Use this method for sure you will not face such problems and it is easy to update the blank cells from now, when the column is in filtered mode.

That's all from me today. If you find this tip useful, please do share it on your social networking sites by clicking on the icons placed around the blog. If you want to support me for maintaining this blog, REGISTER here for free.

SOME IMPORTANT LINKS:

Compare two tables or lists in Excel

Create a Client's E-mail ID as Hyperlink

Excel NameBox is Awesome

Custom Grouping in PivotTable

Thanks