Page numbers in Excel printouts are typically simple counters, without much chance for embellishment. If you want to add leading zeros to your page numbers, the best solution is to use a macro to do your printing.
Read this ExcelTip: Leading Zeros in Page Numbers
Microsoft Excel Tips -
Learn Excel Faster!
If you get an error when you try to use one of your custom views, it could be due to the protection you have applied to the worksheets. This tip explains why this may cause a problem and what you can do about it.
Read this ExcelTip: Problems with Custom Views
Microsoft Excel Tips -
Learn Excel Faster!
The two newest versions of Excel rely upon the Internet to grab help information. If you don't want Excel to seek help online, you can configure the program using the information in this tip.
Read this ExcelTip: Stopping Help from Using Online Resources
Microsoft Excel Tips -
Learn Excel Faster!
Got a bunch of worksheets and you want to save paper by printing multiple worksheets on a single piece of paper? There are several ways to approach the issue, and the one you choose will depend (to a degree) on the characteristics of the data you need to print.
Read this ExcelTip: Printing Multiple Worksheets on a Single Page
Microsoft Excel Tips -
Learn Excel Faster!
One of the important configuration files for Excel is known as the XLB file. You should periodically make backups of this file, in order to protect the customizations you've performed on Excel's toolbars.
Read this ExcelTip: Disappearing Toolbar Buttons for Macros
Microsoft Excel Tips -
Learn Excel Faster!
The process of combining string (text) values to make a new string is called concatenation. Excel provides the CONCATENATE function to accomplish the task, but there is an even easier way to join strings together.
Read this ExcelTip: Using the CONCATENATE Worksheet Function
Microsoft Excel Tips -
Learn Excel Faster!
If you ever try to edit a PivotTable and get an error that tells you that the "underlying data was not included," it can be frustrating. This tip looks at possible causes for this error and how you can solve the problem.
Read this ExcelTip: Editing PivotTables without Underlying Data
Microsoft Excel Tips -
Learn Excel Faster!
One way to make your worksheets less complex is to get rid of detail and keep only the summary of that detail. Here's how you can accomplish this task while still ensuring that your data isn't messed up.
Read this ExcelTip: Merging Cells to a Single Sum
Microsoft Excel Tips -
Learn Excel Faster!
Text boxes are easy to add to a document and manually resize, as needed. If you want to resize the text box in a macro, however, the way to do it effectively may seem elusive. This tip explains how you can resize a text box to cover a desired range of cells.
Read this ExcelTip: Resizing a Text Box in a Macro
Microsoft Excel Tips -
Learn Excel Faster!
Strings are used quite frequently in macros. You may want to swap the contents of two string variables, and you can do so by using the three-line technique introduced in this tip.
Read this ExcelTip: Swapping Two Strings
Microsoft Excel Tips -
Learn Excel Faster!
When you add multiple graphic objects in a worksheet, it can often be beneficial to group those objects together. Here's how to group and later ungroup those objects.
Read this ExcelTip: Grouping and Ungrouping Objects
Microsoft Excel Tips -
Learn Excel Faster!
Want the title of your chart to change based upon what is placed in a worksheet cell? It's easy; just add a formula to control the title.
Read this ExcelTip: Using Dynamic Chart Titles
Microsoft Excel Tips -
Learn Excel Faster!
