29 articles Excel 2003 Page 3 / 3

There are 2 “clean” methods to solve this problem without moving the cells: Excel’s filter function allows the user to filter out rows that are duplicates. Countif to detect any duplicates for deletion Solution 1: Click on the Data -> Advanced button Select “Filter the list, in-place” For “List Range”, select the data to be…

To delete empty easily: In the right most column, put in the formula =counta([highlight everything left of the cell]) Counta counts the # of cells that is not empty. So, if the entire row is empty, it will return 0. Drag and copy the formula down until the end of the area where you want…

In Excel 2003, sometimes Excel shows a large amount of blank rows and empty columns that was previously deleted, and somehow the scrollbar thinks there’s still data when there isn’t any. Some users find this annoying, but sometimes it affects usability especially when the scrollbar gets too thin due to the excessive amount of rows /…

What happens if you unintentionally delete a tab in Excel? There is no “undo” for recovering a deleted tab. The general solution is to get the last saved version of the file to recover the tab. This works for anything that you cannot “undo” in Excel. For example, actions from a VBA script. If your…

=sumproduct([values],[weights])/sum([weights]) A weighted average (mean) is similar to the arithmetic average (mean), except values to be average are given different weight or emphasis. As seen in the example below, the weighted average is much lower than the arithmetic average, because there the value 0 carries a very strong weight (50). The formula bar also shows how cells should be…

Sometimes when we copy cells, we want to make an exact duplicate. This tutorial teaches you exactly how to do that. Typically, when a cell is copied, references in the formula in the new cells shifts relative to their location to the original cell unless the cell reference is locked. A simple example below: C2…