"Microsoft Excel Tips: Uncover 5 Tips to Improve Your Excel 2003 Skills"

Here are the 5 Microsoft Excel Tips to help you discover even more on the Excel program:

1.) How to Open Several Excel Windows at Once?

One of the most frustrating problems for Excel users is viewing all the information they need that lives in different worksheets. There is a simple way to view multiple sheets, and you'll love this tip forever.

  • Click on the tab of the worksheet you want to view.
  • From the Window menu, click New Window.
  • Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
  • To see them all at one time, choose Arrange from the Window menu.
  • From the Arrange Windows dialog box displayed, select Tiled, Horizontal, Vertical or Cascade.
  • Select the Windows of active workbook check box.
  • Click OK.

2.) Open Web Pages Using Excel?

If you need to analyze data found on a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel can save you a lot of time by letting you open an HTML page in Excel directly from the Web.

The procedure is just a slight modification of the standard file-opening steps:

  • From the File menu, choose Open.
  • From the Open dialog box displayed, in the File name: text box, type the full URL of the web site to open (including the prefix http://).
  • From the Files of type: drop-down list, select All Web Pages (*.htm; *.html; *.mht; *.mhtml).
  • Click the Open button.

Note: Excel opens HTML pages based on the HTML table structure of the page, so some Web design treatments may lead to some weird results in Excel. For pages that cleanly present data in a table format, however, this approach can be a real time-saver.

3.) Adding Your Own Lists to Save Your Time!

If you often make use of the same lists of data, you can create a custom list instead of typing the same information repeatedly.

If the data is already in a worksheet, follow these steps:

  • Select (highlight) all of the cells containing the data you want to create lists.
  • From the Tools menu, select Options.
  • From the Options dialog box displayed, click the Custom Lists tab.
  • Click Import.

To manually create a list from scratch, follow these steps:

  • From the Tools menu, select Options.
  • From the Options dialog box displayed, click the Custom Lists tab.
  • Type each item in the List entries: box, pressing Enter after each one.
  • When finish, click the Add button.
  • Click OK button.

4.) How to Create a Workspace in Excel?

Often, you will be working with several workbooks at a time. Do you know that you can arrange the workbooks, save them as a workspace, and then open everything at once in the viewing configuration that you prefer. Here's how:

  • With all the workbooks in the preferred positions, go to the File menu, click Save Workspace.
  • Type a name for the file and choose the location to save (if needed).
  • Click Save.

The next time you want to work with those workbooks, you can go to File menu and choose Open and select the workspace.

5.) Quickly Setting a Print Area - Save Time, Paper & Money

You probably waste a lot of time and paper sending entire worksheets to the printer when all they need is a printout of a few columns or rows. This quick trick can help you to set specific print areas within the Print Preview mode.

  • From the View menu, click Page Break Preview.
  • Select the cells you want to print.
  • Right-click on the selection and choose Set Print Area from the shortcut menu.
  • To print - Click the Print icon on the Standard toolbar.

These are the 5 essential Microsoft Excel tips that can save your time in learning and discovering the secrets behind the Excel 2003. If you want to learn more tricks, follow the links below:

Microsoft Excel Tips: 5 Secrets to Help You Work More Efficient on Excel 2003

Excel Tricks: Discover Even More Microsoft Excel 2003 Tips

Microsoft Excel Tricks: 6 Great Tips for You to Discover Some Excel 2003 Functionality

Can't find what you're looking for? Try Google Search!

Custom Search

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!

PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007

What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.