Bookmarking spreadsheets in excel as favorites

mary in south bend

New Member
Joined
May 14, 2007
Messages
19
Can someone please outline the steps for bookmarking a spreadsheet as a favorite in Excel 2010? I did a search on threads and nothing came up that answered my question. Thanks so much. Mary
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Hi Mary,
Welcome to the board!

Do you mean you want to be able to recall a workbook - - - or a worksheet from within many in a single workbook?

If it is the first, on the Round Office button in the upper left corner of Excel 2007 and Excel 2007, you will see a list of recently opened workbooks. There is a small "push pin" to the right of each file name. If you click on the "push pin" it will keep that file on the list permanently and you can access the workbook quickly.

If it is the second, I am sure that are many ways, but off the top of my head, if a workbook has say 25 worksheets, you could write a macro that would give you a list of the worksheets and quickly access the favorite sheet that you want to access.

If this does not help, please reply back with more information.

Lidsavr
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,609
Messages
6,179,877
Members
452,949
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top