You can make it easier to find the workbooks
you use most often by increasing the number
of files that Excel displays on its Recent list.
When you click the File tab and then click
Recent, Excel displays a list of the workbooks
that you have used most recently, and clicking
an item in the list opens that workbook. The
Recent list is therefore a quick way to open a
file, but only if the workbook you want appears
in that list.
To improve the chances that a workbook
appears in the Recent list, you can increase the
number of files that Excel displays. The default
is 22, but you can specify a number as high
as 50.
If you run your PC at a relatively low
resolution, such as 1024 x 768, Excel only has
space to display the first few recent documents,
and it adds a scroll bar to the list so you can
navigate the rest. However, having to scroll to
a recent document just slows you down, so
you can reduce the number of recent
documents to about 15, or whatever number
prevents the scroll bar from appearing.
Excel Menu
1. Click the File tab.
2 Click Options.
The Excel Options dialogbox appears.
1. Click Advanced.
2. Use the Show This Number of Recent Documents spin box tospecify the number of recent workbooks you want to display.
3. Click OK.The next time you click the File tab and then click Recent, you see the number of recent
workbooks that you specified.
More Options!
Excel 2010 gives you a few options for
manipulating the list of recent documents.
For example, if a workbook that you use
only rarely appears on the list, you should
remove it to make space for a file that you
use often. Right-click the workbook and
then click Remove From List. If you want
a particular workbook to always appear
on the list, click the pin icon to the right of
the file.
Did You Know?
If you are running Excel 2010 on
Windows 7, you can take advantage of
jump lists to open recent Excel
workbooks. Pin the Excel icon to the
taskbar as described in Chapter 1. You
can then right-click the icon to access
the recent workbooks. You can also pin
items to this list by clicking the pin icon
or by dragging and dropping a workbook
onto the Excel icon.
0 komentar:
Post a Comment