Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel calendars

ResolvedVersion 2016

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?

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:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.