I'm going to press Ctrl+G for the Immediate window I'm going to type "? Now, if you don't know what folder it is, I'm going to press Alt+F11 Know and also 2 years from now, when I have noĬlue how I ever did this, I can come back and find it as well. I'm happy that I've figured it out, and I'm sharing it so that way you will Today, a question from Selina that I had no clue.
#How do i create a hyperlink in word full
(Put Z99 in the top left of your window and then figure out what is the last full cell you can see.) This workaround is not perfect, because it assumes everyone has the same size monitor and keeps Excel full screen.Įxcel from MrExcel Podcast, Episode 2182: Can Word Hyperlink to a Specificīill Jelen. I guess if I want Z99 near the top, I would have to cheat and ask Excel to go to AT123. Technically, Excel is doing what you want. Why F78? Because if you can see F78 in the top left, then Z99 is visible somewhere in the window. If you tell Excel to jump to Z99, you might expect Excel to scroll so that Z99 is the top left corner cell in the window. But after closing and restarting Word, the message went away. I skipped this and had to say some four-words when they kept nagging me about the file being unsafe. Near the bottom, choose Add New Location.On the left side, choose the second choice - Trusted Locations.On the right side, click Trust Center Settings.Get the path to where the Excel file is stored.To stop this warning, follow these steps: They warn you that the Excel file may not be safe. Problem #1: Word shows an annoying warning box when you Ctrl + Click the hyperlink. Type a name with no spaces, such as JumpHere. Click in the Name Box to the left of the formula bar. Go to the cell in Excel where you want to hyperlink to. In the video, I suggest a different approach. In Excel, you would not have to use apostrophes around the sheet name unless the sheet name contained spaces or punctuation. That is *weird*! The syntax does not feel like Excel. You want to jump to the sheet called IncomeStatementĬ:\FolderName\FileName.xlsx#'IncomeStatement'!Z99
#How do i create a hyperlink in word how to
Selina's question, though, is how to have Excel jump to a specific sheet and location. Press Ctrl + V to paste the results of #5 above.Īt this point, the hyperlink would simply open the Excel file to the last active sheet and cell. Press Ctrl + K to open the Hyperlink dialog. Select where you want the hyperlink to appear. Select the resulting line and press Ctrl + C to copy to the clipboard.On the next line, you will see the full path and file name.Type Debug.Print ThisWorkbook.FullName and press Enter.Press Ctrl + G to open the Immediate pane.Well, it may not work like you want it to work, but it nominally works.įirst, figure out the full path & file name of the Excel file. The syntax is fairly tricky, but it seems to work. Can a hyperlink in Word open a specific Excel file, jump to a sheet and jump to a cell?