Cell contents shifted in part of one column on their own?

Our take

If you’ve noticed a peculiar issue in your Excel 2016 sheet, where data in a specific column has shifted up two rows, you’re not alone. This type of anomaly can occur for various reasons, including accidental data manipulation, merging cells, or even software glitches. Given the size of your file, with over 60,000 rows, it’s understandable that such shifts might go unnoticed, especially in columns with many blank cells.

I have an old and large (60k+ rows across several sheets) Excel 97 sheet in which I just noticed something odd. In one column, about 23k rows down out of 48k, all the data in the cells shifted up two rows. The majority of the cells in this column are blank, so it was easy to miss and I don't know when it happened.

I'm not asking for how to fix it -- I don't know how much data was added to this column after the shift, so I can't just move everything back down in a clump. I'm going to have to move it all back down manually (luckily it's not critical data).

I'm just wondering how this might have happened. Does it sound like any known bugs? This is Excel 2016 btw yes I still use it. thanks...

submitted by /u/kreniigh
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#rows.com#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#large dataset processing#google sheets#Excel 97#Excel 2016#cell contents