Showing posts with label Google Sheets. Show all posts
Showing posts with label Google Sheets. Show all posts

Tuesday, March 24, 2015

gSheets: Absolute and Relative references Toggle (F4)


Changing formula's from relative to absolute addressing by add the $(dollar)sign can be a painful task if you do it manually. Using the Smart toggle feature within gSheets can offer you some relief. (F4)

Example: 

[=D4*C4]

Place cursor near D4 in the formule [=|D4*C4] and hit F4
Repeatedly hitting the F4 key will show you in sequence the following options.

[=D4*C4] , [=$D$4*C4] , [=D$4*C4] , [=$D4*C4] , [=D4*C4].....

The same will happen if you position the cursor near C4



Moving around and selecting cells in Google Sheets


Moving around in Google Sheets:


CTRL+HOME {Moves the cursor to the first cell in the worksheet (upper left corner)}

CTRL + END {Moves the cursor to the right lower corner of the worksheet}

CTRL + ⇨ {Moves the cursor to the most right cell containing data within an active range}

CTRL + ⇦ {Moves the cursor to the most left cell containing data within an active range}

CTRL + ⇧ {Moves the cursor to the first row within an active range containing data}

CTRL + ⇩ {Moves the cursor to the last row within an active range containing data}



Selecting cells in Google Sheets:


Basically the same movements as above but with addition of the Shift key, the cell within the cursor displacements are selected.

CTRL + SHIFT + ⇨ {Select all cells from start point to the most right column of the active range, additional strokes will select to next block of data or most right cell of the worksheet}

CTRL + SHIFT + ⇦ { If already selected, the reverse of prior action, If nothing selected and positioned right of the most left column, all cells between current cell and most left column will be selected}

CTRL + SHIFT +  {Select all the rows down up to the last row of an active range, additional stroke(s) select to the bottom of the worksheet, or next range of data if available}

CTRL + SHIFT + ⇧{If already rows selected in an active range, it will deselect prior selection and possibly select previous unselected rows above the first selection all the way to the top row of the active range; if nothing was selected yet, it will select all the rows above the current position in an active range, additional strokes will select to the top of the worksheet or last row of any ranges above the current one}