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.
crazysidewaysdog
Jul 15, 2024Copper Contributor
EternallyConfused Doesn't work on Excel for Mac 16.86 (24060916) 365