3 added product name to question
| link

Fill value in multiple cells in Google Sheets

2 added 1 character in body; edited title
source | link

Google Spreadsheet fill Fill value in multiple cells

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 SpreadsheetSpreadsheets 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.

Google Spreadsheet fill value in multiple cells

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.

Fill value in multiple cells

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 Spreadsheets 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.

    Tweeted twitter.com/#!/StackWebApps/status/178670765519020033
1
source | link

Google Spreadsheet fill value in multiple cells

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.