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
Microsoft Excel Tips And Tricks
Generally speaking, the better your credit the better your chances of getting a zero down payment home loan. Fortunately, mortgage lenders are now offering no money down home loans to homebuyers who have less than perfect credit. You may pay a slightly higher interest rate than those who put down ten percent or more, but you can still get a great interest rate and easy payments when you apply for a no-money-down home loan. You can expect to pay private mortgage insurance if your pay little or no money down on your new home, but the cost is relatively low and you will be able to drop the private mortgage insurance after you have built a certain amount of equity on your home.
If you do not have the resources to pay a twenty percent down payment, you could opt for a piggyback loan. A piggyback loan is basically a home equity loan that funds part of your down payment. There are several options in obtaining a piggyback loan. Mortgage lenders have a variety of programs and loan products that will help you accomplish your dream of home ownership, even if you have little or no money for a down payment. Your lender can also inform you of various government programs that assist those who qualify with their down payment. Most of these programs consist of basically a low interest loan that you repay along with your mortgage payments. There are some government programs that will not require you to repay any down payment assistance you may receive.
Get quotes: Different lenders may quote you different prices, so you should contact several lenders to make sure you're getting the best price. You can also get a mortgage through a mortgage broker. Brokers arrange transactions rather than lending money directly; in other words, they find a lender for you. A broker's access to several lenders can mean a wider selection of loan products from which you can choose.
Get Costings: Be sure to get cost information about mortgages from several lenders or brokers. Know how much of a down payment you can afford, and find out all the costs involved. Knowing just the amount of the monthly payment or the interest rate is not enough.
Ask each lender and broker for a list of its current mortgage interest rates and whether the rates being quoted are the lowest for that day or week.
Ask about the mortgage's annual percentage rate (APR). The APR takes into account not only the interest rate but also broker fees and certain other credit charges that you may be required to pay, expressed as a yearly rate.A mortgage often involves many fees, such as underwriting fees, broker fees and closing costs. Every lender or broker should be able to give you an estimate of its fees. Many of these fees are negotiable. Some fees are paid when you apply for a mortgage and others are paid at closing. In some cases, you can borrow the money needed to pay these fees, but doing so will increase your loan amount and total costs. "No cost" loans are sometimes available, but they usually involve higher rates.
Negotiate: Once you know what each lender has to offer, negotiate for the best deal that you can. There's no harm in asking lenders or brokers if they can give better terms than the original ones they quoted or than those you have found elsewhere. Once you are satisfied with the terms you have negotiated, you may want to obtain a written quote from the lender or broker. The quote should include the rate that you have agreed upon and the period the quote lasts. When buying a home, remember to shop around, to compare costs and terms, and to negotiate for the best deal.
Both Rich Talbot & Michael Rad are contributors for EditorialToday. The above articles have been edited for relevancy and timeliness. All write-ups, reviews, tips and guides published by EditorialToday.com and its partners or affiliates are for informational purposes only. They should not be used for any legal or any other type of advice. We do not endorse any author, contributor, writer or article posted by our team.
Rich Talbot has sinced written about articles on various topics from Software, Data Recovery and Software. Author is a trainer with a Microsoft Office training company, the UK industry leader in its sector. For more information on. Rich Talbot's top article generates over 165000 views. Bookmark Rich Talbot to your Favourites.