View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Josh Josh is offline
external usenet poster
 
Posts: 103
Default sort column by date but keeping all rows locked

Thanks for the reply but doesn't keep all rows locked--is there some way to
lock all info in a row together?

"Gary''s Student" wrote:

Say the dates are in column A with other data in cols B thru G.

Select ALL columns A thru G and then sort by A. The other columns will
follow suit.
--
Gary''s Student - gsnu200843


"Josh" wrote:

Hi there. Can sort a column easily (by date, number, etc.) but can't keep the
corresponding rows in sync (locked) with original data item once sorted.
There must be an easy way to do this but I can't figure it out. Any advice?