« Save Files Faster in Excel 2013 | Create Dynamic DropDown using Excel DataValidation » |
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
Thanks
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments