How do you reduce the number of rows and columns in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1622108%22%20slang%3D%22en-US%22%3EHow%20do%20you%20reduce%20the%20number%20of%20rows%20and%20columns%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622108%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20that%20is%20too%20large%20to%20move%20around%20(the%20screen%20freezes%20consistently)%3C%2FP%3E%3CP%3EThere%20is%201048576%20rows%20and%20columns%20to%20XFD%3C%2FP%3E%3CP%3EI%20would%20like%20to%20remove%20some%20columns%20and%20rows%20to%20see%20if%20this%20has%20an%20effect.%26nbsp%3B%20I%20have%20already%20cleared%20all%20the%20data%20and%20formatting%20from%20the%20last%20cell%20and%20this%20does%20not%20chang%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1622108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622650%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20reduce%20the%20number%20of%20rows%20and%20columns%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622650%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776469%22%20target%3D%22_blank%22%3E%40JanetteK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can't%20remove%20rows%2Fcolumns%20at%20all%2C%20you%20may%20only%20hide%20them.%20That%20won't%20affect%20the%20performance.%20Did%20you%20clear%20the%20data%20by%20Clear%20All%20on%20empty%20regions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1624029%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20reduce%20the%20number%20of%20rows%20and%20columns%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624029%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Sergei%26nbsp%3B%20-%20I%20have%20cleared%20them%20using%20the%20Edit-Clear%20All.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20have%203%20tabs%20with%2016%2C000%20lines%20on%20each%2C%20so%20I%20guess%20it%20is%20just%20how%20it%20is.%26nbsp%3B%20Problem%20is%20I%20can't%20even%20copy%20them%20to%20put%20the%20data%20in%20another%20file%20as%20it%20keeps%20saying%20I%20don't%20have%20enough%20memory.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have an excel file that is too large to move around (the screen freezes consistently)

There is 1048576 rows and columns to XFD

I would like to remove some columns and rows to see if this has an effect.  I have already cleared all the data and formatting from the last cell and this does not chang

2 Replies
Highlighted

@JanetteK 

You can't remove rows/columns at all, you may only hide them. That won't affect the performance. Did you clear the data by Clear All on empty regions?

Highlighted

@Sergei Baklan 

Thanks Sergei  - I have cleared them using the Edit-Clear All.

 

I do have 3 tabs with 16,000 lines on each, so I guess it is just how it is.  Problem is I can't even copy them to put the data in another file as it keeps saying I don't have enough memory.