Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting Short Cut Keys

Formatting Short Cut Keys

ResolvedVersion 2016

Thu 22 Aug 2019, 17:06 Delegate Dave said...

Dave has attended:
Excel Introduction course

Formatting Short Cut Keys

Can you set a custom number format to a hot key so that you can revert to that each time you use excel? Eg, Red, brackets for negative, no decimal places, dash for nil.

Thu 22 Aug 2019, 17:17 Trainer Jens said...

RE: Formatting Short Cut Keys

Hi Dave,

Thank you for the forum question.

Yes but you will need to code Excel.

You need to code a open workbook event and and write a OnKey event.

If you do not have VBA knowledge I am afraid the answer is no.

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

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formatting Short Cut Keys

Formatting Short Cut Keys

RE: Formatting Short Cut Keys

Excel articles

Excel tip:

Removing the Ribbon from view in Excel 2010