Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work.

Each cell in a worksheet has a unique reference that describes its position – for example A1. In a spreadsheet, there are two types of cell reference – 'relative cell reference' and 'absolute ...

I'm creating a utility in Excel that takes mesh bad leveling raw data (49 values, 7x7 grid, with the center value being what all other values are being compared to). Some values are positive, some ...

One of the best features in Excel is the ability to plug in a formula and then easily drag it into new cells and have it automatically shift to the corresponding cell values. But sometimes this ...

Excel 2007 line charts: graphing the absolute value of a range of cells hanser Jul 17, 2008 Jump to latest Follow Reply ...