Do you have a lot of information and is it scattered everywhere?excel provide you a centralised way to access all your required information with a single click.
Open an excel workbook, type 'Ctrl+K', this will open
an 'insert hyperlink box'.Navigate to files/folders on
your hard drive either through 'Look in: drop down' or
by directly giving the path in 'Address: drop down' as
given below. You can give any meaningful name in the
'Test to display' box.
You can give any path in 'Address: drop down' ,
which includes website address also(eg:http://picasa.google.com/).
Save this workbook somewhere in your hard disk.
Now you can access all the information stored in this workbook
with a single click !!!
Open an excel workbook, type 'Ctrl+K', this will open
an 'insert hyperlink box'.Navigate to files/folders on
your hard drive either through 'Look in: drop down' or
by directly giving the path in 'Address: drop down' as
given below. You can give any meaningful name in the
'Test to display' box.
You can give any path in 'Address: drop down' ,
which includes website address also(eg:http://picasa.google.com/).
Save this workbook somewhere in your hard disk.
Now you can access all the information stored in this workbook
with a single click !!!