Saturday, 31 March 2012

how to create a personal directory in Excel

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.


Insert hyperlink options in Excel


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 !!!