A good tip with Microsoft Excel

Hi Guys

I just had to tell you about this little thing I learned over the weekend, its so simple I'm actually quite embarrassed to write about it but oh well. Its for you Microsoft Excel users, I hope you find some use in it.

Basically, I wasn't aware that you could use keyboard shortcuts to search for things in your excel spreadsheets! I had always used the menu functions, not any more though.

If you press control on your keyboard and hold it down along with pressing F, a little pop up box will appear where you can search for whatever piece of information you require. This will save me tons of time when I'm looking for specific data on my files!

This little shortcut will let you search almost anything you want and need from your data and its very quick too!

Not only that, I also learned that if you hold down control and press H, you can actually do a sort of search and replace of your data in the spreadsheet. Again, this will save me tons of time. Believe it or not, i actually manually searched for things in the passed, don't get me started on searching and replacing in the past, that would take me forever!

Its funny because I actually thought I was pretty good with Excel but with this revelation in my lack of skills, i think I may look into booking an Excel training course at some point. It may be something I regret doing because of the price, however if there are more things to learn like the one I just found out this weekend, i may give it a bash.

Anyway, I hope the rest of you are having a good time! I will be back soon!

Jill