Search for answers to your questions by entering keywords below, or look through our knowledge base.
Welcome to 'Sikkhon' User Forum
Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users.
You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.
Are you facing issues using AutoFill in Excel? Here are some quick fixes to get it working again.
Normally, Microsoft Excel, the Fill Handle option remains activated by default, But sometimes there could occur some issues that may disable the Fill Handle option. In that case, we have to enable the Fill Handle option manually.
01 - Enable or check the Fill Handle option
Check your Autofill settings. Make sure that the AutoFill option is turned on in Excel Online. To do this
Go to the File menu and click to Options.
There, select Advanced from the left-hand menu and scroll down to the Editing Options section.
Check the Enable fill handle and cell drag-and-drop option. Additionally, you should check Alert before overwriting cells to avoid accidentally editing important information.
Now, let’s think of a case in the following picture. the Fill Handle has been used to make a series of numbers starting from ‘1’. But we have got the repetitions of 1 in return.
To get a series of numbers (1,2,3…), you’ll see the option Fill Series from the menu. After you select the related option, you’ll find the series of numbers starting from 1 in Column.
Are you facing issues using AutoFill in Excel? Here are some quick fixes to get it working again.
Normally, Microsoft Excel, the Fill Handle option remains activated by default, But sometimes there could occur some issues that may disable the Fill Handle option. In that case, we have to enable the Fill Handle option manually.
01 - Enable or check the Fill Handle option
Check your Autofill settings. Make sure that the AutoFill option is turned on in Excel Online. To do this
Now, let’s think of a case in the following picture. the Fill Handle has been used to make a series of numbers starting from ‘1’. But we have got the repetitions of 1 in return.
To get a series of numbers (1,2,3…), you’ll see the option Fill Series from the menu. After you select the related option, you’ll find the series of numbers starting from 1 in Column.
thanks
0 Votes
0 Comments
Login or Sign up to post a comment