Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

In MS Excel, after selecting a range of cells it is possible to enter a value and press CTRL+ENTER to have that value set in all selected cells.

Is there a keystroke in Google Spreadsheet that would achieve the same result?

Note: I know about the drag the cell's corner feature; I'm interested in doing this using only the keyboard.

Right now the closest to this I've got is:

  • enter value in one cell
  • CTRL+C;
  • select range of cells;
  • CTRL+V.

but I'd be a lot happier if it's possible to do this in fewer steps.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

This should be possible see: Keyboard shortcuts for Google spreadsheets.

Are you using a Mac?

The workflow is as follows

  1. Enter the value in one of the cells
  2. Select your range with your cursor by grabbing from the first cell and dragging (no need to hold the blue cross in the corner, but the range should be highlighted when you are finished)
  3. Type CTRL+Enter (windows) CMD+Enter (Mac)

This fills the selected range with the value.

The only other option would be to use Array formulas

When you press Ctrl+Shift+Enter while editing a formula, you'll automatically get =ArrayFormula( added to your formula.

Consider saving the official shortcuts for Google Spreadsheet as a bookmark on your browser.

share|improve this answer
    
Thanks for the answer! I finally realized why it wasn't working: I tried CTRL+ENTER while I was in edit mode in a cell (in Excel it works that way). In GDocs, after entering the value the cell must first be saved and then the keystroke works. –  w0lf Jan 17 '12 at 20:48
    
Oh man, this is a tremendous time saver. it recognizes the pattern you are trying to replicate for an entire column e.g. I am tracking NFL average scores in column B. Column E has total points scored, column D has games played. In cell B2 I can enter "=Divide(E2,D2)" then highlight all cells from B2 to B33 (32 NFL Teams) Hold ctrl and enter. Voilà, the pattern is applied to all the cells for each team –  RD248 Jan 31 at 18:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.