SOLVED

Create a custom cell format, apply with a keyboard shorcut

Copper Contributor

Hello,

 

For my work I need to format some cells very specifically, and it is a pain to repeat the process 50 times every day.

The steps I have to do are the following:

select cell -> click in format cell -> More Number Formats... -> Custom -> 0" i/o {whatever number is there}" -> ok -> type 0 in the cell -> apply orange fill in cell.

Hope this picture ilustrates the result I am looking for.

anonymous_me_1-1639552650429.png

Is there any way to automate this a little?

 

I've been thinking to do it with macros, but it sounds overkill.

Ideally I would like to apply it with a custom keyboard shortcut.

 

Thanks!

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

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...":

DTE_0-1639553711876.png

3. Confirm (or adjust) the settings in the style-window. You can give it also a style name:

DTE_1-1639553783970.png

 

4. Done. Now you can just select the new style for your cells

DTE_2-1639553954010.png

 

Unfortunately, you cannot assign a keyboard shortcut to it, but it's still only one click with the mouse.

 

Hi sir! Can you help me with my problems in excel?
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!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

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...":

DTE_0-1639553711876.png

3. Confirm (or adjust) the settings in the style-window. You can give it also a style name:

DTE_1-1639553783970.png

 

4. Done. Now you can just select the new style for your cells

DTE_2-1639553954010.png

 

Unfortunately, you cannot assign a keyboard shortcut to it, but it's still only one click with the mouse.

 

View solution in original post