How to create a custom cell style in Microsoft Excel

dataminded excel 3 tip friday

As we move into December we have the last few editions of Excel 3 Tip Friday for 2018 - I’ve been running these weekly updates since March to provide you with an easy bite-sized way to learn some extra Excel.

I hope that you get value out of these tips - if you have any suggestions for future topics please hit reply and let me know.

A quick win you can learn today -

Cell styles are a useful way to quickly colour cells - including creating table headers, highlighting cells and more. If your organisation uses a common font, colour, or size you can set up custom cell styles so that they’re ready to use over and over again.

To create a custom cell style in Microsoft Excel, click into the cell styles menu on the home ribbon, and select New Cell Style. Give the style a name, and configure how you’d like your style to look. You can then apply the style easily to any cell or range using the cell styles menu.

A keyboard shortcut I'm adding to my list -

This week, another common Excel shortcut, in case you don’t already know it, is Ctrl + O - use this to show the open file box, instead of having to go into the file menu.

Check some keyboard shortcuts in Excel for Mac here!

A function I've found super useful this week -

You might be familiar with the Excel functions MAX and MIN which will return the highest or lowest values in a range. But what if you want to return to the second highest, or the third smallest? There’s 2 easy to use functions that can do this, LARGE and SMALL. Each has just 2 components, first the range, just like in a MAX or MIN function, and second the position number you’d like to return. For example, to select the 2nd highest value in A1:A10, type =LARGE(A1:A10,2) or to return the 3rd smallest use = SMALL(A1:A10,3).

As always, I hope you find these Excel tips useful, and please do reply if you have any comments or questions!

- Martyn

Edinburgh, Scotland

December 2018

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit