"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:
The result is that the formulas, rather than their results, will appear in the worksheet.
Note: The keyboard shortcut for this tip: Ctrl + ~.
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:
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.
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.
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.
Recommended Books:Click on the image to view the details of the book.
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |