In this video we can discuss about How to use fill & clear options in Excel Sheet.
Fill:-
To display the list of Auto Fill options, click the Auto Fill Options button. The list of options varies according to the type of data: text and formulas, numbers, months, days of the week, and dates.
Clear:-
You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), and any attached comments.
The cleared cells remain as blank or unformatted cells on the worksheet.
