As discussed in a previous tip, adding a drop down list to your worksheet allows the users of the worksheet to enter information in a neat, consistent format. The example in the previous tip emphasized the importance of having consistent information when summarizing information in a PivotTable. Another use is to store lists of information, which could be anything, but in … [Read more...]
Return Worksheet Name in a Cell
Often times it's useful to be able to display your worksheet's name in a cell in the worksheet. This could be tedious if you have a file with a lot of sheets, whose names could change frequently. Luckily there are a couple ways around this problem. If you want to display this information in a cell in your file, enter the following formula in the cell where you want the name … [Read more...]
Remove Personal Information From Excel 2007
Sometimes, it's useful to be able to remove personal information from your workbook, in the event that you're sending the file to someone else, whether it's someone from another company, posting it to a forum, or sending it via email. Excel will, by default, save information such as the author, file title, comments, etc. This information, could be potentially damaging if it … [Read more...]
Adding Comments to Formulas
Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself. It's also useful to be able to add comments to a formula, so that you can let other users of your workbook know if you've made a change to the formula, let them know what the result of the formula represents, or share other information about the … [Read more...]
Using a For Loop
"For" loop is used in a macro whenever you have an action that needs to be performed a set number of times. For example, if you want to change the fill color of the first 20 cells in a list, you could have the macro select the range and simply fill as desired. But what if you wanted to only fill the cells if they were blank, for example? Telling the macro to select the whole … [Read more...]