Excel guru Rob van Gelder asks a question which I will paraphrase: What Excel feature is at the top of your wish list? I’m sure everyone has something to say about this, so limit your comment to the one (or two) feature(s) that are at the top of the list.
At the top of Rob’s list is blinking cell’s (just kidding). As for me, my knee jerk reaction is more rows and columns. But when I have to pick just one, I’m not sure if that’s the most important. I definitely find myself needing more columns more often that more rows, but I can’t say that I hit this limit so often that it really bothers me. Most of the spreadsheets where more columns would have been handy are already written with appropriate workarounds. I don’t gnash my teeth every time I use them, just when I have to redesign them.
I would really like to see flexible rows and columns. Limit me to 17 million cells if you like, just let me determine how many rows and columns for each worksheet. One row with 17 million columns, one column with 17 million rows, or anything in between. That sounds pretty reasonable to me, but I can’t even spell C, much less program in it so I don’t know if it’s even feasible.
In VBA, there are two things that come to mind immediately: The ability to create all the commandbar control types that exist; and a real before close event. There’s only a handful of commandbar controls that are creatable in VBA, but I want them all. And anyone whose been bitten by the BeforeClose event on an unsaved workbook knows what I’m talking about there.
I should stick with my first instinct, so I’m going with more rows and columns. It sure would be nice to have, say, three columns for every day of the year plus a couple of extra. Now it’s your turn. What feature would you like to see?