Recently one of my readers asked, that he cannot use Microsoft excel ‘click and drag’ feature to fill column and cell .He was using excel in built list and custom list for filling date and month. He was struggling to enter each list by typing manually.
This is a common problem happens to normal excel users. They might have clicked somewhere in the option that he cannot remember and he does not know what will the effect of that unwanted click. The problems caused as user disabled click and drag feature of excel .as a result fill handle disappeared. In this case the excel cell look like a complete square like below
Now Excel option screen will be in front of you, Select advanced tab on the left side.
As you see in the above picture you might have accidently unchecked “Enable fill handle and cell drag and drop” check box .Re-enable it by checking the box.
Just under that there is another option Alert before overwriting cell. This will alert you any data already exist in copying cell while using fill handle.
Related posts:
This is a common problem happens to normal excel users. They might have clicked somewhere in the option that he cannot remember and he does not know what will the effect of that unwanted click. The problems caused as user disabled click and drag feature of excel .as a result fill handle disappeared. In this case the excel cell look like a complete square like below
How to restore fill handle and click and drag function
Click on File and locate Options and click on it.
Now Excel option screen will be in front of you, Select advanced tab on the left side.
Just under that there is another option Alert before overwriting cell. This will alert you any data already exist in copying cell while using fill handle.
Related posts:
No comments:
Post a Comment