In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of formula and I cannot find an equivalent shortcut to copy the value from the cell above. Any ideas please?
Google Sheets Keyboard Shortcuts – Equivalent of Ctrl+Apostrophe
google sheetskeyboard shortcuts
Related Topic
- Google Sheets Formula for ‘If Contains’ – Guide
- Formatting DIVIDE Results as Unsimplified Fractions in Google Sheets
- Google Sheets – Highlight Specific Cell ID
- Google-sheets – Copy Date Value and Paste as actual Date not number
- Google Sheets – Keyboard Shortcut to Select Whole Column During Formula Entry
Best Answer
Something that comes close is "Fill Down" (Ctrl+D).
If you highlight the cell with the formula you want as well as the cell below it, then use this shortcut, it'll be just like you used the fill handle, without having to do all that mousing.
In fact, this may be more useful, because you could just put the formula on the first row, add all the rest of your data, then do the fill-down at the end.
Not as convenient as Ctrl+', but I've found it pretty useful lately.