Fcking hate Excel. I keep using the INDIRECT command to reference another workbook but then the values will not update or will show #N/A when I close the other spreadsheet. Too bad I didn't notice that until I used that formula about 100 times in my workbook. ugh
I needed to take a few notes on my Galaxy Note9 (phone) last night to avoid going upstairs for a pen and paper. For once, I decided it was the kind of info that could be better arranged in a spreadsheet... pin numberings and wire colors across two devices with different numbers/colors, along with the actual function of each pin. I had never launched Excel on my phone even though Microsoft paid Samsung to include it, so I got through the initial nag screens and started putting in info. I got to the point where I needed to insert a new column and had not yet figured out how, so I selected the first column and began trying to figure out what unlabeled icon does what so I could insert a column to the left or right of the selected column. Literally the first thing I tapped sent me all the way down to something like cell 1,050,000. I think it was the auto-size or sort column button.
This is after I spend minutes scrolling up:
...no way to get back to my data without abusing the Find function or something.
Anyway, I quickly found that there was no easy way to scroll all the way back up. There was no scroll bar and manual scrolling kept pausing to load and took minutes to get from 1,050,000 to 1,040,000, which wasn't going to work since I was trying to get all the way back to 1. It essentially broke my simple spreadsheet by scrolling so far away from my data that I couldn't get back to it and it was literally a million times faster to make a new one and retype everything... which I did... in Google Sheets. You had your chance, Microsoft, and you blew it with a huge glitch within moments of starting. It's bad enough that mobile platforms force us to use condensed, unfamiliar, UIs with less labeling, but to complicate that with unrecoverable SCROLLING glitches is irredeemable.
Here was my final sheet when I was done in Google Sheets:
The Excel glitch happened after I barely had one column of colors done... literally reading them off a PCB from inside a Nintendo Entertainer System controller, since I am color-blind. The brown wire was the most confusing to me since I was trying to distinguish it from Red and wondering which was Green (neither), so I opened up an NES controller where I knew it was all labeled. This was to check the pinout and color scheme on a rare Japanese Famicom controller to see if it was the same (it is) before adapting it to an NES.