Category: Excel Articles

Excel Data Validation

Use data validation in Excel to make sure that users enter correct values into a cell. Data validation option is found under Data Menu in Excel. This feature restricts user from entering incorrect values in cell. For example , in Student Workbook , Marks is whole number greater […]

Enable or Disable fill handle in Excel

Enable or Disable fill handle in Excel One can turn this option on or off by following below steps: Click the Microsoft Office Button , and then click Excel Options. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-dropcheck box to turn drag-and-drop editing on or off.

%d bloggers like this: