Excel Popup Calendar

What is Excel Popup Calendar?

Pop-up calendar add-in: A solid Excel date selector with easy date formatting.

Every time you start entering a date in a cell, you wonder... Should you type MM/DD/AAAA or use some other request? Should you use the '/' tab or maybe '-'? Will the date format be displayed exactly as you want? This is when an Excel date picker or a suspended calendar is useful. It is indispensable even when you manage lists of personal or business tasks, appointments or schedules, project trackers, or financial reports in Excel spreadsheets.

The pop-up calendar is a comprehensive and reliable date selector trusted by more than 30,000 Excel users:

• Intuitive use: click on a cell - choose a date
• Descends near a cell, displays week numbers, days of the week, and the current date
• Fills columns, rows, or any ranges with date values in one click
• Numerous default, predefined, and custom date format options
• Works in 64-bit and 32-bit Excel

Learn your way:

• How to enter or change a date in a cell using the pop-up calendar
• How to enter the current date in a date selector cell
• How to fill an entire column, row, or range of nonadjacent cells with dates
• How to fill a range with consecutive dates
• How to enter date and time in a cell
• How to enter only time (no date) in a cell
• How to change the default date format of the pop-up calendar
• How to change a shortcut to the pop-up calendar
• How to add/remove the Calendar pop-up icon
• How to add/remove the pop-up calendar from the right-click menu
• How to embed a date selector in a spreadsheet

How to enter or change a date in a cell using the pop-up calendar

Select a cell.

In the Date/Time group, click the 'Enter Date' > The date selector will be displayed next to the cell.

Or: Right-click and choose 'Enter date'.

Or: use a shortcut - press Ctrl +; (semicolon).

Choose a date you need in the calendar> Done.

Notice the date format: is this what you wanted? Learn how to change the default date format.

To change a date value, click the Calendar icon to the right of the > Change Date.

The pop-up calendar remembers the last date used, so it's easier to enter a date next time.

How to enter the current date in a date selector cell

Select a cell in which you want to enter the current date.

In the Date/Time group, click the 'Enter Time' button > Calendar will be suspended.

Or: Right-click and choose 'Enter date'.

Or: use a shortcut - press Ctrl +; (semicolon).

Click 'Today' at the bottom of the Calendar> Done.

How to fill an entire column, row, or range of nonadjacent cells with dates

You can use the pop-up calendar to fill dates across a range (throttling of up to 4,000 cells). Fill table columns, rows, merged cells, nonadjacent cells, or any custom range in the same way, such as a single cell:

Select a range.

In the Date/Time group, click the 'Enter Time' button > Calendar will be suspended.

Or: Right-click and choose 'Enter date'.

Or: use a shortcut - press Ctrl +; (semicolon).

Select a date> Isdone. The entire range is filled with the value of the selected date.

Tip: Learn how to populate cells with consecutive dates.

To change a date in a specific cell, click the Calendar icon to the right of the > Change the date.

How to fill a range with consecutive dates

With Popup Calendar, you can quickly fill an interval with consecutive dates (sequential days):

XLTools tab> Settings button> Date/Time tab> Check the 'Automatic date increment when I use the date selector for a cell range'> OK.

Select a range.

In the Date/Time group, click the 'Enter Date' button > The date picker will be displayed.

Or: Right-click and choose 'Enter date'.

Or: use a shortcut - press Ctrl +; (semicolon).

Choose the start date to fill the interval>, the entire range is automatically filled with consecutive date values with 1-day increments.

How to enter date and time in a cell

Select a cell.

In the Date/Time group, click the 'Date and Time' button > The Pop-up Calendar with Clock will appear next to the cell.

Or: Right-click and 'Enter date and time'.

Or: use a shortcut - press Ctrl +; (semicolon), release the keys and press Ctrl + Shift +; (semicolon).

Set the time using a scroll wheel or the Up/Down arrows> Choose a date in the Pop-up Calendar> Finished.

Notice the format of the time: is this what you wanted? You can change the default format of the pop-up calendar and the clock.

To change an entry, click the icon to the right of the > Change time and date.

How to enter only time (no date) in a cell

Use the Time selector of the Pop-up Clock to set and enter the time in cells and intervals:

Select a cell or range.

In the Date/Time group, click the 'Enter Time' button > The Pop-up Clock will appear next to the cell.

Or: Right-click and 'Enter time'.

Or: use a shortcut - press Ctrl + Shift +; (semicolon).

Set the time using a scroll wheel or the Up/Down arrows> Enter> Finished.

How to embed a date selector in a spreadsheet

The XLTools pop-up calendar date picker cannot be embedded in the worksheets. The Popup Calendar is visible and available to other users only if they also have XLTools installed.

If you need to share a workbook, you might like our embeddable date picker - the online add-in Calendar XLTools.net. No installation is required - share a workbook with colleagues, and they can also use the calendar. This web-based date selector is perfect when you need to send schedules, templates, Excel times

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768