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.
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.
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.
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.
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.
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.
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.
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.