How to insert Calendar Control in MS Excel?

Cómo insertar Control Calendar en MS Excel?
Spanish Version of this blog

To insert the calendar control you first have to enable your "Developer" tab. For this click "Excel Option" and check the "Show Developer tab in the Ribbon" option.

Step 1: Go to the "Developer Tab" and click "Insert" control drop down. There you will get "Form Controls" and "ActiveX Controls"

Step 2: In the ActiveX Controls, click the more control option. By doing this you will get the following dialog box.

Step 3: Select "Calendar Control 12.0" and click OK.

Step 4: Drag your cursor on the spreadsheet where you want to keep the calendar. You will get the calendar control as shown below.

Step 5: Select the Calendar and click right. Select the "Properties" option and go to the "LinkedCell" and type the cell number where you want to display the selected date from your calendar.


And there you go..your Calendar Control is successfully inserted. Now you can pick any date from the shown calendar and your date will be visible in the particular cell.

For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com.

Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.

Visit Other MS Excel Tips and Tricks
How to recover unsaved files in MS Excel 2013?
What are Sparklines in MS Excel?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio 
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas

How to move texts from Notepad to Column in MS Excel?

This is also known as "Import a Delimited Text File".

Step 1: To import a Delimited Text File, the user has to go to the “DATA” ribbon. In this there is a tool named “Get External Data”. By the help of this tool user can import data from Access, Web or from Text files. The text file has to be delimited.

MS Excel 2013 - Data Ribbon

Step 2: Click “From Text” Option. An Import Text File dialog box will pop in. Locate the delimited file you want to import in excel. Click “Import”.

Post clicking “Import”, you will get a “Text Import Wizard”. It has 3 steps involved in it. Check My Data as headers and click Next.

Click the Delimiters available in your file. In the shown example it is “Tab” delimiter. Then click Next. This will lead to you Step 2 of 3.

Now you have to identify if the data available in the text file is differentiated by Tab or Semicolon or Comma, Space or Others. Pick the right option and click Next. This will lead to you Step 3 of 3.

Step 2 of this Import Wizard provides you option to select each column and set the Data Format. It has and Advanced option as well to convert numeric values to numbers etc. Once done click Finish.

This will lead to another pop up dialog box of "Import Data". This option allows user to view the data in following format:-

1. Table
2. Pivot Table Report
3. Pivot Chart etc.

It also asks where do you want to put the data say which Cell on the existing worksheet or New Worksheet. Locate the cell from where you want the data to come in. Your available data in Delimited Text file will get imported in excel.

For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com

Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.

Visit Other MS Excel Tips and Tricks
How to avoid #DIV/0! and #Value! Error?
How to create One Variable Data Table using What-if-Analysis?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio 
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas