I-8 Markaz, Islamabad, Pakistan +92-313-1523538
Excel Tutorials, Tutorials, Word Tutorials
In this tutorial, you’ll learn to link Excel Worksheet to Word Document instead of embedding Worksheet in the document. Below are some steps to make it work:

Excel worksheet to Work document

Step#1:

Open new Word Document. Define your template and Write whatever the text you want before the Worksheet. Link Excel Sheet to word Document

Step#2:

Next step is to link Excel Worksheet into the Word document. For that, we’ll move to “Insert” from the ribbon tab and Select “Object” in “Text” Section. You can use shortcut key for that as “alt+n+j+j”. Link Excel Sheet to Word Document

Step#3:

Object Popup box will open. Select “Create from file” tab and Press “Browse”. You’ll see file selection box to Select file. Link Excel Sheet to Word Document After selecting file, don’t forget to check “Link to file”. It’ll create a shortcut display on your word document file. HOW TO USE COMBO BOX FROM EXCEL FORM CONTROL

Step#4:

You’ll see the Excel worksheet in Word document in the form of object. Link Excel Sheet to Word Document Here is the view of Excel worksheet linked to Word Document. Link Excel Sheet to Word Document You’ll see if the value in worksheet is changed, Word document will not detect it suddenly. To update the link in document file, right click on Worksheet Object and select “Update Link”. It’ll update all the values.

Precautions:

Whenever you link the Excel file to Word Document, you need to keep the link breakage in mind. There are following reasons that will break the link in your word and Excel file.
  • If you’ll rename the Excel file linked in the word document, you’ll break the link.
  • If you’ll rename the folder that contains the excel file linked to document, you’ll break the link.
  • If you’ll email the document file and doesn’t attach linked excel worksheet, you’ll break the link.
Please Share your review with me in the comment section to help improvements and make things better. I’d love to hear from you.
0

Excel Tutorials, Tutorials
In this tutorial, you’ll learn how to use Combo Box form control in your excel sheet. We’ll be using Interest Calculator for this purpose, as shown below: ComboBox from Excel Form Control

Step #1:

We’ll replace “Rate group box” with Combo Box. So, we’ll select Group box and press ‘Del’ button. Then, press ctrl and click on Radio Buttons to select them and press ‘del’. we’ll remove the rows 6 & 7 and Add one new row. ComboBox from Excel Form Control

Step #2:

We’ll insert the Combo Box in B6 box. For that we need to insert Combo Box from Insert in Developers Option. ComboBox from Excel Form Control

Step #3:

Press alt and, Click and drag in B6 to draw Combo Box. ComboBox from Excel Form Control LEARN HOW TO APPLY DATA VALIDATION IN EXCEL

Step #4:

To add list of values, we need to list all the value on other sheet. And use that range in Combo Box. So, we’ll create new Sheet with the name “Data” and list all the values of interest rates. ComboBox from Excel Form Control We’ll enter two values with the difference of 5%. Select these two values and drag down to 5 cells. Excel will detect the difference and fill the values with the difference of 5% in each cell increasingly. ComboBox from Excel Form Control

Step #5:

It’s best practice to define name for ranges to select them. So, We’ll select the cell ranges with values and go to “FORMULAS” ribbon tab. And select “Create from Selection”. ComboBox from Excel Form Control It’ll pop out a dialog box to give you options to select naming box for the range. ComboBox from Excel Form Control We have name to define range in the top row. So we’ll select “Top row” and select Press OK.

Step #6:

Now we have a defined name for the values of interest Rate. We’ll go to “Interest Calculator” Sheet. Select Combo Box and go to Format Control. ComboBox from Excel Form Control   It’ll give you dialog box to insert range of cells for the values. We’ll insert the name defined for values. I.e.: Interest_Rates ComboBox from Excel Form Control Press OK. Click on some other cell to remove selection focus of Combo Box. And then Check the Drop Down List, you’ll see all the values of range entered on “Data” Sheet. ComboBox from Excel Form Control   Share reviews in comments.
0