Ask Your Question

Shortkey for FormatPaintBrush [closed]

asked 2012-09-07 09:03:31 +0200

DeepDreamer gravatar image

updated 2013-10-26 14:11:26 +0200

manj_k gravatar image

I cannot find shortkey for FormatPaintBrush action. It seems that there is no such shortkey. But it is so useful for formating spreadsheets.

I suppose it should be implemented by developers, using Ctrl+Shift+C combination for getting format and Ctrl+Shift+V for applying copied format to active cells

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 01:48:14.922171

1 Answer

Sort by » oldest newest most voted

answered 2012-09-09 12:17:59 +0200

tohuwawohu gravatar image

There are already two ways to apply Format Paintbrush using the keyboard:

  • use "Paste Special": CTRL+C to copy, select the target cells, hit CTRL+SHIFT+V, and deselect every option in the "Selection" area instead of "Formats";

  • just assign Format Paintbrush to your desired keyboard shortcut. Select Menu "Tools" -> "Customize" -> "Keyboard", select "Edit" from the "Functions" list at bottom left, select "Format Paintbrush" from the next listbox, select a shortcut from the list above (for example CTRL+P), hit "Modify". After this, you can proceed like this:

    • Select "source cell";
    • hit CTRL+P,
    • click on the target cell(s).

IMHO the key combination CTRL+SHIFT+V isn't suited as you've proposed, since this triggers the "Paste Special" feature that's very important for many users.

edit flag offensive delete link more


With LibreOffice version, I found Format Paintbrush to be Clone Formatting.

silver_est gravatar imagesilver_est ( 2015-08-28 10:49:11 +0200 )edit

Question Tools


Asked: 2012-09-07 09:03:31 +0200

Seen: 2,697 times

Last updated: Sep 09 '12