At 11:35 10/06/2020 +0100, David Deeks wrote:
I am editing a previously created spreadsheet that uses a variety of
colours for background and text. I need to add more cells that use
the same colours. If I select an existing cell, is there a way of
identifying the previously used colours? At the moment I'm selecting
all colours that look close, until I find the right one!
You probably don't need to identify the colours, but merely to
reproduce them. Two ways to do this:
(As has already been suggested)
o Select a representative cell.
o Click the Format Paintbrush in the Standard toolbar.
o Either click in a target cell or drag across a target range.
Note that you can double-click the Format Paintbrush if you wish to
format multiple cells or ranges. Press Esc to cancel the facility.
o Copy a representative cell.
o Select a target cell or target range.
o Paste, but using Paste Special (or Ctrl+Shift+V) instead of ordinary paste.
o In the Paste Special dialogue, untick Paste All if necessary and
ensure that only Formats is selected.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
