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

Here are the 5 Excel 2003 Tips with step-by-step instructions:

1.) Secret to Allow You Print the Excel Formulas!

If you have invested time in writing numerous useful formulas, you may want to print them for future references.

Here are the steps to print the formulas:

• From the Tools menu, click Options.
• From the Options dialog box displayed, click the View tab, and under the Window options section, check Formulas.
• Click OK.

The result is that the formulas, rather than their results, will appear in the worksheet.

Note: The keyboard shortcut for this tip: Ctrl + ~.

2.) Shifting a Scatter Chart's Axis

In most cases, Excel's default behavior of making the x-axis and y-axis of scatter charts intersect at 0 is desirable. But sometimes, you may want to change that intersection point. An obvious example is when a user needs to highlight just a selected number of years of data but doesn't want to create an entirely new chart.

To reset an axis, follow these steps:

• Activate the chart for editing.
• Click to select the axis you want to modify by clicking on the chart axis.
• From the Format menu, choose Selected Axis.
• From the Format Axis dialog box displayed, click the Scale tab.
• Type a number in the Value (X or Y) axis Crosses at: text box.
• Click OK.

3.) The Faster Way to Access Any Worksheets

When working with large workbooks in which all of the worksheet tabs are not visible, you may get frustrated with scrolling to find the sheet you need. Here's a really quick tip to pass on.

• Right-click on any of the tab-scrolling buttons (to the left of the sheet tabs) and select the tab you want by clicking on the name.

4.) Shortcut to Move & Copy Toolbar Buttons

Here's a quick tip to modify the Excel toolbars.

Instead of right-clicking a toolbar and selecting Customize to launch the Customize dialog box, they can simply press the Alt key and click and drag an icon to any toolbar they want. Of course, both the source and target toolbars must be visible for this procedure to be effective.

Warning: This technique moves icons, so they will no longer be on the default toolbar. If users want to copy an icon to a new toolbar while retaining its position on the original one, they can hold down Ctrl + Alt while clicking and dragging the icon.

5.) Opening an Excel Workbook at Startup Automatically!

If you spend much of your day working in a specific workbook, you can designate a workbook to open each time Excel launches. All they need to do is place the workbook (or a shortcut to the workbook) in the XLSTART folder. This technique also works with network shortcuts.

Copy the workbook (or shortcut) to the following location: C:\Program Files\Microsoft Office\OFFICE11\XLSTART. After placing the file, you can just restart Excel to see the file pop open automatically.

With these new techniques that you learned, I hope that you can really apply it on your daily related tasks to increase your productivity. For more tips, click the links below:

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

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

Excel Tricks: Discover Even More Microsoft Excel 2003 Tips

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

Custom Search

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb