LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Select all columns with data for sorting.

When selecting columns for sorting, is there a way to make it so it
automatically selects all columns with data in them? Say you have data in
columns A-T but accidentally only select A-S, and then sort it, but didn't
realize you hadn't selected all of the columns. That last column is no longer
correct, but you don't know it.

Sorry if this doesn't make sense, I'm trying to figure it out to help my
boss and I'm stuck.
 
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
Sorting Data into columns without replacing the columns with data Sandaime New Users to Excel 2 October 18th 07 01:35 PM
Select data from 1st of up to 6 columns & Xfering to other workshe JPG Excel Discussion (Misc queries) 3 May 1st 06 11:19 PM
sorting data in columns Spiderman Excel Discussion (Misc queries) 2 October 6th 05 09:45 PM
Select updated data from a range of columns Alylia Excel Worksheet Functions 5 August 30th 05 01:53 PM
Sorting two columns of data Max Excel Worksheet Functions 6 June 13th 05 01:30 AM


All times are GMT +1. The time now is 02:20 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"