Inside Microsoft Excel

Calculate data in rows and columns without displaying a bunch of excess information

Inside Microsoft Excel

by Julie Duncan

Obviously, we all go to great lengths to ferret out incorrect data in our worksheets, but often we forget how much of a problem unnecessary information can cause. It may keep your boss from getting the point of all your data, which can land you in hot water. When you need to use row- and column-based data in a calculation, you can always use the TRANSPOSE feature to switch the column-based data[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)