Arial size 8 as default. Should I use macro or is there a better way?

bradyassoc

New Member
Joined
Nov 11, 2019
Messages
2
I like to have all my spreadsheets as Arial size 8, many spreadsheets I receive from colleagues and clients as different sizes and font and I just change manually by highlight all and edit.

Should I just use a macro and shortcut key to change this or can anyone suggest a better way?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Swayzy

Board Regular
Joined
Mar 30, 2018
Messages
78
I would make an add-in that formats sheet the way you want. This way you always have the right formatting macros with you
 

Swayzy

Board Regular
Joined
Mar 30, 2018
Messages
78
You would have tab in the ribbon that you click a button on. Just like you select the font size normally but for this button you have programed it to do exactly all the steps you need in One go.

I did more or less the same thing at work for our accountants, it even grouped copied comments etc.
 
Last edited:

Forum statistics

Threads
1,136,314
Messages
5,675,032
Members
419,544
Latest member
MVPDoug

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top