Forum Discussion
How to add pop-up calendar in spreadsheet cell
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.
- GeoffW71Aug 13, 2024Copper Contributor
Thank you for your updaets however i cannot click and get the celander .. ive followed exactly am i doing something worng ??
- crazysidewaysdogJul 15, 2024Copper Contributor
EternallyConfused Doesn't work on Excel for Mac 16.86 (24060916) 365
- PB-04May 14, 2024Copper Contributor
Hi EternallyConfused, Thank you for the answer.
Is it available in Mac as well?