Computer Software

eg: UK or Brides UK or Classical Art or Buy Music or Spirituality
 
eg: UK or Brides UK or Classical Art or Buy Music or Spirituality
 
Business & Money
Technology
Women
Health
Education
Family
Travel
Cars
Entertainment
Featured Sites
SD Editorials
Online Guide and article directory site.
Foodeditorials.com
Over 15,000 recipes & editorials on food.
Lyricadvisor.com
Get 100,000 Lyric & Albums.
  • Business & Money
    • A Guide to Business
    • Guide to Finance
    • Ideas for Marketing
    • Legal Guide
    • Guide to Insurance
    • Lettre De Motivation
    • Guide to the Stock Market
    • Human Resource Career
    • Sales Marketing
    • Forex & Trading
    • Advertising & Marketing
    • Startup Guide
  • Technology
    • Guide to Technology
    • Cell Phones
    • Computer Software
    • IT Hardwares
    • Internet
    • Online Security
    • Cameras
    • Search Engine Optimization
    • Science & Technology
  • Women
    • Guide to Women
    • Relationship Advice
    • Marriage
    • Jewelry
    • Pregnancy
    • Fashion Style
    • Divorce Guide
    • Wedding Guide
    • Dating Guide
    • Natural Beauty
  • Health
    • Guide to Health
    • Guide to Medical
    • Plastic Surgery
    • Weight Loss
    • Sports
    • Body Wellness
    • Cancer Treatment
    • Common Illness
    • Health & Lifestyle
  • Education
    • Military Service
    • Politics and Policy
    • Arts & Humanities
    • Education and Teaching
    • Learn Languages
    • Colleges & Universities
  • Family
    • Quality Home Improvement
    • Hobbies and Interests
    • Family Guide to
    • Pet Guide
    • Loans Guide
    • Credit Cards
    • Gardening Guide
    • Home Security
    • Real Estate
    • Home Decor
    • Gift & Present
  • Travel
    • The Travel Guide
    • Adventure Travel
    • Cruise Ships
    • Beach Holiday
    • Travel Accommodation
    • Holiday Destinations
  • Cars
    • Information on Cars
    • Traffic Violations
    • Auto Insurance
    • Trailers
    • Sport Cars
    • The Bikes
  • Entertainment
    • Entertainment Guide
    • World Music
    • Photo & Video
    • Television & Games

Microsoft Excel Tips And Tricks

    View: 
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.
More Articles from
Microsoft Excel Office Pg2
Advanced Microsoft Excel Course
Advanced Microsoft Excel Training
Cell In Microsoft Excel
Function In Microsoft Excel
Functions In Microsoft Excel
How To Microsoft Excel
How To Reduce Errors
Introduction To Microsoft Excel
Microsoft Excel ... Ebook
Microsoft Excel 2007 Home And Student
Microsoft Excel 2007 Training
Microsoft Excel Advanced Training
Microsoft Excel File Format
Microsoft Excel Formulas And Functions
Microsoft Excel Spreadsheet Templates
Microsoft Excel Tips And Tricks
Microsoft Excel Training Course
Microsoft Excel Training Courses
Microsoft Office Excel Training
Microsoft Online Excel Training
» More on
Microsoft Excel Office
  • Related Articles
  • Author
  • Most Popular
•Advanced Microsoft Excel Course, by Rich Talbot
•Advanced Microsoft Excel Training, by Matthew Fletcher
•Cell In Microsoft Excel, by Andrew Whiteman
•Computer Orchestration Tips And Tricks, by Logan Albright
•Cooking Tips And Tricks, by Melinda Carnes
About Author
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.

Michael Rad has sinced written about articles on various topics from Alcohol Treatment, Perfumes and Cure Anxiety. . Michael Rad's top article generates over 368000 views. Bookmark Michael Rad to your Favourites.
Best Kind Of Exercise
So, with this information and now knowing you have lots of choices lets get up and move toward being healthier and happier
 
A Guide to Business | Guide to Technology | Guide to Women | Guide to Health | Family Guide to | Travel & Vacations | Information on Cars

EditorialToday Computer Software has 2 sub sections. Such as Software and All Microsoft Softwares. With over 20,000 authors and writers, we are a well known online resource and editorial services site in United Kingdom, Canada & America . Here, we cover all the major topics from self help guide to A Guide to Business, Guide to Finance, Ideas for Marketing, Legal Guide, Lettre De Motivation, Guide to Insurance, Guide to Health, Guide to Medical, Military Service, Guide to Women, Pet Guide, Politics and Policy , Guide to Technology, The Travel Guide, Information on Cars, Entertainment Guide, Family Guide to, Hobbies and Interests, Quality Home Improvement, Arts & Humanities and many more.
About Editorial Today | Contact Us | Terms of Use | Submit an Article | Our Authors