Google-sheets – How to drag an active cell to the last column on Google Sheets

google sheetskeyboard shortcuts

When I say drag I mean using the small blue square in the bottom right corner.

Best Answer

  • hoover your mouse cursor over that blue square
  • left-click it and hold your click while moving mouse from current position to the right
  • release your left-click when needed

picture shows this for rows in column but its same for columns in one row:

enter image description here

shortcut / hotkey usage:

for a sole purpose to move that blue square there isnt any shortcut/hotkey. closest you can get is to use SELECT and FILL, however FILL will be performed only from active cell eg. not from active range of cells.

select leading cell and press:

  • SHIFT+➜+➜+➜... and then CTRL+ENTER
  • SHIFT+CTRL+➜ and then CTRL+ENTER
Related Topic