Technology Get the latest on technology, electronics and software…

Excel Help

Thread Tools
 
Old Feb 22, 2007 | 10:56 AM
  #1  
G's Avatar
G
Thread Starter
Bitten.
 
Joined: Jan 2004
Posts: 3,801
Likes: 0
From: Philly
Excel Help

I have a statistical file that is pretty big (about 20 worksheets) and I want to organize it more. I am wondering if there is a way to group worksheets like one groups rows of cells. Any ideas?
Reply
Old Feb 23, 2007 | 09:51 AM
  #2  
G's Avatar
G
Thread Starter
Bitten.
 
Joined: Jan 2004
Posts: 3,801
Likes: 0
From: Philly
Also, I have reached the maximum number of cloumns that I can have, IV, is there anyway to expand this? I need about 20-30 more columns!
Reply
Old Feb 23, 2007 | 09:53 AM
  #3  
FiftyFive's Avatar
Moderator Alumnus
 
Joined: Aug 2004
Posts: 10,823
Likes: 52
From: SW Connecticut
Originally Posted by ATXCLS
Also, I have reached the maximum number of cloumns that I can have, IV, is there anyway to expand this? I need about 20-30 more columns!
Yea, buy Office 2007

Which version of Office are you using?
Reply
Old Feb 23, 2007 | 09:55 AM
  #4  
G's Avatar
G
Thread Starter
Bitten.
 
Joined: Jan 2004
Posts: 3,801
Likes: 0
From: Philly
Originally Posted by FiftyFive
Yea, buy Office 2007

Which version of Office are you using?
2003. So does that mean that that is it-no more, se la vi?
Reply
Old Feb 23, 2007 | 09:59 AM
  #5  
FiftyFive's Avatar
Moderator Alumnus
 
Joined: Aug 2004
Posts: 10,823
Likes: 52
From: SW Connecticut
Originally Posted by ATXCLS
2003. So does that mean that that is it-no more, se la vi?
Well Office 2003 has its limits, 65635 rows and IV columns. MS Access does not have any limits, and i think Office 2007 expanded its excel limits to 1 million, however excel 2007 spreadsheets are not compatible with any older version of excel. Have you tried importing the info into an Access database?
Reply
Old Feb 23, 2007 | 09:59 AM
  #6  
Hojo061782's Avatar
Cause of power outages...
 
Joined: Jul 2004
Posts: 1,586
Likes: 0
From: Champaign, IL
Sounds like you need to use a database.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Yumcha
Automotive News
70
Dec 7, 2020 05:39 PM
Yumcha
Automotive News
4
Aug 15, 2019 12:58 PM
08_UA7_Gr33k
Member Cars for Sale
13
Feb 11, 2016 02:17 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
08_UA7_Gr33k
Member Cars for Sale
1
Sep 27, 2015 01:56 PM




All times are GMT -5. The time now is 11:47 AM.