How to format a table using a neat keyboard shortcut

How to format a table using a neat keyboard shortcut

Welcome to Excel 3 tip Friday - it’s just a short dose of Excel tips to build your skills each week! This week we cover the format painter, how to format a table using a neat keyboard shortcut, and different ways to round numbers using the CEILING function.

A quick win you can learn today -

Using the format painter tool is an easy way to copy and paste formatting within your Excel work - and I guess many of you will already know this one, but I’m including it in this week’s tip for those who don’t, as it’s super useful especially when working with a spreadsheet that uses lots of formatting.

Screenshot (75).png

Simply select the cells that you’d like to copy the formatting for, and click on the format painter, this will copy the formatting. Now click on the cells that you’d like to apply the formatting to, and the formatting will be applied.

If you double click on the format painter button, you can click onto multiple cells, rather than having to click each time you need to use it - just hit escape when you’re finished!

Check more useful keyboard shortcuts in Excel for Windows here!

A keyboard shortcut I'm adding to my list -

If you’ve taken any of my Excel training, you’ll know I’m a big fan of formatted tables for making it much easier to work with data. Usually, this involves selecting the data and clicking into the ‘Format Tables’ menu, but you can actually do this quickly using a keyboard shortcut. Select your data, and use Ctrl + L to automatically format your data as a table. It’s an easy way to make your data look better, and more organised.


A function I've found super useful this week -

Rounding numbers in Excel is fairly straightforward, either by formatting them with a certain number of decimal places, or by using the ROUND function (just type =ROUND(the cell to round, and the number of decimal places). But what if you need to round to the nearest 0.5 for example?

The CEILING function will round a number up to the nearest number of significance - where you can choose the amount to round to. So to round cell A1 to the nearest 0.5, type =CEILING(A1,0.5) or to round up to the nearest 1000, type =CEILING(A1,1000). It’s an easy way to use a function to standardise your data.

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

- Martyn

Edinburgh, Scotland

November 2018