Microsoft Office Tutorials and References
In Depth Information
To keep a
spreadsheet around on the
list, click the
thumbtack on the right.
Excel moves your
workbook to the top
of the list and pins it
in place. That means
it won’t ever leave the
list, no matter how
many documents you
open. If you decide
to stop working with
it later on, just click
the thumbtack again
to release it. Pinning
is a great trick for
keeping your most
important files at
Just to the right of the Recent Documents list is the Recent Places list. It keeps track
of the folders where you store your Excel files. So if you like to place Excel
spreadsheets on your desktop and in your documents folder, you’ll see both folders in the
list (as in in Figure 14-25). When you click a location, Excel heads to the appropriate
location and shows the standard Open dialog box.
If you store your work in several different locations, far and wide, this feature can
save you from digging through the directory tree. It’s particularly handy if you store
documents on different drives or on a network. And just like the Recent Documents
list, you can pin folders to the Recent Places list.
Even something that seems as innocent as an Excel file can’t always be trusted.
Protected view is a new security feature in Excel 2010. It opens potentially risky Excel
files in a specially limited Excel window. You’ll know that you’re in protected view
because Excel doesn’t allow you to edit any of the data in the workbook, and it
displays a message bar at the top of the window (Figure 14-26).
Excel automatically uses protected view when you download a spreadsheet from the
Web or open it from your email inbox. This is actually a huge convenience, because