Microsoft Excel Cheat Sheet: Tips and Shortcuts
27767
Computers > Software
Jun 18, 2007
microsofttraining
Microsoft Excel Cheat Sheet: Tips and Shortcuts
Microsoft Excel is one of the most versatile programs within the Microsoft Office suite. If you are self taught and have not had any basic excel training you may not be aware of the many shortcuts available within the application. This article will provide some tips and highlight some of the many useful keyboard shortcuts to make it even quicker and easier to use. Tips Here are a few simple tips to make using Excel easier: Copying content from Word When you want to copy content from a Word document or a Web page into Excel, and you want that content to have the same formatting as what is in your spreadsheet already, double-click on the cell before pasting in the contents. Changing rows into columns To change rows into columns or vice versa follow the steps below: Select the row or column you want to change Press CTRL+C to copy it or CTRL+X to cut it Put the cursor in the top cell where you want to transpose the contents In the edit menu select PasteSpecial and then select Transpose. Basic calculations without entering formulas The AutoCalc tool in Excel will give you the results of some basic functions without you having to spend time entering formulas. If you highlight a group of figures the sum of these figures will be displayed towards the bottom right hand corner of the screen. By right clicking on this sum you have the choice of having displayed several other basic functions. The list of functions available is Average, Count, CountNums, Max, Min and Sum. Line breaks within a single cell When entering multiple times of text, for example an address, within a single cell you want to be able to control where the line breaks appear within this text. Pressing enter at the end of a line will just take you to the next cell down and using wrap text in combination with pressing the spacebar is very time consuming and will need correcting if you adjust the width of the cell. The easiest way to achieve this it to type the first line of text and then press ALT+ENTER. This will force an end of line at that point without taking you to the next cell. Shortcuts The keyboard can often work faster than the mouse and using it can be preferable when you're in the middle of performing a number of keystrokes and don't want to waste time trying to lay your hands on the mouse. Here is a list of quick keyboard shortcuts. Rather than trying to remember them all, why not just concentrate on the ones that you use on a regular basis. Copying, Pasting and Deleting Copy CTRL+C Copy value from cell above CTRL+SHIFT+" Cut CTRL+X Delete to end of line CTRL+DEL Paste CTRL+V Formatting Bold CTRL+B Border lines off CTRL+SHIFT+_ Border lines on CTRL+SHIFT+& Underline CTRL+U Moving within worksheets Move left one screen ALT+PAGEUP Move right one screen ALT+PAGEDOWN Move to beginning of worksheet CTRL+HOME Move to end of worksheet CTRL+END Selecting items Select row SHIFT+SPACEBAR Select to beginning of worksheet CTRL+SHIFT+HOME Select to end of worksheet CTRL+SHIFT+END Select worksheet CTRL+A
Author is a trainer with a Microsoft Office training company, the UK industry leader in its sector. For more information on Excel training, visit http://www.MicrosoftTraining.net.
send email to microsofttraining
Write a Review
Add to My Favorite
Refer it to Friend
Report Article
Other links owned by this user
Most people say that they feel intimidated by Microsoft Access. Training courses designed for rapid learning however, can get you feeling confident in just a matter of days.
Category:
Whatever line of business you are in, having well trained employees is vital to the success of that business. In the modern working environment most employees can't get through a working week without using a computer and the majority of them will use the
Category:
Studies have shown that a clearly defined business plan can be the difference between success and failure for all businesses, regardless of size or history. Creating and managing a plan can be a difficult endeavor even for experienced managers.
Category:
Even people who are experts at using Microsoft Excel don't often venture into the area of macros. Those that do are often satisfied with simple recorded macros and never look at the code that makes them work.
Category:
Microsoft Excel spreadsheets are an indispensable tool for accountants, being widely used to create financial statements as well as to produce many other types of financial reports including budgets, forecasts, cash flow and financial models.
Category:
Looking after domestic finances can cause much anxiety. Often you are anxious because you find it difficult to keep track of your finances and so do not feel you are in control. Using Microsoft Excel to record, monitor and control your domestic finances c
Category:
Preparing for a wedding can be a very stressful time, with a mountainous list of preparations to deal with and numerous decisions to make. There are many ways in which Microsoft Office can make things run easily and smoothly as the big day approaches.
Category:
8. Best Training Expands Support Forum to Handle Influx of Confusion Following Office 2007's Release
Microsoft Training company offers support forum to the public to handle the sudden wave of questions following the release of Office 2007. The once paid-members only support forum is now free to all internet users who seek answers from Microsoft Training
Category:
Whether you are a student preparing a dissertation, a client writing a letter to your bank or an entrepreneur developing your business plan, I expect that you will be using a word processing program, such as Microsoft Word, to do so.
Category:
The heart of a profitable business is one that operates effectively and efficiently; one where every employee works hard at doing their part to meet the overall company goals.
Category:
Microsoft Excel is one of the most versatile programs within the Microsoft Office suite. If you are self taught and have not had any basic excel training you may not be aware of the many shortcuts available within the application.
Category:
At some time or other in our lives we are likely to set ourselves personal goals, whether it is a New Year's resolution to get fit or a wish to gain a promotion and a pay rise. Regardless of our choice of target, a plan of action must be put in place to h
Category:
With a new baby on the way life can feel very full. From birth announcements and a photo-based Website about your new arrival to growth charts and christening invitations, Microsoft Office can help make everything run smoothly.
Category:
Other links at Computers > Software
We have placed the new program at our web site.This program will be usefull for people interested in Games & Entertainment and Puzzle & Word Games.Jigs@w Puzzle Platinum Edition is a truly realistic jigsaw puzzle game which has everything you need to
Category:
Accepting check by phone opens the door for your prospective business set up ? recurring customers, increasing market potentials, and impressive sales. With accepting check by phone and process the check with EZ Check Writer, launches the opportunities fo
Category:
Unless you're a computer expert, you may have absolutely no idea what the Windows Registry is, what it does, and why your computer has one. The Windows Registry is the database within your computer that stores the settings and options used on your compute
Category:
The OpenMoko-based FIC Neo1973 is "the World's First Integrated Open Source Mobile Communications Platform", the smartphone is expected to compete against the Windows Mobile, Palm, Symbian and now OS X operating systems on mobile phones.
Category:
It is quite normal for people to bathe everyday to clean the body of any impurities and unwanted things. Houses are cleaned everyday, clothes are washed everyday and similarly, the computer can be cleaned regularly too.
Category:
Site Sponsor
Directory Statistics
Articles: 68252
Categories: 501
Yahoo Entertainment
