Alternating Row (or Column) Colors in Calc for or LibreOffice

You may also like...

14 Responses

  1. Muhammad Hassan says:

    Perfect, It was of really great help

    I would like to make a little addition
    Just Select all the rows and columns you want to be colored.

    If you want to Select the complete sheet, Press CTRL+A or click on Top Left Header (before Column A and Before Row 1 ) .

    Good Luck

    Muhammad Hassan

  2. Liam says:

    Is it possible to do this but using two different colours?

    For instance the even rows/columns coloured red and the odd rows/columns coloured blue.



  3. xico says:

    Great! You saved me! Thanks

  4. Riz says:

    I want to paste some numbers from one software to a table. Now I want some of the numbers to turn into some colour. What formula should I use for this? For example I want 74979,79002,78002 and 76002 to turn into red.
    Please help.

  5. Anonymous says:

    Thanks you, very usefull !!!

  6. Felipe Tonello says:

    Great man.. Thank you very much!

  7. Colin says:

    Unfortunately it removes the prior text formatting in the coloured rows so doesn’t work for me.

  8. Max Liedström Kvelland says:

    This no longer works as of 20th april 2015.

  9. Hokie says:

    Wow I just did a similar topic on using Excel. Seriously I think peolpe have forgotten how easy it is to just write down numbers. Then again, I wonder if that would also force them to remember what all those numbers mean.

  10. Leisa D. Peacock says:

    Works Great … Thank you for your time in posting this.

  11. Pradeep_K says:

    Awesome post , thanks

  12. michael says:

    is there a way to do this but to have the shading only chance when the id (colum 1) changes… to visually group the data??

  1. November 1, 2011

    Gadget Show Repeat…

    […]Alternating Row (or Column) Colors in Calc for or LibreOffice | Computer Correct[…]…

  2. January 24, 2013

    […] Row Alternate Color […]

Leave a Reply

Your email address will not be published. Required fields are marked *