Stop Excel Rows From Being Continuously Created

Excel has excess columns & rows (thousands of them)

Posted by Rusty4508

I have a few spreadsheets that for some reason have rows up to 10s of thousands & columns up to AAZ....if I try to delete them, it has memory issues. Does anyone know of a way to do this?

Rusty4508

check Best Answer

Jairus K.

check Best Answer

Couple ways you can try to fix this, select all the columns and/or rows outside of the area your data exists, then right-click and delete rows/columns. If it's just static data that dosn't reach across tabs, it may be easier to just highlight the data, copy and paste to a new tab. Then delete the old tab.

Hope this helps.

View Best Answer in replies below

9 Replies

check Best Answer

Couple ways you can try to fix this, select all the columns and/or rows outside of the area your data exists, then right-click and delete rows/columns. If it's just static data that dosn't reach across tabs, it may be easier to just highlight the data, copy and paste to a new tab. Then delete the old tab.

Hope this helps.
Kimberlin

This person is a verified professional.

datil

i agree with Jknud probably copy and paste the data into a new tab/worksheet then resave would be the easiest. the file size on those files are probably way bloated as well.
When trying to delete the rows, because it is thousands & thousands of rows & columns, it reaches the maximum & gets an error.
I tried the excess one & it didn't work. They have a BUNCH of formatting, so I wanted to avoid copying & pasting - oh well.
Kimberlin

This person is a verified professional.

datil

there is another add in called ASAP utilities. I use it all the time and is great for excel. once installed look under the ASAP tab, then columns and rows and remove all empty rows, remove all empty columns. it also has a lot more to offer.

http://www.asap-utilities.com/
NoITForYou

This person is a verified professional.

habanero

Kimberlin wrote:

there is another add in called ASAP utilities. I use it all the time and is great for excel. once installed look under the ASAP tab, then columns and rows and remove all empty rows, remove all empty columns. it also has a lot more to offer.

http://www.asap-utilities.com/

asap-utilities is awesome. The CFO at my last job would slit her wrists if that program went away.
Jasonstanley - thank you for the link - worked perfectly - reduced my file from 6Mb to 300K... Cheers.

Read these next...

Snap! MSFT's SUG, CommonSpirit Health cyberattack, Cyber Expo, RTX 4080, etc.
Spiceworks Originals
Your daily dose of tech news, in brief. While I believe the first commercial cellular network was launched in 1979 by Nippon Telegraph and Telephone (NTT), on October 13, 1983, the first commercial wireless phone call was made (in the U.S.). It was...
Misc go-to FOSS options
Linux
I've been wondering about others' preferences on a few things. The landscape of operating systems and databases has changed a bit in the last few years. Not curious about Windows or MSSQL, nothing new there.Server OS: I've bounched back and forth with Cen...
Education path for Cyber Security
IT & Tech Careers
Hi All,I have a high school aged son who is very interested in learning cyber security and has a desire to go into that field as a career. I have looked a different topics on Spiceworks about it and some are over a year old so I thought a refresh would b...
Spark! Pro series - 13th October 2022
Spiceworks Originals
Today in History: 1792 White House cornerstone laid The cornerstone is laid for a presidential residence in the newly designated capital city of Washington, D.C. In 1800, President John Adams became the first president to reside in the executive ma...
Prevent user from login to servers
Windows
I have one user in particular that loves to logon to the server to run reports he is not a member of any admin groups he is only a users. Is it posible to enforce a way where hi is only allow To log in to one computer only, let's say, his workstation.