How do I keep my row formatting when sorting data?

G

Guest

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
row height does not move with row when sorting 1
Hold conditional formatting when sorting filtered data 1
Background stays when sorting 2
How do I alternate shading of rows, Excel 2007, no new tabs. 1
Excel 2003 Pivot Formatting 2
Sorting in multiple worksheets 1
Auto re-numbering when a row is deleted 3

Top