Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nanimadrina
 
Posts: n/a
Default sort column data with hidden columns - excel 2003

I want to sort on a column of data (card #) where my worksheet has hidden
columns. I read in help that I should unhide the columns, but I am trying to
avoid that because it is a corporate worksheet and I have to copy/paste data
into it each month.

Is there any other way that I can accomplish a sort with hidden columns? I
have zero experience with macros...would a macro be able to sort data with
hidden columns in it?

HELP! I'm trying to find a way to save hundreds of hours/year in gas
receipt reconciliations...
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

Hi 'nan'-

As long as your data is arranged in consecutive columns and rows with
captions (field names) in the first row, there is no problem.

Place your cell selector in your records (anywhere), then go to DataSort
and specify up to three sort fields, ascending/descending. The records will
be sorted accordingly, including the content in hidden columns.

HTH |:)

"nanimadrina" wrote:

I want to sort on a column of data (card #) where my worksheet has hidden
columns. I read in help that I should unhide the columns, but I am trying to
avoid that because it is a corporate worksheet and I have to copy/paste data
into it each month.

Is there any other way that I can accomplish a sort with hidden columns? I
have zero experience with macros...would a macro be able to sort data with
hidden columns in it?

HELP! I'm trying to find a way to save hundreds of hours/year in gas
receipt reconciliations...

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Just make sure you include the hidden columns in the sort range.

i.e.

Data in A through M

D through L are hidden.

Select A through M and DataSort.

The hidden columns will sort along with the others because sorting is being
done by rows.

Works the same with hidden rows if sorting left to right.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 11:59:11 -0700, "nanimadrina"
wrote:

I want to sort on a column of data (card #) where my worksheet has hidden
columns. I read in help that I should unhide the columns, but I am trying to
avoid that because it is a corporate worksheet and I have to copy/paste data
into it each month.

Is there any other way that I can accomplish a sort with hidden columns? I
have zero experience with macros...would a macro be able to sort data with
hidden columns in it?

HELP! I'm trying to find a way to save hundreds of hours/year in gas
receipt reconciliations...


Reply
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
Where is the Template Wizard with Data Tracking Excel 2003? liz braford Excel Discussion (Misc queries) 8 December 7th 05 07:50 PM
spliting a column of data into multiple columns CiceroCF Excel Discussion (Misc queries) 7 March 25th 05 01:40 AM
How do I sort a column of data and have each data row sort accordi Oedalis Excel Discussion (Misc queries) 1 March 18th 05 12:52 AM
How do I transpose an Excel 2003 column of data? LordByron New Users to Excel 2 March 3rd 05 04:33 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 05:08 PM.

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

About Us

"It's about Microsoft Excel"