View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Column Inserting and sorting problem

You should always select the range (rows and columns) before sorting.
--
David Biddulph

"Kevin" wrote in message
...
My problem occurred when I Inserted a column before D then sorted my sheet
by
column B. Problem was the sort didn't include the whole sheet and did not
go
past the newly inserted column. Can anyone tell me why this happened?
When I highlighted Column B His the sort az button told me to expand
selection and I did, but it did not include whole sheet. Any explanation
would be helpful.