How to Return to Today in an Excel Date Picker or Calendar in WPS Office
Question details
The user needs to quickly return to the current date in an Excel date picker or calendar control after moving to another date or year.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a calendar control in an Excel workbook and wants to jump back to today's date without manually scrolling back through months or years.
- Observed behavior
- The calendar should return to the current date in one action instead of requiring manual navigation back to today.
Check whether your date picker is a built-in form control, an ActiveX control, or an add-in, because the available Today command or property differs. If you plan to use =TODAY(), format the linked cell as a date in WPS Office Spreadsheets.
Use the calendar control's Today button or command
Use this when the date picker or calendar control already has a Today button, which is the fastest way to jump back to the current date.
The Today command is normally displayed at the bottom of the calendar popup in built-in date pickers. Not all form controls, ActiveX controls, or add-ins expose it, so check the control interface first.
In WPS Office Spreadsheets, open the workbook and select the worksheet that contains the Excel calendar control.
Click the calendar drop-down or activate the date picker, then click the Today button or Today command shown in the calendar popup.
Check the linked cell or calendar field to confirm that the selected date now matches the current system date.
Reset the date picker with a linked =TODAY() cell
Use this when the calendar control has a LinkedCell property or when you want a cell-driven date that always updates to the current date.
Create a small macro to set the calendar value to today
Use this for custom ActiveX calendar controls or add-in based date pickers that support VBA automation.
Return to Today in an Excel Date Picker with WPS Office
WPS Office Spreadsheets lets you manage Excel date pickers and calendar controls with built-in date functions, linked cells, and macro support, so you can jump back to today's date quickly.
- 1. Download and open WPS Office Spreadsheets: Download WPS Office from the official website, install it, and open the workbook that contains the date picker or calendar control.
- 2. Locate the date picker control: Click the worksheet tab and activate the calendar control or date picker that you want to reset.
- 3. Use the Today button or linked cell: If the control shows a Today button, click it. If not, select a date-formatted cell, enter =TODAY(), and link the calendar control to that cell.
- 4. Verify the result: Check the calendar display and the linked cell to confirm the date is returned to today's date.
Frequently Asked Questions
Where is the Today button in an Excel date picker?
In many calendar controls, the Today button appears at the bottom of the popup calendar. Open the date picker and look for Today or Now. If the control does not show one, use a linked =TODAY() cell or a macro.
How do I use =TODAY() to reset a date picker in WPS Office?
Select the linked cell or an empty date-formatted cell, type =TODAY() in the formula bar, press Enter, and set the calendar control's LinkedCell property to that cell.
Can I create a macro to set the Excel calendar back to today?
Yes. Open the macro editor with Alt+F11, insert a module, and assign Date to the calendar control's Value property, for example Calendar1.Value = Date, then run the macro.
Does WPS Office support Excel date picker controls?
WPS Office Spreadsheets supports common Excel workbook controls and date functions. The exact behavior depends on whether your calendar is a form control, ActiveX control, add-in, or custom workbook component.
What is the difference between a form control and an ActiveX date picker?
Form controls are simpler and often only link to a cell, while ActiveX controls expose properties such as Value and LinkedCell that you can control with VBA. Check the Developer tab or the control's properties to identify the type.
