In MS Excel, I can type the following formula


Without taking my hands off the keyboard. I start in cell B1, I type =SUM( then I use the cursor keys to move one cell to the left, hit CTRL-SPACE (which turns the A1 into A:A) then type )

Is there any way to get google spreadsheets to do the same thing? The CTRL-SPACE shortcut works for selecting cells, but not within a formula. Is there some other way to do what I'm after?

I can use CTRL-SHIFT-DOWN but the end result is a reference to the range A1:A1000 - so if I subsequently add another 1000 rows to the spreadsheet, my formula doesn't extend.

Please help, my muscle memory is working against me right now... and the mouse is so far away!

Edit: Apologies, browser is chrome (but I'll use anything if I can get this to work). OS is Windows 10

  • @K7AAY - edited above, apologies
    – Jon
    Commented Nov 15, 2018 at 2:08
  • Always AOK; your question.
    – K7AAY
    Commented Nov 15, 2018 at 19:15

1 Answer 1


I consulted the Google Sheets Help Forum, and the expert advice from there confirms that feature does not exist yet. Instead, they suggested

"If you'd like to influence future versions of Google Sheets, Feature Requests are encouraged. You can submit your idea using the HELP > Report a Problem menu. I know that those submissions are valued by the Sheets team."

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.