A simple scroll up or left will return you to where you wereto the active cell--in a small spreadsheet.

Of course, you probably remember the general direction of the active cell, but depending on just how far youve wandered, scrolling back to the active cell is probably the least efficient way to get there.

Most likely, you wont remember the cell reference, but thats Okay because theres a keyboard shortcut for returning to the active cellfrom anywhere in the same sheet.

After losing sight of the active cell, just press CtrlBackspace and Excel will return you to the active cell.

Be sure to scroll to the right or down until the active cell is no longer on your screen.

Previously, she was editor in chief for The Cobb Group, the worlds largest publisher of technical journals.

Conversely, the cell containing the formula is a dependent because it needs the cell containing the data to complete its function.

Ive written before about the ability to trace precedents and dependents, But I recently learned two keyboard shortcuts that take you to your current cells precedents or dependents.

Ctrl will move your cursor to the dependent(s) of the current cell, that is, the cell or cells with a formula that uses the current cell.

Excel For Mac Shortcuts Cell Reference