You already know that the Copy and Paste commands allow you to bring to your Excel the information you need to easily add.
Although in this case you are simply bringing the information without further ado.
However if what you want is for the information you bring to Excel to change when the original file you bring it changes , then you’re talking about linking .
In this article you are going to learn how to insert a linked object in the Excel electronic sheet, you can insert objects such as: PowerPoint slide, Word text, images, sound clips, and many more.
It is also possible to perform this action in other Office programs, such as bringing a Word document or one of a range of Excel cells as a linked object.
Now you will see how to do it in a few simple steps:
- Open an Excel sheet.
- Place the cursor in any cell of the sheet.
- In the Ribbon of Excel 2007 go to the Insert tab (for Excel 2003 from the Insert menu), and then within the Text workgroup, click on the Object icon.
- A new window opens with two tabs, Create new and Create from a file.
- Create new .
- The first option allows you to create almost all kinds of elements from the beginning: Adobe, sound clip, slide, Word document, movie, …
- Click on one of the options, for example Sound file, wait a moment.
- The sound application opens so you can record the content you want and it is stored in the spreadsheet, ready to be listened to when you click on the speaker icon.
- Another object to link: Office document, Word.
- Choosing it opens a white box in the Excel sheet, as well as all the commands of the Word program.
- Type what you want and then click the part outside the Word area
- Keep calculating with the electronic sheet.
- Close saving the changes or not according to your interest.
Create from a file.
- Now you are going to insert a linked object from a file that you already have.
- Go to Insert object.
- Go to the Create tab of a file by clicking on it.
- Click on the Insert button.
- In the window that opens, locate and choose the file to insert, it can be an image, a slide, a Word document …
- Choose for example a Word file, press Insert.
- In the window called Object, activate with a click the Link option, marking in the white square.
- Click OK.
- In Excel the Word document appears wherever you have the active cell.
- If you double click on the document it will open in a new window.
- Make some modification to the Word document, save the changes and check how said change is also reflected in the linked object in Excel.
- To continue practicing you are now going to insert an image of the ones you have in PowerPoint or in an Adobe document.
- The steps are the same by selecting the corresponding file.
- Close the spreadsheet.
Find tech article from themesmob
A couple of Tips :
If, when creating a file, you activate the box called Show as icon, the linked object is inserted as an icon and when you click on it, it will open. Activate this option by checking the white rectangle and then OK.
You can make the document, image, etc. inserted resize by clicking on the sides or corners of it to fit the spreadsheet.
You can create ranges of cells in Excel or in any spreadsheet . In spreadsheets, Excel and others, the way to create ranges is if not very similar in all of them.
Starting from an Excel workbook you are going to create ranges and carry out different actions with them.
The first thing is to define what a range is, since a range in electronic sheets is a set of cells that contain data and in which operations can be performed and serve as a starting point for many others, such as making graphs, dynamic tables , filters, …
To create a range you have to select the cells that conform it well with the mouse or with the keyboard, as you will now practice, and then give it a name.
Steps to create ranges in Excel cells
- Opena blank Excel workbook
2. From cell A1 to F7 enter a series of numbers, whatever you want. To make this easier and faster you can use the random formula as you can read in: Create random numbers in Excel .
3. Move your mouse to A1 and click with the left button, then without releasing the mouse button, scroll to F7, once there, release the button. Another way is to put the active cell in A1 then press the Shift key and if you release it click F7.
4. You will see that the area between A1: F7 has been highlighted in blue.
5. You are going to put the name Sales to this range, there are several ways to do it, one of them is to go to the Formulas tab , click on it, and then in the Defined names work group , click Assign name to a range .
6. A small window is displayed where it asks you to determine the following information:
Name : Give a name to the range, for example Sales.
Scope : if you want you can change it but I recommend that you leave it unchanged in the Book so that it collects the information on all the pages of the Book.
Comment : You can write a short information to detail the composition of the range.
The part refers to the one as it is, which already brings the information of the selected cells that make up the range.
See enlarged image.
7. To check that the range is well created, go back to the sheet and select again from A1 to F7, you will see that the word Sales appears in the name box (next to the formula bar on the left).
In the Defined names group you have other possibilities when working with ranges.
One is Create from selection, with this tool if your range has a heading it will start from that information to give the name to the range.
And another is the Name Manager, from where you can see, create, delete all ranges of the book or sheet.
There are other ways to create ranges, that is: after selecting the matrix that is going to compose the range, right-click and choose Assign name to a range in the options presented… You will access the same window in the previous steps.
An example where you can work with ranges is for the construction of graphics always starting from the same coordinates, since if you have the established ranges you will perform them faster and more safely since you will not have to select the cells every time, this is especially interesting in large sets of figures.
You can select both ranges where the cells are contiguous and separate. For this you have to make the selection of the different ranges by holding down the Ctrl key, check that the selected ranges are generally highlighted in blue.