5

In Google Sheets you can hit Ctrl+Shift+V to paste without the formatting, but, is there a way to change it so that you can use Ctrl+V? Either by changing the Keystroke or forcing the rows or columns to only ever display unformated text?

(I know you can change the formatting later in a column, but, I am looking to force it to never take the formatting in the first place, with just Ctrl+V no [SHIFT])

1
  • The best possible method is, create Macro and assign the Hot key CTRL+V to it. But remember in Google sheet Ctrl+V is already been assigned to Paste, please refer this link, keyxl.com/aaad5ec/76/…
    – Rajesh S
    May 17, 2018 at 7:24

1 Answer 1

1

The built-in keyboard shortcuts cannot be customized or overridden in Google Sheets. The easiest solution is to bite the bullet and press ControlShiftV (on a Mac, use ShiftV.)

You can also try Windows and macOS features that let you press one key combination to send another key combination.

2
  • this answer does not work for me on firefox/windows
    – stackers
    Oct 30, 2023 at 17:07
  • The answer refers to the Edit > Paste special > Values only command that only works when pasting from a range to another within the same spreadsheet file. To paste values only from one spreadsheet file to another, use the web browser's Paste and match style command or similar. Oct 30, 2023 at 20:46

Your Answer

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

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