Microsoft Office Tutorials and References
In Depth Information
Controlling Image Sizes
Controlling Image Sizes
An Image Size & Quality section appears in the Advanced category. Most
people add a photo to dress up the cover page of a document. However, you
probably don t need an 8-megapixel image being saved in the workbook. By de-
fault, Excel compresses the image before saving the file. You can control the
target output size using the drop-down in Excel options. Choices include 96
ppi, 150 ppi, and 220 ppi. The 96 ppi setting will look fine on your display. Use
220 ppi for images you will print. If you want to keep your images at the ori-
ginal size, you can select the new Do Not Compress Images in File setting.
You should also understand the Discard Editing Data check box. Say that
you insert an image in your workbook and then crop out part of the photo-
graph. If you do not enable Discard Editing Data, someone else can come along
and uncrop your photo. This can be an embarrassing situation just ask
the former TechTV co-host who discovered certain bits of photographs were
still hanging around after she cropped them out.
Working with Protected View for Files Originating from the Internet
Starting in Excel 2010, files from the Internet or Outlook initially open in
protected mode. This mode gives you a chance to look at the workbook and for-
mulas without having anything malicious happen. Unfortunately, you cannot
actually view the macro code while the workbook is in protected view (see
Figure 4.7 ) .
Figure 4.7.
Figure 4.7. Protected view enables you to see your document before any
Protected view enables you to see your document before any
warnings appear.
warnings appear.
If you only want to view or print the workbook, protected mode works great.
One statistic says that 40% of the time, people simply open a document and
never make changes to it.
After you click Enable Editing, Excel will skip protected mode the next time
you open the file.
Working with Trusted Document Settings
Working with Trusted Document Settings
By default, Excel warns you about all sorts of things. If you open a work-
book with macros, links, external data connections, or even the new
Search JabSto ::




Custom Search