Futile Crush
New Member
- Joined
- Oct 3, 2009
- Messages
- 45
Hey guys, I'm in a bit of a pickle with Excel. I made the dear mistake of succeeding in using the TRANSPOSE function, just to copy 10 rows which I easily could have typed out. But then, I wanted to insert a column, it wouldn't let me, so I decided to take the latter columns out of the equation and reselect the new range (excluding the columns I want to shift out of the way), but trouble came up. It wouldn't let me do this, saying that I can't change an array. So, I tried to get out of it, and I couldn't. I deleted the formula then pressed Ctrl+Shift+Enter and it didn't work, I retyped the formula, then limited the range, it didn't work. I even tried saving it so I could close it and reopen it but THAT didn't work either. The most annoying thing is, I can't even CLOSE excel. It prevents me from quitting. The only other solution would be to turn my computer off or log off, but I'd then lose the work I'd already done on there.
Can anyone help me?![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Can anyone help me?