General discussion


Excel and creating a menu for regularly used files

By smeesh1975 ·
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{

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating a "menu" page in Excel...

by stevenfwx In reply to Excel and creating a menu ...

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.

Related Discussions

Related Forums