Community archive

Ask something
Discussion Locked

Excel and creating a menu for regularly used files

0 helpful
1 reply

by smeesh1975

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In word, you can click Tools/Customize, click the commands tab, select Built in menu's and drag the command work up onto your menu bar. By clicking "Add to work menu" on the newly created work menu, you are able to open regularly used documents easily.

I would like to do this in excel. Following all the same steps above, I get to the built in menu's - but (oh no!!!) there is no work command. Does anybody have any ideas as to how I can add this command? {:o{

1 reply

by stevenfwx

It is really not too difficult.
1. Open a new spreadsheet.
2. Select the cells that are in your "view". Mouse-click on A1 and drag until out of view horizontally and vertically.
3. Fill-in with your color or texture of choice.
4. Imagine the look of the layout you want, evenly spaced icons lined up like a grid or randomly spaced...your choice.
5. Click mouse on cell in the area you desire. Insert clipart or image file.
6. With image highlighted, select Insert and then select Hyperlink (Cntrl K...I think).
7. Browse your files to find the ones you want quick access to.
8. The next time you open your "Menu File" and move your mouse over your icons, the arrow will change to a hand and....presto, you access your desired file.

Good Luck! Any questions, email me.

This discussion is closed to new replies.