You can add any number of styles to your document in order to define how you want your text to appear. If you later want to get a list of those custom styles (particularly the ones in use), that can be tricky unless you use a macro. This tip looks at how you can access the desired info in VBA.
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.
The main body of your text is only one part of what makes up the entire document. Documents can consist of other elements, as well, such as headers, footers, text boxes, footnotes, etc. How can you create a macro that will move the insertion point to the beginning or end of the main body of your text, regardless of where the insertion point is currently located? It's easier than you think.
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.
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.
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.
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.