CNTL+SHIFT+ DOWN ARROW > Highlight all the cells in the column from current cell till the first empty cell
CNTL+SHIFT+ LEFT ARROW > Highlight all the cells in the row from current cell till the first empty cell
To use absolute referencing for any column in a formula, prefix the cell number of that column with a $ sign.
No comments:
Post a Comment