•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Cells filled in without Auto-Fill, formulas, or AI--what did I misunderstand?I might just be dumb but I can't figure out what happened today. I'm working on a quarterly report where I use a downloaded .cvs file as the bones. I clean the data, insert columns needed, and in some of those columns, I put enter formulas, do the whole autofill thing, normal stuff, right? I've done this report several times. My report has over 2000 lines of data that I have to check manually because the formulas aren't perfect. It doesn't take super long, and after a day and a half, I've gotten through 1400 rows. The weird thing happened when I got to the 1400s. I noticed a row I hadn't gotten to had data in a column with no formula, correctly formatted and accurate. When I kept scrolling, the entire rest of the column was filled in correctly without me editing it. There was no formula to auto-fill, and I don't use Copilot AI. I didn't copy and paste anything, none of that. I hadn't looked at that part of the sheet yet. It's probably silly, but it kind of freaked me out. This spreadsheet isn't shared with anyone, I'm the only one with access. The initial report is just data that I then break into chunks and send to someone else for the next stage. Google only showed me Auto-Fill and Flash-Fill as explanations, and I didn't use either. I looked in the settings and couldn't find any permission that matched, and I don't know how to explain this besides ghosts, I guess. At the end of the day, it's less work for me, so I'll take it, but if anyone can kindly explain what I'm missing that makes this make sense, I would appreciate it! submitted by /u/gremlinwitchboi [link] [comments]
- Inserting cells in one sheet also impacts other cells in the fileHello sub, Sorry to bother but I have a bit of a headscratcher... One of my colleagues is working on an excel file that has a lot of information but very few complex formulas, no macros to speak of. Yesterday, she was inserting cells in "sheet 1" and cells were inserted in "sheet 2" in the same column. We went through the options menu and we didn't see anything suspect or obvious (other than recalculation turned off for some reason) This is really slowing down her workflow and I wish I could help her. Thank you in advance, RNP. submitted by /u/RandomNumberPlease [link] [comments]
- Insert row that once data from column A to W is filled in, it moves the row down? I saw something about adding a button to manually make it shift with developer insert. That would be ok, but it seems like its conflicting with the columns I have as drop down options.Using Excel desktop app version 2606 I'm self taught with excel, I'm trying to make a sheet for tracking jobs for work. I'm not even sure if this is possible as I've seen conflicting things online. Is it possible to lock my 7th row as a input field and when I complete all columns A to W it will shift the row down? I did make tables for some of the columns to have drop downs, maybe I'm over complicating things and stuff is conflicting. I was trying to have AI walk me through some options. one was inserting a table but its not letting me. In short the row of things I want tracked, A through W. Would greatly prefer if I could keep drop down options for some of them. Biggest thing I would love to have is the first row be empty until I fill all the fields of data out, then it shifts the row down. I have a column of a "setup date" that I will sort the list by, All I want is to be able to have a input field and not have to go to the bottom of the list to add stuff every time. https://preview.redd.it/anq0vxlfxoog1.png?width=2014&format=png&auto=webp&s=93af3fff9c5f5aa34f64b111f298c2cdcc778144 submitted by /u/Firealarmfriday88 [link] [comments]
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