To display thewindow, click the button on the toolbar in Excel 2000/XP/2003, or click the button on the ribbon tab in Excel 2007/2010. The 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 Version||Settings Window|
|Excel 2003 (Windows XP)|
Click to enlarge
|Excel 2007/2010 (Windows 7)|
Click to enlarge
By default, the in-cell icon button is displayed automatically when you click a cell which is:
You can enable or disable the above options respectively in thewindow, which can be opened by clicking the button on the toolbar, or clicking the button on the pop-up calendar window.
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 tabin the ribbon, or a group in the standard tab. You can change the installation mode by choosing the corresponding option in the " " field on the window (See the figure above).
If you change the installation mode from "" to " " 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.
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 thewindow, which can be opened by clicking the button on the toolbar, or clicking the button on the pop-up calendar window.
To specify the default date format, enter a format string in the box underneath thecheckbox.
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 display||Use this code|
|Months as 1-12||m|
|Months as 01-12||mm|
|Months as Jan-Dec||mmm|
|Months as January-December||mmmm|
|Days as 1-31||d|
|Days as 01-31||dd|
|Years as 00-99||yy|
|Years as 1900-9999||yyyy|
In addition to any valid combinations of the above format codes, you can also enter "" and " " as the date format string.
|To display||Use 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|
By defaultdisplays 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 "" option on the 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.
The option "allows you to specify whether 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 "" and the " " 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.