Spreadsheet

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Spreadsheet

Gerry Woodard
I would like to not have the color table change to the cell color when
selected. I would prefer that the color selection indicator remain fixed
until needed. For example, if I want to change several cells from red to
black, need only select black once from the table, Hope this is clear.
Thanks.
Jerry Woodard
*.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
* “Make America Great Again.” - Donald Trump*
Reply | Threaded
Open this post in threaded view
|

Re: Spreadsheet

Joost Andrae-2
Hi Gerry,

you can work wit cell templates. Therefor open the template dialog by
using function key F11 and create a new one by pressing the right mouse
button ontop of this dialog. Then select the "New" link. Hint: Assinging
a name to this template helps...

The function you want to use then is the water can button where you can
assign multiple cells with all that formating defined within the cell
template.

Otherwise (without using templates) you could also multi select all
those cells there you want to change the colour and then assign the
background colour at once.
In the icon bar you find a button for background color. Press it once
and then select the dialog title and drag it somewhere else (select the
title and hold down the right mouse button)

Using templates is a very powerful tool as it allows you to work with
inheritance of templates so a child template can inherit objects of it's
mother template. And cell templates can be exported to an other
document, so you can easily create a template library.

Based upon the usage of cell templates it's quite easy to use the
feature of conditional formatting (Format menu)

Kind regards, Joost


Am 20.03.2020 um 16:19 schrieb Gerry Woodard:
> I would like to not have the color table change to the cell color when
> selected. I would prefer that the color selection indicator remain fixed
> until needed. For example, if I want to change several cells from red to
> black, need only select black once from the table, Hope this is clear.
> Thanks.
> Jerry Woodard
> *.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
> * “Make America Great Again.” - Donald Trump*
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]