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.
GeoffW71
Aug 13, 2024Copper Contributor
Thank you for your updaets however i cannot click and get the celander .. ive followed exactly am i doing something worng ??