This simple function acts as a critical safety net for your workbooks.

In a Microsoft Excel spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate. These relationships are called references. When a ...

Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a reference, so it will not change when copying the ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

Sometimes you may have a lot of data in your document, and it can be difficult to read; luckily, Microsoft Excel has a feature called Group which you can use to organize your data into sections that ...

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function. Q. If I write A1:A10 in ...

Write Excel formulas that are easy to understand and don't consume lots of memory.

How to populate a dropdown with data from another sheet in Excel Your email has been sent If your list and dropdown are on different pages, you’ll need to know this ...

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I have an ...