Excel calendars

Resolved · Medium Priority · Version 2016

Mon 9 Mar 2020, 16:47 Delegate Shanay said...

Shanay has attended:
Excel Advanced - Formulas & Functions course

Excel calendars

Is it possible to create a calendar on a spreadsheet on a excel worksheet, that automatically updates when each month is selected?

Mon 9 Mar 2020, 21:11 Trainer Jens said...

RE: Excel calendars

Hi Shanay,

Thank you for the forum question.

When you write calendar. Do you mean something like the Outlook calendar? You select a month may be from a combo box and then a calendar is showed in the worksheet with all the tasks and meetings you have the selected month.

Or do you want all dates to display in a column from selected month?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

Excel calendars

Excel calendars

RE: Excel calendars

Excel articles

Excel tip:

Turn off AutoComplete in Excel