Question about Microsoft Excel 2010

1 Answer

I am trying to copy text from Word that has a hyperlink into an excel 2010 spreadsheet. how do I make hyperlink work in excel?

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Top Expert:

    An expert who has finished #1 on the weekly Top 10 Fixya Experts Leaderboard.

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

  • Microsoft Master
  • 29,395 Answers

This is what the HELP feature is for in the top toolbar :>)

  1. Right-click the text or graphic you want to represent the hyperlink, and then click Hyperlink on the shortcut menu.
  2. Under Link to on the left side of the dialog box, click Existing File or Web page.
  3. Do one of the following:
    • To select a file from the current folder, click Current Folder and then click the file you want to link to.

    • To select the Web page from a list of browsed pages, click Browsed Pages and then click the Web page you want to link to.

    • To select a file from a list of files you have recently used, click Recent Files and then click the file you want to link to.

    • If you know the name and location of the file or Web page you want to link to, you can type that information in the Address box.

    • To select the Web page by opening your browser and searching for the page, click Browse the Web I am trying to copy text from Word that has a hype - 1922.gif, open the Web page you want to link to, and then switch back to Microsoft Excel without closing your browser.
  4. To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. Click OK.

Posted on May 06, 2016

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

5 Answers

HYPERLINKS


What kind of message do you get when you click on dead hyperlink?

Jul 31, 2008 | Dell Dimension 2400 PC Desktop

Tip

Script to extract URLs in Excel Spreadsheets


The following script could be used to extract the actual URLs from the text link in an Excel spreadsheet. The script writes each URL in the cell next to the text link:

Sub main()
Dim h As Hyperlink

For Each h In ActiveSheet.Hyperlinks
h.Range.Offset(, 1) = h.Address
Next
End Sub

Here is how to use the script:
1. On the "Tools" menu, point to "Macro", and then click "Visual Basic Editor". This will open the Visual Basic Editor in another window.
2. On the extreme left, you will find the "Project - VBAProject". Double-click the icon named "Sheet1 (Sheet1)", "Sheet2 (Sheet2)", or whatever the name of your worksheet. This will open a blank window. Copy & paste the script into this window.
3. Press F5, then click on "Run".
4. Go back to your Excel window. You will now find the URLs listed in the next cell to the original one with the hyperlink.

on Dec 01, 2009 | Microsoft Excel for PC

1 Answer

I want to copy an Excel chart as a Image onto a PowerPoint Slide (Office 2007). What is the sequence of APIs to apply?


Copy worksheet data to a PowerPoint presentation
  1. In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
  2. On the Home tab, in the Clipboard group, click Copy za006044679.gif.

za010165428.gif

Keyboard shortcut You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied worksheet data.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

  1. Click Paste Options za006043532.gif next to the data, and then do one of the following:
    • To use the original format of the copied data, click Keep Source Formatting.
    • To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
    • To paste table data that you copied as text, click Keep Text Only.

Notes

  • If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button za010077102.gif, and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
  • If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
Tips
  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
    • If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
    • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) PowerPoint application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.
    • If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
    • To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
    • To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a PowerPoint presentation to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link. This works only when you copy data that is not in table format in Excel.

Mar 09, 2011 | Individual Software Professor Teaches Word...

4 Answers

My PDF converter is not working after I put my email and registration code in.


Try other PDF Converter program.
What i use now is Tenorshare PDF Converter. it is a 5-in-1 PDF utility which helps you batch or partial convert PDF files to editable Words, or converts Word documents, PowerPoint presentations, Excel Spreadsheets to PDF files at one time.

Feb 17, 2011 | Abdio Software Abdio PDF Reader

1 Answer

Not Enough Memory to run Microsoft Office Excel. Please close other Applications and try again..


Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.

If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?

Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.

Oct 18, 2010 | Microsoft Excel for PC

1 Answer

My excel file was working yesterday, but as of


Shouldn't be a date issue... did you open the file the way you normally do ?
Something has changed here... bad shut down with this file opened... maybe.
Open Excel and pull down the File Menu and see if there are more than copy or version of your spreadsheet. Look at all...
File could have corrupted the Font or could be a Virus. Try just changing the font in one cell.
If this is your only copy of the file... make a copy to see if it works on another machine... that will isolate the problem... it may just be corrupt... the fix is Excel healing it on it's own when it opens.

Jan 01, 2010 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Can I provide password for a hyperlinked spreadsheet


save the file to the desired location & then right click on the same & set the password. If you know the password then only the file would open

Apr 10, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Pdf to excel


Have you tried selecting the text, and then copying that text and pasting it into an Excel spreadsheet?

If the text is not selectable, using Acrobat's text selection tool, you will need the password to be able to access it.

Jan 08, 2008 | Adobe Photoshop 7.0 for PC

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

Related Topics:

38 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...