Question about Microsoft Excel for PC

1 Answer

I want to link a word document to a cell in Excel

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 38 Answers

Dear nshrivas,

Type some text in a cell and select that cell then right click choose Hyperlink option then select the file which you want to link and click ok.....


Thanks,



Posted on Sep 25, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel 2007 document recovery repeating document on Terminal Server


MS Excel File can get corrupted due to virus attack, missing MS office files, power failure and other possible reason that can be fixed by only use Stellar Phoenix Excel Recovery fix corrupt Excel (.XLS/.XLSX) files and restore everything (including charts, chartsheets, cell comments, worksheet properties etc.

Jan 04, 2015 | Microsoft Excel for PC

1 Answer

Hyperlink other document in excel button


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC

1 Answer

Excel table link in word


Excel and Word are two parts of the Microsoft Office Suite that have become standards tools for spreadsheets and word processing.
Among their features are the ability to easily exchange information.
For example, you can easily copy a cell or part of a spreadsheet from an Excel and paste it into a Word document, which preserves all the formatting.
This method requires opening up both programs at the same time.
To avoid this, you can insert an Excel file from within Word itself.

Choose the "Insert" tab inside Microsoft Word to display the Object dialog box.
Click the "Create from File" tab and Browse to display the Browse dialog box.
Navigate to the Excel file that you need and double-click to load its name into the File Name box of the Object dialog box.

Click a checkmark into the "Link to File" box if you want the table that you insert to be automatically updated anytime the original file is changed.
Otherwise, leave it blank if you don't want the inserted information to be affected by the original file.

Click "OK" to insert the Excel file as a frame into the document.
Note how only filled cells from the first table (worksheet) of the file are inserted.
Blank cells are not inserted. You can resize the frame by clicking it and dragging the handles that appear.
You can also click it and drag it to a different line within the document.


http://office.microsoft.com/en-us/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx - BM4

Aug 07, 2013 | Microsoft Excel Business & Productivity...

1 Answer

Excel to word tables linking


Excel and Word are two parts of the Microsoft Office Suite that have become standards tools for spreadsheets and word processing.
Among their features are the ability to easily exchange information.
For example, you can easily copy a cell or part of a spreadsheet from an Excel and paste it into a Word document, which preserves all the formatting.
This method requires opening up both programs at the same time.
To avoid this, you can insert an Excel file from within Word itself.

Choose the "Insert" tab inside Microsoft Word to display the Object dialog box.
Click the "Create from File" tab and Browse to display the Browse dialog box.
Navigate to the Excel file that you need and double-click to load its name into the File Name box of the Object dialog box.

Click a checkmark into the "Link to File" box if you want the table that you insert to be automatically updated anytime the original file is changed.
Otherwise, leave it blank if you don't want the inserted information to be affected by the original file.

Click "OK" to insert the Excel file as a frame into the document.
Note how only filled cells from the first table (worksheet) of the file are inserted.
Blank cells are not inserted. You can resize the frame by clicking it and dragging the handles that appear.
You can also click it and drag it to a different line within the document.


http://office.microsoft.com/en-us/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx - BM4

Aug 07, 2013 | Microsoft OFFICE 2013 HOME AND BUSINESS 1...

1 Answer

How i can crack the password of excel sheet..............


Hi,

Have tried downloading the password.xla? If not, below is the link:

http://www.straxx.com/excel/password.html

Just add this xla to your addins and then open your excel document. The sheet will be automatically be unprotected.

Feb 09, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Deleting file from Excel also from recently created documents.


Hi jv_oberg,

The recent documents area of excel is just a snapshot of what it last opened, it's not really linked that document to excel. Eventually, after you open enough documents it will fall off the list. However, if it something that you would like to change, you can

  1. Click on Office button, and then click on Word Options (in Word 2007) or Excel Options (in Excel 2007) or PowerPoint Options (in PowerPoint 2007) in the bottom of Office Menu.
  2. Go to the Advanced tab.
  3. Scroll down to the Display section.
  4. Set the value for Show this number of Recent Documents: to 0 (zero). no-of-recent-docs.jpg
  5. Click OK button.
  6. Repeat steps above again, and set back the value for the number of Recent Documents to show to its original default, i.e. 17. If you don’t want this particular Office 2007 application to remember any Recent Documents, you can leave the value at 0 and skip this step.


That will clear your recent documents.

Good Luck,

Mark

Don't forget to leave a rating!

Thanks

Jan 06, 2009 | Business & Productivity Software

2 Answers

Copy-paste


it should be

=7/4  or =100/30
and excel will give you a numeric result.

Oct 18, 2008 | Microsoft Excel for PC

1 Answer

VISUAL BASIC TOOL LIKE SCROLL BAR, COMBO BOX US IN EXCEL


hello

You can make a link into cell that you want by right mouse click
Heperlink, link to , place in thins document , on the feild type the cell reference (A22 ,E56) ...etc , & link where is the cell that you want link to . & in which sheet it is .


i hope good luck

Jan 10, 2008 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

47 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...