Mike Seddon is one of the founders of Kutchka. Their mission is to make life easier in the office by providing tools which help you get the best out of Microsoft Office. Each week through their newsletter they provide free tips for Microsoft Office users. Why not sign up yourself at http://www.kutchka.com
Like many users of Excel, I've found a few really useful features which I use quite often.
Here are my top five.
Keyboard Shortcuts
Try the following Excel keyboard shortcuts. They can really make your life easier.
Ctrl + ASelect all cells
Ctrl + HomeGo to cell A1
Ctrl + EndGo to last cell in the range
Ctrl+ Shift+ EndSelect from active cell to last cell in the range
Ctrl+Shift+HomeSelect from active cell to A1
Ctrl + Page DownGo to next worksheet
Ctrl + Page UpGo to previous worksheet
Speed copying in Excel
To quickly copy a cell across a row or down a column simply select the cell you want to copy and then move the mouse cursor until it is placed above the bottom right corner of the cell. The cursor will turn to a plus (+) sign.
Now hold down the left mouse button and drag across either the row or column until you have selected all the cells you want to paste into. Release the button and your first cell will be copied to all the chosen cells.
Instant Charts in Excel Spreadsheets.
Fancy a quick chart from a table of figures in Excel?
It's so easy. Just select any of the cells in the table of numbers and press F11.
Try experimenting with it It's a fast easy way to get a quick chart.
Headers and Footers on Excel Spreadsheets.
Did you know you can print your Excel spreadsheets with Headers and Footers?
Simply click on the File menu and select Page Setup. Now select the Header/Footer tab. Try experimenting with the Custom Header and Custom Footer options as well.
Quick calculator in Excel
How many times have you been working in Excel and you have reached for the calculator in Windows. Usually to check something Excel is telling you!
So, why not put a button in Excel which will fire up the calculator for you.
Simply select View/Toolbars/Customize in Excel.
On the Customize screen, select the Commands tab and then select Tools from the Categories list.
Scroll down the list of icons until you see the calculator. It's labelled Custom (no I don't know why either!). Drag it to your toolbar and there you have it.
- Related Videos
- Related Articles
- Ask / Related Q&A
- Effective Use of Spreadsheets - Microsoft Excel - Indexing Your Spreadsheets
- How to Create A Microsoft Excel Database
- Chi-square Distributions With Microsoft Excel
- Microsoft Excel 2003: Working With all Toolbars
- Five Tops Tips for Excel
- Calculating Present Values With Microsoft Excel
- Excel Tips on Conditional Formatting
- Network Marketing: Tip #3- Keeping Your Call Log Organized
Custom Software: It’s Not Just About Customization
By: Arun Kumar | 08/01/2010A software solution company uses the most advanced and innovative software design and development tools today. Projects of all nature and sizes are taken and experienced developers work on them for offering complete satisfaction.
Acronis Disk Director Suite 10.0 helps solve all your HDD problems
By: topsofts | 08/01/2010Acronis Disk Director Suite 10.0 is the best program for manageing your HDD. It comes with 5 more programs incorporated that will help solve all you Hard disk drive problems, and meets all your needs.
Custom Software: When Result Does Matter
By: Arun Kumar | 08/01/2010With the exploration of new business avenues, the entire scene of online business has seen a drastic change today. People are now venturing into those fields, departments and processes which were once out of one’s reach, even in their dreams. But things are completely different today, they have not only made entries into those lands, they have also shown great amount of success.
Don’t Worry about Your Slow PC from Today
By: topsofts | 08/01/2010Asmw PC Optimizer pro is a collection of over 30 system-maintenance and optimization utility to tuneup windows performance. Registry Repairs, Remove junk files and other optimizer functions.
Pass4side 642-746 Training materials
By: aminalee | 08/01/2010Pass4side provides Cisco 642-746 exam study materials,such as Cisco 642-746 Braindumps, 642-746 Study Guide, 642-746 exam Questions with Answers, 642-746 Training materials, free 642-746 demo and so on.
Convert flip to Gphone/G1/Nexus One on Mac
By: jolly | 08/01/2010Free download flip video to Gphone WMV/MP4/3GP, putting/importing flip video into T-mobile G1/G2/G3/Nexus One/ Android phones on Mac.
ECommerce Integration Developing for Microsoft Dynamics GP Notes
By: Andrew Karasev | 07/01/2010When you have legacy in-house programmed ecommerce web application in production with shopping cart, credit card payment interface, B2B or B2C items catalogs and promotional pricing - which does the job - likely that you will favor the idea to leave it there and try the way of ecommerce integration connectors to your Microsoft Dynamics GP Corporate ERP application.
BGI completes labeling portfolio with PTI-compliant traceability software solution from TraceGains
By: Thomas Cutler | 07/01/2010BGI completes labeling portfolio with PTI-compliant traceability software solution from TraceGains
Ok. I'Ve Got My Keywords. Now What?
By: Mike Seddon | 26/02/2009 | SEOGreat. You've found some excellent keywords for your web site. Now all you need to know is exactly where to put them to get the maximum SEO benefit.
Don't Get Fooled by Adwords Qualified Companies
By: Mike Seddon | 17/01/2009 | PPC AdvertisingDon't get fooled into thinking that hire a Google Adwords Qualified Company means you will get a Google Qualified Individual to manage your account.
Credit Crunch Hits Ice Cream Sellers in Alaska
By: Mike Seddon | 08/11/2008 | PPC AdvertisingWould you sell ice cream to the Eskimos in Alaska? Of course you wouldn't. But many Adwords advertisers are committing that sin everyday by advertising their products in countries and regions that are simply not interested. Are you?
Killer Adwords Mistakes That are Costing You Money
By: Mike Seddon | 18/08/2008 | PPC AdvertisingEvery minute of every hour of every day your adwords campaigns could be wasting you a fortune. Are you making these money losing Killer Mistakes?
Proven and Amazing Adwords Click Through Booster
By: Mike Seddon | 17/08/2008 | PPC AdvertisingIf I had one tip that I was reluctant to share because it is such a winner then it's this one. Hopefully none of my competitors will read this article!
SEO or Adwords. Which is Best?
By: Mike Seddon | 12/06/2008 | SEOIs SEO better than Adwords for generating traffic for your website? Are you backing the wrong one
Don't Mess With Google's Golden Rule
By: Mike Seddon | 24/05/2008 | PPC AdvertisingWhat is the One Top Tip for Google Adwords? What is their one Golden Rule that you need to follow to get cheaper clicks and higher ad positions. Read on.
Are you Making the Five Biggest Google Adwords Mistakes?
By: Mike Seddon | 16/11/2007 | Online PromotionThere are five killer mistakes that many people are making with their Adwords campaigns that are making it impossible for them to be successful.