If you ever had a spreadsheet and needed to change formulas or graphs each time a row of data was added you want to know this trick.
It is important to understand how Named Ranges work in order to understand the inner workings of dynamic ranges.
For a dynamic range just substitute a formula ...more»
Excel 2010 gives a lot more rows and columns to work with than Excel 2003. Below we explain the difference in a table:
When you open an Excel 2003 workbook in Excel 2010 it is opened in Compatibility mode. When you are in Compatibility mode, you cannot access any rows beyond 65,536 ...more»
When you have to enter a large amount of data, it is possible to check the accuracy of what you entered by having Excel read the data back. You can keep your eyes on the printed list and match what you typed previously.
You can choose how Excel reads back the ...more»
Sometimes you create a spreadsheet that has cells for a user to fill in. You want to delete the values in those input cells and keep the formulas that perform operations on those input cells as they are. Here's how with an example.
Suppose we have the sheet as in the ...more»
Below we will cover the new features we like best in Excel 2013.
What you'll notice immediately is the new look. The interface looks less cluttered and the borders around sheets and menus are mostly just lines now.
Special attention has been given in this new version to ways of showing your ...more»
Sometimes when you copy-paste data from other applications the numbers are considered to be text in Excel. You can tell if Excel is considering a cell as text looking at the alignment within the cell. If a number is left aligned Excel probably treats the content as text. By default, numbers ...more»
For each formula you create in Excel, you have the choice to reference cells either relative or absolute. The difference is this:
relative: the cell reference(s) in the formula is changed accordingly if the formula is copied and pasted
absolute: the cell reference(s) in the formula do not change when the formula ...more»
By pressing Ctrl+C, clicking the Copy button on the Home tab, or clicking Copy on a right mouse menu, the contents of a range of cells is easily copied so the contents can be pasted somewhere else in the worksheet. Because cells can contain a lot of information, you can decide ...more»