Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting Short Cut Keys
Resolved · Low Priority · Version 2016
Dave has attended:
Excel Introduction course
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.
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:Adjusting the Elevation and Rotation in a 3-D ChartFor any 3-D chart you create, you can adjust the chart |
TrustScore
4.9
/ 5
2088 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.06 secs.
