Excel 2010: Optimize quick access to workbooks

Icon_Excel10_33x32Microsoft Excel 2010 offers some interesting new features when it comes to handling recently used files and workbooks. Of the Quick access makes it possible to always have frequently used files in view so that they can be opened quickly. There are also practical setting options for the list of files last used.

First, you should get one for a reasonable number of recently used documents decide. This attitude is adopted Start> Options> Advanced> Display before. The default value is 20 documents. For a clear arrangement, however, the number should not greater than or equal to 10 .

2_Display setting

The List the documents are sorted chronologically, i.e. the most recently used file at the top and all older files below. It can often happen that an important file disappears completely from the list. To solve this problem, one uses that Fix of a document with a PIN on the list.

3_Document_fix

With a Left click on the PIN or about one right-click > An List fix, becomes the respective Documents permanently in this position fixed.

 

 

The then provides even more comfort Quick access, the one fixed Quantity from Documents brings it from the list to the left area of ​​the menu. These settings can be found under the list.

4_fast access1

The Result then looks like this with the first two documents from the list:

4_fast access2

 

 

read a comment

Transparency: This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de.

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.