[FAQ000096]Is it possible to show the file path and open it as a link?

Q

Is it possible to have the file path or folder path appear on the CELF sheet

as a link so that the file or folder will open when the user clicks on it?

A

The HYPERLINK function can be used to create a link to a file path.

HYPERLINK（Link to URL, alias）

If the file type is associated with a program on the Windows side,

you can open a folder or a file directly by specifying the path of the corresponding file.

e.g.)

=HYPERLINK("C:\temp\File1.xlsx")

=HYPERLINK("\aaaa\bbbb\cccc\Folder1")

=HYPERLINK("\aaaa\bbbb\cccc\Folder2\File2.xlsx")

Related keywords

Hyperlink