Wednesday, March 25, 2009

Create an Index File

To deal with large number of files is a very big problem. Even if you store all your files category wise there are still chances to forget them.

So try to adopt the following method.

Open a blank worksheet
Creat an index list which will cover all your excel files or the files which you may need to use very often
Then link your files using INSERT, HYPERLINK
( See the screen shot below )
Go to the cell, then INSERT, HYPERLINK
Select the relevent file
Click OK
Link all the files likewise
Save the file anywhere in your hard disk
Create a shortcut by right clik on the file and place it on the desktop
Get Free Updates:
We will send a confirmation mail. Please check your inbox/spam folder to confirm it
Related Posts Plugin for WordPress, Blogger...

Copyright © 2011 All Rights Reserved | Designed by Amith | Post RSS | Home | About | Disclaimer | Privacy Policy | Contact