OGGalaxyGirl: I prefer to group my columns and rows. Apparently the hotkey for that is shift + alt + right arrow, if anyone is interested.
.
Bashhar: To jump to a referenced cell in a formula, press Ctrl + [
.
wattalameusername: When you are editing a cell, f4 will toggle between all the different types of a constant reference absolute reference. I honestly use it more than any other shortcut.
.
DoodleVnTaintschtain: He means an absolute reference, not a constant. So instead of, e.g., “A1”, hitting F4 would change the reference to either “$A$1” (no matter where you copy the formula, that term will always reference cell A1), or “$A1” (no matter where you copy the formula, it’ll always reference column A - the row will change if you copy it up or down relative to where you originally wrote it, but left and right won’t change the column), or “A$1” (same as before, but here the row is locked, the column is free to change).
Let’s say you’ve got a bunch of numbers that you want to multiply by a percentage. Put the percentage in, say cell A1, and the numbers to multiply in column B. So the formula would be “=A1*B1”. What happens when you copy that down to multiply B2 by A1? Formula would become “=A2*B2”… But that wouldn’t be right, since your percentage is in A1. If, instead, you hit “F4” when editing the “A1” in the original formula, it’d change to “$A$1” - an absolute reference to where the percentage is. Copy the formula wherever you want, and it’ll always reference the percentage. That way, you can change one cell and update all of the calcs.
Edit: forgot the slashes, so the “*” made everything italicized and made the (simple) formulas make no sense.
** Note: Cross post from an old reddit thread since posts/comments are getting deleted. Had to post from calckey to upload the vid.
.
.
constant referenceabsolute reference. I honestly use it more than any other shortcut..
DoodleVnTaintschtain: He means an absolute reference, not a constant. So instead of, e.g., “A1”, hitting F4 would change the reference to either “$A$1” (no matter where you copy the formula, that term will always reference cell A1), or “$A1” (no matter where you copy the formula, it’ll always reference column A - the row will change if you copy it up or down relative to where you originally wrote it, but left and right won’t change the column), or “A$1” (same as before, but here the row is locked, the column is free to change).
Let’s say you’ve got a bunch of numbers that you want to multiply by a percentage. Put the percentage in, say cell A1, and the numbers to multiply in column B. So the formula would be “=A1*B1”. What happens when you copy that down to multiply B2 by A1? Formula would become “=A2*B2”… But that wouldn’t be right, since your percentage is in A1. If, instead, you hit “F4” when editing the “A1” in the original formula, it’d change to “$A$1” - an absolute reference to where the percentage is. Copy the formula wherever you want, and it’ll always reference the percentage. That way, you can change one cell and update all of the calcs.
Edit: forgot the slashes, so the “*” made everything italicized and made the (simple) formulas make no sense.
** Note: Cross post from an old reddit thread since posts/comments are getting deleted. Had to post from calckey to upload the vid.