1
How to collaborate on a workbook in Excel | Microsoft
0:55
2
How to perform a Windows 11 In-place upgrade | Microsoft
3:12
3
How to change the format of a cell in Excel | Microsoft
1:25
4
How to create a bulleted or numbered list in Word | Microsoft
1:46
How to create a list of sequential dates in Excel | Microsoft
1:05
6
Restore your PC to an earlier point in time with System Restore | Windows 10
4:39
7
Windows 10: Add user accounts for family members
6:15
8
How to Recover your Files with File History | Windows 10
4:05
9
Easy ways to personalize your Windows 10 user account
3:45
10
How to add or delete a worksheet in Excel | Microsoft
1:10
11
How to sort data in Excel | Microsoft
1:19
12
How to use the Windows 11 taskbar | Microsoft
2:34
13
How to use Word | Microsoft
1:22
14
Create guest and local accounts in Windows 10
3:27
15
How to setup ANY Bluetooth device in Windows 10 in 4 simple steps
3:28
16
How to search for and replace text in a Word document | Microsoft
1:01
17
Fix Windows 10 problems automatically with a few clicks!
1:47
18
Windows 10: Reset your PC to factory settings (without losing your files)
5:13
19
How to restore your PC with a USB Recovery Drive
4:40
20
Restore your PC to an earlier point in time with System Restore | Windows 10
4:39
21
Keep your PC safe with Microsoft's FREE Windows Defender antivirus
4:24
22
Fix WiFi and Internet Issues Automatically!
2:38
23
How to edit videos with Clipchamp for work | Microsoft
2:27
24
How to back up and restore your PC | Microsoft
1:46
25
How to install and setup a USB printer in Windows 10 - 3 Ways
4:29
26
How to add or remove hyperlinks from a Word document | Microsoft
1:39
27
How to chat with Microsoft Copilot in Word | Microsoft
2:16
28
Windows 11 system requirements | Microsoft
0:55
29
Azure NetApps Performance – Latency higher than expected
6:55
30
How to use OneDrive | Microsoft
1:09
31
Enable remote access with Microsoft Teams Rooms Pro Management | Microsoft
2:21
32
How to change line spacing in Word | Microsoft
1:28
33
How to unlink and re-link OneDrive to solve sync problems | Microsoft
1:53

How to create a list of sequential dates in Excel | Microsoft

3 months ago
6

You can quickly create a list of dates, in sequential order, by using the Fill Handle Fill handle or the Fill command.

Use the Fill Handle

1. Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.

2. Select the fill handle fill handle at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.

Use the Fill command

1. Select the cell with the first date. Then select the range of cells you want to fill.

2. Select Fill, Series, Date unit. Select the unit you want to use.

Tip: You can sort dates much like any other data. By default, dates are sorted from the earliest date to the latest date.

Loading comments...