To fix a cell in a formula, click on the cell (you want to fix) in the formula bar, and hit the F4 key.
- Hit the F4 key once to fix the cell (dragging a formula down or across will keep the row and column of the reference cell constant)
- Hit the F4 key twice to fix the row (dragging a formula down will keep the row of the reference cell constant)
- Hit the F4 key three times to fix the column (dragging a formula across will keep the column of the reference cell constant)
If you want to create a macro to perform certain actions, and you are unsure of the syntax/code to use, the best way to get the code is to record a macro, manually perform the task, and check what code is produced once you stop recording.
