Want to easily see the location of named ranges in your worksheet? It's easy; all you need to do is use the familiar Zoom tool in a way you've never thought of before.
Read this ExcelTip: Where Is that Name?
Microsoft Excel Tips -
Learn Excel Faster!
You could use Excel to collect data that is useful in your business. For instance, you might use it to collect information showing which people have reserved various weeks of your facilities. This tip explains a few ways you can find the names associated with a range of reservation weeks.
Read this ExcelTip: Determining a Name for a Week Number
Microsoft Excel Tips -
Learn Excel Faster!
People often place macros in template files to perform any number of tasks. This tip describes a situation where the link between a toolbar button and a macro was broken when a new document was created from a template. The problem was corrected by double-checking where the toolbar button pointed when referencing the macro.
Read this ExcelTip: Macros in Template Files
Microsoft Excel Tips -
Learn Excel Faster!
If you want to reference cell colors external to your current workbook, there is no way to do it using Excel functions. You can, however, create your own macro that will do the referencing for you.
Read this ExcelTip: Referencing External Cell Colors
Microsoft Excel Tips -
Learn Excel Faster!
Does it bother you when you enter a URL and it becomes "active" as soon as you press Enter? Here's how you can turn off this activation so that your URLs remain as regular text.
Read this ExcelTip: Turning Off Hyperlink Activation
Microsoft Excel Tips -
Learn Excel Faster!
When you import information originating in a different program, Excel may not do the best job at figuring out what various pieces of that information are used for. Here's a couple of ways to quickly convert imported textual values into the numeric values they should have been all along.
Read this ExcelTip: Converting Text to Values
Microsoft Excel Tips -
Learn Excel Faster!
Excel allows you to change the names assigned to the worksheets in a workbook. If you want to have those names appear in a cell on the worksheet, there are a couple of ways you can approach the problem. Here's an assortment of techniques.
Read this ExcelTip: Getting the Name of the Worksheet Into a Cell
Microsoft Excel Tips -
Learn Excel Faster!
If you need to find out how many columns are set to be a specific width, you'll need a macro to help determine the info. Here's a couple that will help.
Read this ExcelTip: Finding Columns of a Certain Width
Microsoft Excel Tips -
Learn Excel Faster!
You can use the IF worksheet function to test for a number of different conditions or values. You can't use it to check for cell colors, however. Here are some ideas on how you can take cell colors into account in the IF function.
Read this ExcelTip: Colors in an IF Function
Microsoft Excel Tips -
Learn Excel Faster!
If you share a workbook with others in your office, you will probably want to make sure that some of the worksheets don't get deleted. Here are some ideas on how to get the protection you need.
Read this ExcelTip: Protecting Worksheets from Deletion
Microsoft Excel Tips -
Learn Excel Faster!
When writing a macro, you may want to fill a range of cells with different values. The easiest way to do this is to use arrays to fill the cells, as described in this tip.
Read this ExcelTip: Filling a Range of Cells with Values
Microsoft Excel Tips -
Learn Excel Faster!
Would you like to have a worksheet automatically printed when a particular cell contains a specified value? You can achieve this nifty task by using a macro to handle the printing.
Read this ExcelTip: Printing Based on Cell Contents
Microsoft Excel Tips -
Learn Excel Faster!
Adding a predefined footer to your worksheets is easy, and it helps convey valuable information when you make a printout. Excel even allows you to create your own custom footers.
Read this ExcelTip: Creating a Footer
Microsoft Excel Tips -
Learn Excel Faster!
