Forum home » Delegate support and help forum » Microsoft Excel Training and help » Colour palette

Colour palette

ResolvedVersion 2016

Tue 10 Dec 2019, 15:47 Delegate Amy said...

Amy has attended:
Excel Advanced course

Colour palette

can you fix the colour palette so that users cannot deviate from this?

Tue 10 Dec 2019, 17:37 Trainer Jens said...

RE: colour palette

Hi Amy,

Thank you for the forum question.

Unfortunately we don't have this functionality in Excel. It can be done in MS Word. There is a walk around in Excel but it has to be done by VBA coding and it is not an easy task.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 17 Dec 2019: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Colour palette

Colour palette

RE: colour palette

Excel articles

Excel tip:

Adding date and time