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
Excel allows you to sort your data in many ways, but with Excel 2007 onwards we can now sort easily by the font colour or by the cell fill colour. It is easy and effective and is available as a custom sort function.
1. Quickly Import Data Into Excel From The Internet
2.Quickie Excel Tip:- Shrink Your Excel Data
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
Excel 2002 introduced the Text -To – Specch feature. It’s an interesting one, you can get Excel to call out back to you the contents of a range of cells, or call out the cell contents as you type the data.