How do I keep my row formatting when sorting data?

P

Peter

I have designed an Excel spreadsheet and I would like to sort the data while
still retaining the row formatting. For example, all of the odd numbered rows
are blue, and all of the even numbered rows are white. I would like to sort
the data in the rows and retain the color formatting to alternate. When I
sort the cells, it takes the row formatting with each row and then my data is
no longer nice and easy to read. Is there any way in which this "template"
can be preserved when sorting data so that the format does not travel with
the cell contents?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Dilemma 6
Background stays when sorting 2
Sorting multiple columns that have similar data 0
alternate row formatting in 2007-problems 0
Linking Rows Between Sheets When Sorting 1
Hold conditional formatting when sorting filtered data 1
row height does not move with row when sorting 1
Sorting in multiple worksheets 1

Top