4 replies
by guido Accepted solution
by jamie Accepted solution
=HYPERLINK(link_location,friendly_name)
example: =HYPERLINK("D:\FINANCE\00010.pdf", "D00010")
by r.villanueva Accepted solution
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 Accepted solution
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.
Trending Software posts
Sort by Trending