Skip to main content
office-kit.com main content

Pop-up Excel Calendar Settings

Settings

To display the Settings window, click the Settings button on the Pop-up Excel Calendar toolbar in Excel 2000/XP/2003, or click the Settings button on the Pop-up Calendar ribbon tab in Excel 2007/2010. The Settings window is where you can control how the pop-up calendar (date picker) works for you.

Note: This document was written for Pop-up Excel version 1. For the latest version of this document for our Excel Date Picker, please download it here.

Excel VersionSettings Window
Excel 2003 (Windows XP)Pop-up Excel Calendar (Date Picker) Settings window in Excel 2000/XP/2003 and Windows XP
Click to enlarge
Excel 2007/2010 (Windows 7)Pop-up Excel Calendar (Date Picker) Settings window in Excel 2007/2010 and Windows Vista/Windows 7
Click to enlarge

 

Go to top

When to Display In-Cell Button

By default, the in-cell icon button is displayed automatically when you click a cell which is:

  • Formatted as date. To set the format of a cell in Excel, right click the cell and choose Format Cells. On the Number tab choose Date in the Category list, and then choose a proper date format in the Type list.
  • Filled with a date-like value. For example, if a cell is formatted as "General" but has a date-like value "September 1 2006", Pop-up Excel Calendar will display the in-cell icon button when you click the cell.
  • Underneath a cell with a date value or format in it. For example, if a cell has a "General" format and its value is empty, Pop-up Excel Calendar still can display the in-cell icon button if the cell on the top of it has a date value or format.
  • Underneath a cell that has some form of the word "date" in it.

You can enable or disable the above options respectively in the Settings window, which can be opened by clicking the Settings button on the Pop-up Excel Calendar toolbar, or clicking the Settings button on the pop-up calendar window.

Go to top

Installation Mode (Excel 2007/2010 Only)

In Excel 2007/2010, the classic menu and toolbar based user interface is replaced by a ribbon-based new user interface. Pop-up Excel Calendar can be installed as either a separate tab Pop-up Calendar in the ribbon, or a group in the standard Insert tab. You can change the installation mode by choosing the corresponding option in the "Install this program as" field on the Settings window (See the figure above).

If you change the installation mode from "A group in Insert tab" to "A separate tab" or vice visa, you may or may not be asked to restart Excel 2007/2010, depending on the version of Windows you are running and the type of your Windows account (Administrator, Limited user, etc.). If you see the following message, simply exit Excel and then start it again to make the changes take effect.

Restart Excel message.

Go to top

Setting Default Date Format

If the target cell is not formatted as date, you can choose to have Pop-up Excel Calendar set a date format automatically. This option can be enabled or disabled in the Settings window, which can be opened by clicking the Settings button on the Pop-up Excel Calendar toolbar, or clicking the Settings button on the pop-up calendar window.

To specify the default date format, enter a format string in the box underneath the Apply the following date format if the target cell is not formatted as date checkbox.

A date format string is constructed with format codes, which describe how you want to display date. For example, if your default date format is "mm/dd/yyyy", "September 1, 2006" will be formatted as "09/01/2006". The following tables shows you all the valid codes that you can use in the date format string.

To displayUse this code
Months as 1-12m
Months as 01-12mm
Months as Jan-Decmmm
Months as January-Decembermmmm
Days as 1-31d
Days as 01-31dd
Years as 00-99yy
Years as 1900-9999yyyy

In addition to any valid combinations of the above format codes, you can also enter "dddd" and "ddd" as the date format string.

To displayUse this format string
Full day of week name. eg. "Monday", "Tuesday", "Wednesday"... dddd
3 letter day of week name abbreviation. eg. "Mon", "Tue", "Wed"... ddd

 

Go to top

Displaying Calendar Automatically

By default Pop-up Excel Calendar displays an in-cell icon button when you click a date cell. You need to click the in-cell icon button to open the calendar on which you click to select the date value.

The "Display calendar automatically" option on the Settings window saves one click by displaying the calendar automatically. If you check this option, the calendar is displayed automatically along with the in-cell icon button whenever you click a date cell.

Go to top

Date Can Contain Time

The option "Date can contain time" allows you to specify whether Pop-up Excel Calendar works for the dates or formats that contain time. If this option is checked, a date containing time part will be seen as a normal date, and the time part is ignored. This option is unchecked by default.

For example, if a cell value is "December 3, 2002 16:17:18" and the "Date can contain time" option is checked, when you click the cell the calendar appears. If you uncheck the option, the calendar won't appear when you click the cell.