So, you’ve added your data in Excel, but it looks a little boring and perhaps not as clear as you would like; however, you don’t have time to format it manually with specific fonts, font colours, borders and colours. This is where the Cell Styles come in. Cell Styles contain pre-set formatting and can be used not only to add clarity and style to your workbook, but also to ensure that the formatting is consistent throughout.

A Cell Style includes font and font size, number formats, cell borders and cell shading. When you apply a Cell Style, all these formatting options are added to the selected cells in one easy step. What’s not to like!

However, if you don’t like the built-in Cell Styles or if you need to use particular fonts and colours to match your branding, you can create your own customised style to use over and over again in your workbook.

Apply Cell Styles

  1. Select the cells you would like to apply a style to
  2. On the Home Ribbon, click the Cell Styles button in the Styles group
  3. Click on the style you would like to apply

Figure 1 – Use pre-formatted cell styles

Create a Cell Style

Sometimes the built-in styles aren’t quite what you want. You can create your own Cell Style to allow you to rapidly format your workbook consistently.

To create a cell style

  1. Format a cell/some cells in the style you would like to add to Cell Styles
  2. On the Home Ribbon, click the Cell Styles button in the Styles group
  3. Click on New Cell Style

Figure 2 – Create your own styles

  1. Give the style a name
  2. Un check any boxes that relate to styles you do not want to keep
  3. Click OK

Figure 3 – Name the new style

  1. If you want to change anything on the style before confirming, click on the Format button to bring up further options.
  2. Your custom style appears in the Cell Styles drop down menu under “Custom”

Figure 4 – See the new style in the Cell Styles Gallery

I use this feature all the time to ensure consistency in my spreadsheets. Yes, there are times when I want to use different formatting, or I just feel in the mood to have a play with the formatting options. But there are other times when I need to quickly create or modify a spreadsheet, and then I use Cell Styles.

Have a play with the Cell Styles and see what you think.

To learn more about Microsoft Excel visit the Excel category of courses on tomorrow’s VA All Courses (tomorrowsva.com)

Or why not take look at the HUB and have access to ALL my courses including any new ones that are added. Always the best value.

The session was well structured and the explanation was very clear. It was amazing how Shelley managed to squeeze so much info in just one hour and a half! Colin’s support and contributions were also very valuable, and so were “Virtual Veronica”‘s. Thank you for a most interesting and useful training session at the Miss Jones Virtual Summit!

Laura Carizzo- Royal Norwegian Embassy in Argentina

I haven’t used PowerPoint in 20 years, this has really boosted my confidence.

Lyn Parker

Course is packed with so much valuable information in a easy-to-understand and follow language, even for a complete beginner. I can respect the fact that sometimes it’s very hard for an expert to break the information down to basics. but Shelley has done it brilliantly. I was sure that I knew quite a bit but Shelley has proven me wrong even at the very beginning of the basics of PowerPoint. Lessons are short and precise which allowed me to easily transfer the new skill into practice without being overwhelmed and to carry on adding on more with each lesson. I had so many ‘Aha!’ moments and for most of them I couldn’t believe I used to pay graphic designer to do it for me, now, thanks to Shelley, I am looking forward to creating, designing, converting my presentations all by myself!

Iva Freeman – Vertex Human Capital

Shelley was very thorough and knew a lot of tip’s for using Teams, thank you 🙂

James O’Connor – Cavannah Homes

Very informative, constantly getting everyone in the meeting involved, loved every bit of it!

Dylan Teal Hopkins – Cavannah Homes
Fantastic and informative training and great to see all of the exciting functions with Microsoft Teams.
Laura Rigby – The Apprenticeship College
Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.
Leigh Dowling – Innuous

Microsoft Teams One to One Training Session

Shelley was approachable, easy to work with, and agile with answering questions to apply the session to my specific needs

Melissa Marshall – Present Your Science

A course on Outlook had been on the top of my list when Shelley asked VA’s what they wanted to learn.

It was a real case of ‘so that’s how you do it’ or ‘I never knew that’. I have to say that I learnt so many great tips it has definitely improved the way I work in Outlook and my inbox is looking colourful and organised and I can’t wait to share this knowledge with my clients.

Jacqueline Leake – JLeake VA Services – Outlook

A great course with lots of examples and step by step instructions. I can now confidently create infographics and as a bonus, I learnt a lot of new PowerPoint functionality that will enhance all my PowerPoint work and save me so much time.

Jessica Bailey – Integral Resource

I really like Shelley’s courses. She has a clear and easy to follow teaching style. In ‘How to Create Fillable Forms’ I’ve learned about the functions of the Developer ribbon which will mean I’ll be able to create a bespoke Returns Form for a client who has an online shop

Freya Henderson – Virtual Office Orkney

Shelley was really clear in her teaching and went at a pace that was helpful to us. We covered all we needed to know to get us started, as a small team, using MS Teams. She was also very helpful in the run up to the session, with check in calls and ensuring our platform was set up correctly. I would highly recommend Shelley to anyone wanting to learn to navigate their way around MS Teams.

Sarah Clements – Inuous

Absolutely superb course, easy to follow and to refer back whilst putting it all into practice! I was unaware of the extent you can customise a presentation and it’s just made me want to know more – what’s next Shelley?

Denise Williams

I thought I had a pretty good grasp of Outlook until I did this course! In her videos, Shelley is clear and concise, and the language she uses is straightforward and jargon-free. Each module is broken down into manageable chunks, which helps keep your attention and means the course is easy to fit in around other commitments. I’ve created email templates and implemented rules that are already saving me time, and as all the other things I’ve learnt start to become second nature, the positive impact on my efficiency is fast becoming clear. This course has been incredibly beneficial and I would highly recommend it to anyone looking to strengthen their skills and boost productivity.

Pip Doleman VA

I thought I knew Powerpoint really well, but I wanted to specifically learn how to use Powerpoint to create better infographics, easily and quickly. Shelley explains everything in a very logical and clear way, so I understood everything the first time I heard it. The most useful thing I learnt was that Powerpoint can do so much more than I thought it could. By also using the short cuts that Shelley showed me I am much quicker than I have ever been and I thought I was already quick!

Susan Marot

Shelley Fishel of Tomorrow’s VA has a wealth of experience in Microsoft Office. I met her in person 2 years ago at the PA Show in London. I also saw her in action in a fab workshop and knew she was the whizz that everyone had told me she was. I have since bought a lifetime access to her HUB and all the courses in there are a MUST if you are a VA on a mission. The courses will give you confidence in all the Office 365 components and will catapult you to dizzy heights

Alex Hughes