How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.