You know how Excel does smart pasting, which will automatically increment rows as you paste? Well what if you wanted something to stay static. You can prevent the incremental behavior by prefixing the column and row with a dollar sign. The cell N12 become $N$12.
Neat!
No comments:
Post a Comment