Forum Discussion
PB-04
Dec 26, 2023Copper Contributor
How to add pop-up calendar in spreadsheet cell
Hi How can I add calendar that pops-up on clicking on a cell in excel spreadsheet and allows to select the date. Thank you.
EternallyConfused
May 14, 2024Copper Contributor
PB-04 so if you haven’t already sorted it, ive worked out, date picker is built in to 365 excel differently.
if you highlight cells you want the dates in, right click and click on ‘Number Format…’. Select date from the ‘Category’ list and your preferred date layout from the ‘type’ list. It should then add it in with the option for a pop up calendar when you click or double click on the cell
i couldn’t find any answers just alot of the old method and people saying it can’t be done without an add in. My job blocks add in’s so this is how i got it to work.
PB-04
May 14, 2024Copper Contributor
Hi EternallyConfused, Thank you for the answer.
Is it available in Mac as well?