LibreOffice ~ 100% Free
A Complete Office Suite that is 100% Free!

  • Word Processing
  • Spreadsheet Editor
  • Presentation Creator
  • Drawing Program
  • 100% Compatable with Microsoft Windows®
  • 100% Free
  • LibreOffice Calc Tutorial #5 – Editing Formulas

    LibreOffice's Calc is an agile free spreadsheet program that enables you to produce professional results with charts and amazing formatting. This incredible piece of freeware helps novice users in the creation of spreadsheets with wizards, templates and an overall intuitive ease of use, on the other hand its collaborative capabilities and its wide range of advanced features makes power user feel at home. Today I'm going to show you how to edit formulas.

    LibreOffice has to be installed before you follow this tutorial to do it in a proper way. Just click the “Download” button above and get your free fully functional copy of this magnificent free office suite, the InstallIQTM manager will take care of the rest.

    Assuming you have some formulas in a spreadsheet, if you select them by just clicking on them, you see the result in the cell and the formula in the input line like this:

    So, to open the cell that contains it for edition you should double click on it. It should look like this:

    As you can see the “A1” reference appears in blue and the A1 cell gets a blue outline, and the “B1” reference got a red outline. As you hover the mouse pointer over the referenced cells you'll see it turn into a hand indicating that the reference can be moved somewhere else, click on them and drag to the new location, it will also change the reference name on the cell itself.

    The color outlines have a grip point in their lower-right corner, clicking and dragging them from that point will widen the cell range.

    You can also add other cells by positioning the cursor where you want to place it and clicking on the cell you want to add

    This is similar to how we added those reference on the first place. As you can see you can also add operators to keep the sense of the formula.

    Final Words

    Editing formulas in Calc is really simple and easy, in our next tutorial I´m going to tell you how to make compelling charts. Get you free fully featured LibreOffice copy by clicking on the link below, satisfaction guaranteed!!



    LibreOffice Download Specs:
    » Version: 3.4.0 (Build:12)
    » Download Size: 168 MB
    » Tested Virus FREE
    » Software requirements: None
    » Operating System (OS): Windows XP,    Windows Vista, Windows Vista (64 bit),    Windows 7, Windows 7 (64 bit)

    » Tags: libreoffice, powerpoint, excel,    spreadsheet editor, word processor,    office suite, download free office

    Security Verified

    SSL

    Home           Video          Music          Graphic Design           Home Office           Utilities
       Español        Networking        
    Welcome to GoFree.com.
    Learn all about the latest software! GoFree is an in-depth software review site detailing the benefits and drawbacks of the most popular software without having to download anything. Discover tutorials and more!
    Terms & Conditions
    - - - - - - - - - - - - - - - -
    Privacy Policy
    - - - - - - - - - - - - - - - -
    Sitemap
    - - - - - - - - - - - - - - - -
    About Us
    - - - - - - - - - - - - - - - -
    Contact Us
    - - - - - - - - - - - - - - - -
    DMCA
    - - - - - - - - - - - - - - - -
    www.gofree.com ~ All Rights Reserved ~ 2010