LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default sort data without changing pattern

I have a worksheet where every other row has a 'pattern' in it to help make
it easier to read across the spreadsheet.

The problem I'm running into is as I add new rows at the bottom of the
spreadsheet and then resort them into their correct place, the patterns go
with the sort and now the patterns have to be redone again the get them back
to every other row.

Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing text in multiple cells by pattern forxigan Excel Discussion (Misc queries) 4 February 19th 08 08:53 AM
How do I sort or filter rows without column A data changing? Kesbutler Excel Discussion (Misc queries) 7 July 27th 07 10:57 PM
Sort changing formulas David P. Excel Discussion (Misc queries) 2 May 13th 07 11:48 PM
repeating a data pattern in excel KelC Excel Discussion (Misc queries) 1 August 1st 05 08:38 PM
sort data without formulas in other cells changing? Vicky Excel Discussion (Misc queries) 2 March 15th 05 01:17 PM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"