Forum Discussion
Create a custom cell format, apply with a keyboard shorcut
Hi anonymous_me
there is an easy solution for your problem, you just have to create a custom cell style.
1. Format one cell exactly the way you need (number format, fill color etc.
2. Select that cell and then open the menu "Home | Cell Styles | New Cell Style...":
3. Confirm (or adjust) the settings in the style-window. You can give it also a style name:
4. Done. Now you can just select the new style for your cells
Unfortunately, you cannot assign a keyboard shortcut to it, but it's still only one click with the mouse.
Hi anonymous_me
there is an easy solution for your problem, you just have to create a custom cell style.
1. Format one cell exactly the way you need (number format, fill color etc.
2. Select that cell and then open the menu "Home | Cell Styles | New Cell Style...":
3. Confirm (or adjust) the settings in the style-window. You can give it also a style name:
4. Done. Now you can just select the new style for your cells
Unfortunately, you cannot assign a keyboard shortcut to it, but it's still only one click with the mouse.
- Hi Martin_Weiss ,
That makes sense. I still will need to change the internal value in "i/o {value}", but I guess I'll could always make multiple Styles with the most used ones.
Thanks! - Hi sir! Can you help me with my problems in excel?
