When you use Excel to input and store information, you need to be concerned with whether the information meets your expectations. For instance, you may want to make sure that each row has a value in only one of two columns, and not in both columns. This tip examines ways you can find where the data doesn't meet this expectation.
You can configure images in Excel so that if someone clicks on them, a macro is executed. You cannot, however, have a macro and a traditional ScreenTip tied to the same object. This tip explains how you can get around this limitation using two separate techniques.
Excel allows you to protect worksheets, individually. Users can still see that the worksheets are there, but they cannot display them if they don't know the proper password. If you are developing a full-blown application in Excel, you may need a way to completely hide worksheets from users unless they enter their password. This tip explains the steps necessary to implement such a scenario.
When you display the Find tab of the Find and Replace dialog box, you'll notice that any search, by default, will be on the current worksheet. If you want Excel to default to searching the entire workbook, you'll need to resort to a macro to accomplish the task.
Normally you use the RAND and RANDBETWEEN functions to generate random numbers. What if you want to generate random numbers within a certain range but exclude some numbers in that range? Here's some ideas on how to get what you want.
If you have a large, complex workbook, you may want to make sure that it is always calculated manually instead of automatically. You can do that by including just a couple of small macros in the workbook.
If you have a data table in a worksheet, and you want to shade various rows based on whatever is in the first column, then you can use Excel's conditional formatting capabilities. There are a couple of ways you can choose to do so, however.
When working with financial data, it's easy to round values to the nearest dollar. What if you want them rounded to the nearest half dollar, however? There are a couple of ways you can determine the rounded value.