So, you think you know some pretty nifty shortcuts in Excel?. How’s about this one, race you to draw borders around your cells……
Other Excel Tips
1. Move Around Excel Worksheet With The Keyboard
2. A Fast Fun Way To Learn Excel Formulas
Helping YOU To Excel At Excel
by Barbara
So, you think you know some pretty nifty shortcuts in Excel?. How’s about this one, race you to draw borders around your cells……
1. Move Around Excel Worksheet With The Keyboard
2. A Fast Fun Way To Learn Excel Formulas
by Barbara
From Excel 2007 onwards you can use the Table command to convert a data list or set into a formatted Excel Table. Once your data is converted into a table you can use their many features such a filtering, sorting, searching to help you view and organise your data.
Now we have our data optimally prepared we are ready to convert to an Excel Table.
Your data will be now be an Excel Table, and will be formatted in the default style for an Excel Table which you can change if you choose to.
A gallery of available table formats will appear, hover over a format to see what your date set will look like. Or, you can create your very own style by clicking on the New Table Style button below the table formats.
When you have finished with your formatting, just click a cell outside of your data table to remove the Design Tab. If you need to change the formatting at a later date then just select one of your cells in your data table to re display the Design Tab.
More Excel Tips
1. Make All Of Your Excel Charts The Same Size
2. Prevent Users Printing An Excel WorkBook With Some Simple VBA
3. A Fast Fun Way To Learn Excel Formulas
4. Conditional Formatting The Top Bottom Rules
by Barbara
We all love a bit of formatting, but copying and/or repeating formatting can be a big pain unless you use the super format painter. So, here is how to quickly copy formatting from one worksheet to another worksheet or workbook.
There’s a few ways to make the most of this feature:-
1. To copy formatting to adjacent cell/s in Excel using Format Painter
2. To copy formatting to non adjacent cells in Excel using Format Painter
by Barbara
I know someone who loves cell borders, they really do. I’m no fan myself in most circumstances. But, in keeping with the Bronze Silver and Gold theme of the recently finished Olympics In London 2012, lets jazz up our cells with some with some border color fun.
As you can see below I have chosen Bronze Silver and Gold to emphasize the medal awards for GB.
This is a nice way to highlight important pieces of information on your Excel worksheets
by Barbara
In Excel you aren’t restricted to having your whole cell full of text formatted in the same way. You can have individual formatting on different characters within a cell. (This only works with cells that have text only!) . This is a nice way to emphasize a point you are trying to make or jazz up a workbook- why not??? Here is how
Here’s a couple of examples:-