Question Locked

automate hyperlink within excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to know how i can automate a column with numbers to make a hyperlink to the corresponding pdf document in another directory, for instance number D00010 should make an hyperlink to 00010.pdf.

4 replies

by jamie

=HYPERLINK(link_location,friendly_name)

example: =HYPERLINK("D:\FINANCE\00010.pdf", "D00010")

by r.villanueva

Hi! Guido i hope my reply has able to help you;

1. first make a map the folder from the network that contain a PDF file
example : Z:\PDFFILES
the map Z:\ folder contain two file(s)
test.pdf
testfile.pdf

Note: Please make sure that their no special character on the filename of
the PDF and make the filename 8 character only to avoid error.

2. on Excel right click the cell that you want to active the HyperLink and
open the share folder

Ex: Z:\PDFFILES\test.pdf

Make sure the address has shown Z:\PDFFILES\test.pdf ( correct
path )

not like this ..\PDFFILES\test.pdf ( incorect path )

3. Press Ok if finish

i hope you problem will be solve.

Thank you best regards

Rolando r. Villanueva
IT Support
rr.villanueva@gmail.com

by r.villanueva

Dear GUIDO
Here are same example to automatic numbering in excel.

Automatically number rows in EXCEL
Fill a column with a series of numbers

Note: These numbers are not automatically updated when you add, move, or remove rows. You can manually update the sequential numbering by selecting two numbers that are in the right sequence, and then dragging the fill handle to the end of the numbered range.

Select the first cell in the range that you want to fill.
Type the starting value for the series.
Type a value in the next cell to establish a pattern.
How?

For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4.

Select the cells that contain the starting values.
Drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) across the range that you want to fill.
To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
Is the fill handle missing?

To display the fill handle on a selection of cells, click Options on the Tools menu, click the Edit tab, and then select the Allow cell drag and drop check box.

Select a cell that has a hyperlink in it
To select a cell that has a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button.

I hope my reply has usefull and able to solve your problem.
Best regards

Rolando R. Villanueva
IT Technical Support

This discussion is closed to new replies.