Excel allows you to easily add hyperlinks to a worksheet. Click on it, and the target of the link is opened in a browser window. If you want to specify which browser is used to display the link, things get more complex.
Finding and replacing information in a worksheet is easy. Finding and replacing in other objects (such as text boxes or chart labels) is a different story entirely. This tip examines ways you can find and replace information in these other items.
Context menus can be very helpful for presenting common operations you can perform, based on the context in which the menu is displayed. Here's how you can add your own items to the Context menus used by Excel.
Conditional formatting is a great feature for making the data in your worksheets more understandable and usable. What if you need to define a conditional format that has more than three conditions? Here are a few ideas.
Don't like the toolbar button images in your version of Excel? Don't fret; you can pull up the button editor and make changes pixel by pixel, if desired. (It's easier to do than you think, although you artistic talents may be tested in the process.)
Using a formula to find information in a text value is easy. Using a formula to find either of two text values within a larger text value is a bit harder. This tip examines different formulas you can use to figure out how many cells in a range contain either of two text values.
If your workbook contains links, you are normally given the opportunity to update those links when you open the workbook. When opening the workbook from within a macro, you probably don't want Excel to ask about updating the links. Here's how to stop Excel's normally inquisitive nature.
Read this ExcelTip: Updating Automatically When Opening Under Macro Control
Microsoft Excel Tips - Learn Excel Faster!
Cells in a worksheet defined by the intersection of rows and columns. If you adjust row height and column width just right, you can form your cells into perfect squares. The technique in this tips makes it easy to accomplish.
The Personal workbook is a special place used to store information and macros that you can access from all the other workbooks on which you work. If you are confused as to why Excel continually asks whether you want to save this special workbook, here are some ideas on why it may be happening.
Want your copy of Excel to reflect the way you want to work with the interface? Fortunately, you can modify where various menu options appear. This can help you ensure that Excel is more suited to the way you work.