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
- Five Tops Tips for Excel
- Calculating Present Values With Microsoft Excel
- Excel Tips on Conditional Formatting
- Ms Access And Ms Excel - What To Do When Sorting Does Not Work
- Adwords Keyword Research Tools & Tips to Find Profitable Keywords
How to convert iTunes M4P to MP3 for Zune PSP BlackBerry
By: terry007 | 06/07/2009to burn those tracks to an audio CD and then rip them once again to your computer hard drive wherein the DRM will be removed and you will get the tracks in (DRM free) MP3 format
‘Found key at pagethat points…’ MySQL Error
By: colindolly | 06/07/2009Stellar Phoenix Database Recovery For MySQL is a comprehensive MySQL Database Recovery utility that provides safe and instant database repair. It supports MySQL Server 4.x and 5.x. It provides complete recovery for InnoDB (.ibdata, .ibd and .frm) and MyISAM (.myd, .myi and .frm) files. It can recover databases created on Windows and Linux platforms. The software is compatible with Windows Vista, XP, 2003 and 2000.
Understand Customer Better – Use Efficient Language Translation Tools
By: ajax | 06/07/2009Language of the content plays an important role in bringing in new customers and retaining existing ones. Since web sites are globally available they must cater to different language users. Language translation products must be appropriately used to highlight and project the web site content.
Dynamics GP Supply Chain Management Notes
By: Andrew Karasev | 05/07/2009Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, has good selection of native modules: SOP, POP, Inventory Control, Purchase Configurator, plus you could find various Add-ons or custom modules, supported by Dynamics GP ISV partners
Dynamics GP in Retail Business: Implementation and Integration Notes
By: Andrew Karasev | 04/07/2009If you are at the point of decision on Microsoft Dynamics GP, formerly known as Great Plains Dynamics, implementation for Retailer with multiple retail stores, we would like to describe “solutions”, which could be deployed in your organization.
Backup iPod: a right step
By: jimmy | 04/07/2009Backup iPod is a right step to keep safe your iPod data into another storage media for further use when data loss takes place.
The Advantages of Hotel Management Software
By: Editor123 | 04/07/2009No matter which side of the reservation desk you are standing on, the hotel online reservation system is now becoming indispensable for everyone. Whether it’s the customers or the hotel industry itself, the convenience, reliability and flexibility offered by hotel software has earned great respect and fan-following.
UPS Control Software Efficiently Manages UPS
By: Article Expert | 04/07/2009UPS control software is easy to install and comprises of all the latest technologies. UPS control software serves the purpose of both the individual users and corporate users and can be availed in numerous versions.
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.