Drop down lists can greatly facilitate data entry. Here’s a look at how to use Microsoft Excel’s data validation feature to create handy lists within your worksheets.
Two ways to add checkbox controls to a Word document
Learn how to use a customized bulleted list or a content control to insert checkboxes into a Microsoft Word document, depending on how you are going to use it.
How to add color or a picture to a Word document’s background
There’s nothing wrong with a white background, but Microsoft Word lets you change the color of a document’s background. You can even use a picture, but don’t get carried away.
How to password protect an Excel workbook
At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.
How to accommodate different headers and footers in a Word document
To change a document’s header or footer in a Microsoft Word document, you should add a section break first. Follow these step-by-step instructions.
Copy an Excel sheet from one workbook to another
Susan Harkins shows you two quick ways to copy data from one Excel workbook to another.
Entering leading zeroes in Excel
By default, Microsoft Excel won’t display or store leading zeros. Read this Excel tip to learn three handy ways to get around the problem.
A quick way to delete blank rows in Excel
Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.
Three running total expressions for Excel
Adding a running total to a data set is easy, and you decide how to implement it.
How to use VBA to select an Excel range
VBA makes it easy to select an Excel range. Here are two macros that offer maximum efficiency and flexibility.