Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How Do I Get Excel To Show All Dates?

Date:2021-11-14 Author:Sandra

2022 is coming. I need to create a new workbook that contains all dates of 2022. So how to get all dates in Excel? Enter 1/1/2022 in cell A1 and use handle fill? That’s too much trouble. There is a better way.

Type A365 in Name Box and press Enter key.

How Do I Get Excel To Show All Dates?
How Do I Get Excel To Show All Dates?

Cell A356 will be selected. Now we press Ctrl +Shift +↑. So we can select the area A1:A356.

How Do I Get Excel To Show All Dates?

Now we click on Fill and choose Series in the list.

How Do I Get Excel To Show All Dates?

Check Date in the box, and hit OK.

How Do I Get Excel To Show All Dates?
How Do I Get Excel To Show All Dates?

Well, perfect!

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *