Timeline for Fill value in multiple cells in Google Sheets
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 1, 2022 at 7:10 | comment | added | JinSnow |
@phwd It seems to only duplicate the value of the first cell (the one on the top left): 1) enter the value "1" in the cell A2 2) click outside the cell to apply the edit (and quit the edit mode) 3)drag the cell A2 to A1 (its draws a selection containing A2+A2). 4) type ctrl+enter RESULT: it deletes the editing (A1 et A2 are empty)
|
|
| Jun 15, 2021 at 7:13 | comment | added | user5305519 |
Adding on to what @CristianLupascu has posted for Windows, on MacOS, key in your value, hit ENTER, then COMMAND + ENTER
|
|
| May 4, 2015 at 5:11 | comment | added | Michael Scheper | So glad to have finally found the solution to this. I wonder why Google put in that extra step—it ends up requiring at least two extra keystrokes and generally feels clunky. | |
| Jan 31, 2014 at 18:22 | comment | added | user58281 | 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 | |
| Jan 17, 2012 at 20:48 | vote | accept | Cristian Lupascu | ||
| Jan 17, 2012 at 20:48 | comment | added | Cristian Lupascu | 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. | |
| Jan 17, 2012 at 20:38 | history | answered | phwd | CC BY-SA 3.0 |