Is there a way to reduce the number of rows and columns in excel 2007? Instead of 16,000 columns and 1,000,000 rows I would like to shrink it down to 2,000 columns by 100,000 rows
Is there a way to reduce the number of rows and columns in excel 2007? Instead of 16,000 columns and 1,000,000 rows I would like to shrink it down to 2,000 columns by 100,000 rows
Last edited by rhudgins; 05-28-2010 at 04:58 PM.
Hi,
How about hiding the columns and rows?
Select column BXY (column 2001), Cltr+Shift+Right Arrow key, right click, Hide
Select row 100001, Cltr+Shift+Down Arrow key, right click, Hide
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
That works thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks