Templates allow you to define and collect many formatting settings that control how your documents appear. Getting a report of what settings are stored in a template is not an easy task, however.
Read this WordTip: Listing the Settings in a Template
Microsoft Word Tips -
Learn Word Faster!
Need to know if a worksheet or workbook is currently protected? Excel provides some tell-tale signs, but here are some ways you can know for sure.
Read this ExcelTip: Visually Showing a Protection Status
Microsoft Excel Tips -
Learn Excel Faster!
You can use a macro to print to any printer you have defined in Windows. It is good practice, if you are changing which printer you are printing to, to use the programming technique described in this tip to remember which printer was previously selected on the system.
Read this WordTip: Temporarily Changing the Printer in a Macro
Microsoft Word Tips -
Learn Word Faster!
When analyzing your numeric data, you may need to figure out the largest and smallest numbers in a set of values. If you don't want the smallest value to be a zero, then your analysis task becomes just a bit harder.
Read this ExcelTip: Deriving High and Low Non-Zero Values
Microsoft Excel Tips -
Learn Excel Faster!
Highlighting text, using the Highlight tool, is a great way to mark up a document. Normally you need to use the toolbar tools to add highlighting, but you can create your own shortcuts to add the highlighting you desire.
Read this WordTip: Highlighting Text Using the Keyboard Only
Microsoft Word Tips -
Learn Word Faster!
Want to change an existing bar chart to a different type of chart, such as a line chart or a column chart? It's easy to do when you follow the steps in this tip.
Read this ExcelTip: Changing Chart Types
Microsoft Excel Tips -
Learn Excel Faster!
Your macro may need to determine if the user has overtype mode turned on. You can find out the overtype status easily by using the Overtype property.
Read this WordTip: Determining if Overtype Mode is Active
Microsoft Word Tips -
Learn Word Faster!
Want to figure out how far it is between two points on the globe? If you know the points by latitude and longitude, you can calculate the distance using the techniques in this tip.
Read this ExcelTip: Calculating the Distance between Points
Microsoft Excel Tips -
Learn Excel Faster!
Got a bunch of AutoText entries defined for your system? You'll undoubtedly want to back them up at some time. Here's how to do it.
Read this WordTip: Backing Up Your AutoText Entries
Microsoft Word Tips -
Learn Word Faster!
Tired of hitting the F1 key by mistake and pulling up the Help system? Here's a couple of ways (one drastic and one not so drastic) that you can disable that pesky F1 key.
Read this ExcelTip: Disabling the F1 Key
Microsoft Excel Tips -
Learn Excel Faster!
When you create a chart in Microsoft Graph, you might now want to see one or both of the axes included by default. Here's how to turn them off and back on again.
Read this WordTip: Controlling the Display of Chart Axes in Microsoft Graph
Microsoft Word Tips -
Learn Word Faster!
When you use Find and Replace, Excel normally looks through all the cells in a worksheet. You may want to limit the search to a single column, however. Here's how you do it.
Read this ExcelTip: Limiting Searching to a Column
Microsoft Excel Tips -
Learn Excel Faster!
Word allows users to conveniently work with multiple documents at the same time. When writing macros, you may need to know how to switch which document is displayed. This tip presents a handy macro that switches which of two document windows is displayed on top.
Read this WordTip: Screen Flip Flop with VBA
Microsoft Word Tips -
Learn Word Faster!
If you have a range of cells in which you want to count all the commas, there are several ways you can derive the figure you need. This tip examines different methods to achieve the count, and you can easily adapt the methods to count other characters.
Read this ExcelTip: Counting Commas in a Selection
Microsoft Excel Tips -
Learn Excel Faster!
Need to get rid of the formatting applied to a bunch of text? One of the easiest ways to do this is to use Notepad in conjunction with Word.
Read this WordTip: Absolutely Getting Rid of Formatting
Microsoft Word Tips -
Learn Word Faster!
Excel limits the number of items that can be shown in an AutoFilter drop-down list. Granted, it is a high limit, but it is a limit nonetheless. This tip explains the limit and provides some ideas about how you can better use filtering to find the data you need.
Read this ExcelTip: Limits to Filtering
Microsoft Excel Tips -
Learn Excel Faster!
Don't want Word to load up your HTML documents as formatted text? There are a couple of ways you can instruct Word to be more discerning when it opens these types of documents.
Read this WordTip: Turning Off HTML Conversions
Microsoft Word Tips -
Learn Word Faster!
When the data on a worksheet occupies more than one printed page, Excel can easily determine where the first page of data is located, at the top-left of the worksheet. Beyond that, however, the program allows you to specify whether the next page is to the right or below this first page.
Read this ExcelTip: Specifying an Order for Page Printing
Microsoft Excel Tips -
Learn Excel Faster!
