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.

I want a working keyboard shortcut for Google Spreadsheets, that lets me paste just the formatting. Google says the shortcut for copying just the formatting is Cmd+Alt+C, and pasting just the formatting is Cmd+Alt+V.

However, Cmd+Alt+C opens up the Chrome Dev Tools panel. And, perhaps because of this, Cmd+Alt+V doesn't do anything. I don't actually think the "copy just format" is necessary -- you only need the special paste functionality. But using the standard Cmd+C to copy a cell and then trying Cmd+Alt+V doesn't do anything.

The "Paint Format" button also does what I want, but there is no keyboard shortcut for that.

I would be happy to create a custom Chrome extension to achieve this, but my initial attempt (simply trigger a click event on the corresponding menu item element) didn't work -- not for paste format nor paint format.

Looking for any kind of solution that ultimately lets me use a keyboard shortcut to paste cell formatting.

share|improve this question

2 Answers 2

I mapped it to alt+Z here. You can change it withing the AHK script below. I have set the shortcut to specifically work on Chrome so it won't interfere with any other programs.

Use the following autohotkey script:

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
;SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.
;keyWait waits for a user to physically release a key, so don't use
#NoTrayIcon
#Persistent
#SingleInstance Force


#IfWinActive ahk_class Chrome_WidgetWin_1
!z::     ; ALT+Z
Send, {alt down}e
sleep, 50
send, s
Sleep, 50
send, t
send, {alt up}
share|improve this answer

Copying with Ctrl+c and pasting with alt+e then s then f works for me.

But as you are typing Cmd instead of Ctrl maybe you're on a Mac, aren't you? I don't know if this will work for you.

share|improve this answer

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.