Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've got a long list of data (export from MySQL) that I want to print out to tick each row after I've done stuff with it. Is there an easy way in Excel 2010 on Windows to make the table zebra-backgrounded for better readability? I've found some solutions that use conditional formatting, but that doesn't seem to work in Excel 2010. Also, my Excel is in German and the English formula commands do not work.

share|improve this question
Why not just use Format as Table from the Home tab and select a design with alternating colors? Or am I misunderstanding the question. –  James Oct 17 '12 at 11:49
I didn't know about it. That's exactly what I'm looking for. Thanks.:) –  simbabque Oct 17 '12 at 12:00

1 Answer 1

up vote 3 down vote accepted

Fastest way I have found is to select your data and click the Format as Table button on the Home Ribbon. Choose the style you want.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.