Please Note: This article is written for users of the following Microsoft Excel versions: 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Specifying Your Target Monitor.

Specifying Your Target Monitor

by Allen Wyatt
(last updated August 5, 2017)

If you are developing Web pages in Excel, it is a good idea to have in mind who the user is. The user, obviously, is the person who will view your Web page. However, there are certain assumptions that must be made about the user, and those assumptions will affect how you put your Web page together.

One of the prime considerations is what resolution of monitor the user will be using. This affects the presentation of graphics and text on their page. For instance, a graphic that shows up nicely centered on your screen at a high resolution may not give the desired impact if the user is working at a lower resolution.

You can instruct Excel to make certain assumptions about the user's monitor resolution as you are developing Web pages. You set the target resolution by following these steps:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the General tab is selected. (See Figure 1.)
  3. Figure 1. The General tab of the Options dialog box.

  4. Click on the Web Options button. Excel displays the Web Options dialog box.
  5. Make sure the Pictures tab is selected. (See Figure 2.)
  6. Figure 2. The Pictures tab of the Web Options dialog box.

  7. Using the Screen Size drop-down list, select the screen resolution you believe most of your users will have.
  8. Click on OK to close the Web Options dialog box.
  9. Click on OK to close the Options dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3409) applies to Microsoft Excel 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Specifying Your Target Monitor.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Ensuring Standard Units During Data Entry

Need to make sure that information entered in a worksheet is always in a given unit of measurement? It's not as easy of a ...

Discover More

Copying Character Formatting

If you are applying character formatting directly to text rather than using a character style you can copy it from one place ...

Discover More

Comments Don't Appear when Cell is Pointed To

One way that you can view comments in a worksheet is to have them appear when you hover the mouse pointer over a cell. If ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

More ExcelTips (menu)

Linking to a Specific Page in a PDF File

The HYPERLINK function is great for linking to Web pages and some other resources, but it won't allow you to access a target ...

Discover More

References to Hyperlinks aren't Hyperlinks

Make a reference to a hyperlink in a formula, and you may be surprised that the reference doesn't return an active hyperlink. ...

Discover More

Setting Web Fonts

Is your worksheet information destined for a Web page? Here's how you can specify the fonts that should be used when Excel ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 2?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.