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

richard excel calendar

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Richard, Excel calendar

Richard, Excel calendar

ResolvedVersion 2013

Grace has attended:
Excel Intermediate course

Richard, Excel calendar

Please may I know how to create a calendar in excel? Is it something that needs to be imported?

RE: Richard, Excel calendar

Hi Grace,

I am looking into the Calendar in Excel.
Someone at Goldsmith's also asked Today if an Outlook "calendar" could be exported to Excel and "edited".
Once I come up with an Answer I will let you know.


Kind regards

Richard Bailey
Microsoft Office Specialist Trainer

Best 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

RE: Richard, Excel calendar

Hi Grace,

If I remember correctly, you wanted to have a Date Picker box (mini Calendar) pop up to select the dates.

This was in Excel 2007 but has been removed in the latest version Excel 2013.

They are offering it as an Add-in to Excel (at cost) but it isn't a Standard option.

The link is below
https://store.office.com/mini-calendar-and-date-picker-WA102957665.aspx?assetid=WA102957665

I will upload an Excel Sheet formatted as a Calendar. This doesn't link to Outlook, that isn't something we can do without some advanced VBA coding in Excel.



Kind regards

Richard Bailey
Microsoft Office Specialist Trainer

Best 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

Attached files...

Calendar.xlsx

Thu 2 Jul 2015: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.