Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a hyperlink, you may wonder why the link doesn't act the same as the original hyperlink. Here's why.
Read this ExcelTip: Links to Hyperlinks
Microsoft Excel Tips -
Learn Excel Faster!
The heart of any formula you put together in Excel is worksheet functions. This tip introduces you to worksheet functions and what you can do with them.
Read this ExcelTip: Understanding Functions
Microsoft Excel Tips -
Learn Excel Faster!
Programmers know that a staple of any language is the ability to create conditional statements. Excel understands this, as well, so it provides the IF worksheet function that allows you to evaluate an expression and thereby conditionally choose a result.
Read this ExcelTip: Using the IF Worksheet Function
Microsoft Excel Tips -
Learn Excel Faster!
Spend a lot of time defining print areas in your workbooks? You might benefit by adding a Set Print Area tool that makes defining print areas a snap.
Read this ExcelTip: Adding the Set Print Area Tool
Microsoft Excel Tips -
Learn Excel Faster!
Excel, by default, displays numbers with a leading zero, if they are less than 1. Here's how you can get rid of those leading zeros if you don't want to see them.
Read this ExcelTip: Getting Rid of Leading Zeros in a Number Format
Microsoft Excel Tips -
Learn Excel Faster!
The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.
Read this ExcelTip: Copying Comments when Filtering
Microsoft Excel Tips -
Learn Excel Faster!
The MODE function is used to determine the most frequently recurring value in a range. This tip explains how to use the function in your worksheet.
Read this ExcelTip: Returning the MODE of a Range
Microsoft Excel Tips -
Learn Excel Faster!
Even if you do nothing but record macros, sooner or later you will have a need to edit what you record. Here's how to get to the place where you can make the macro changes directly.
Read this ExcelTip: Editing Macros
Microsoft Excel Tips -
Learn Excel Faster!
Excel allows you to edit the contents of a cell in two places—the cell itself or in the Formula bar. If you want to switch from one place to the other while you are editing, you'll need to rely on the mouse.
Read this ExcelTip: Switching Editing Location
Microsoft Excel Tips -
Learn Excel Faster!
Borders not printing properly? It could be any one of a number of reasons causing the problem. This tip provides some guidance on what you can do to correct the situation.
Read this ExcelTip: Out of Kilter Borders
Microsoft Excel Tips -
Learn Excel Faster!
With a long list of items in a worksheet, you may want to determine the last time a particular item appeared in the list. There are a couple of ways you can tackle this problem, as described in this tip.
Read this ExcelTip: Calculating the Interval between Occurrences
Microsoft Excel Tips -
Learn Excel Faster!
Combining workbooks that have cross-links to each other can offer some special challenges. This tip examines how you can get around those challenges.
Read this ExcelTip: Finding Wayward Links
Microsoft Excel Tips -
Learn Excel Faster!
Excel provides the ability to define names that refer to cells or ranges of cells. These can then be used in your formulas to make them more understandable. This tip provides a very "high level" view of what names are in the Excel environment.
Read this ExcelTip: Understanding Names
Microsoft Excel Tips -
Learn Excel Faster!
