If you want to enter a date value in a cell, but the in-cell icon button is not shown automatically when you click the cell, you can display the calendar manually by the following operations:
In Excel 2003, if the
toolbar is not visible, click Excel menu -> -> to display it. You can also choose to display or hide the button/command on the toolbar and right-click menu with the window, which can be opened by clicking the button on the toolbar, or clicking the button on the pop-up calendar window.In Excel 2007 and later versions, you can change the installation mode of the window.
ribbon group to be either in a separate tab or the standard tab, by choosing the corresponding option located on the