Auto motion in Excel?

Hanan Cohen writes:

A long time ago. in the 80's of the last century, I have used a spreadsheet program called Saturn on a DEC PDP/11 running RSTS-E. It had a wonderful feature which I can't find in Excel. It was called "auto motion". If you chose this feature, you could enter data in a cell, press any arrow key, enter the data in the next cell and when pressing Enter, the cursor would move to the next cell in the same direction of the first movement. You could enter data from the bottom to the top, right to left of any direction you chose. In Excel, you can either choose "top to bottom" or "left to right".

If you still have friends at the Excel team, tell them about this feature. It was wonderful and a "must have".

Ah, you're trying to trick me into recommending a feature that I don't approve of :)

Here's why I don't approve: it's confusing. Many people will see this behavior and they won't realize *why* the Enter key suddenly wants to go UP instead of DOWN. By then they may have forgotten that they previously pressed the up arrow.

It's important that things (especially the enter key) behave in the same way instead of getting into invisible modes. Nothing on the screen tells you why Enter is going up now, and you may just decide it's a bug and get frustrated. You'll get especially frustrated if you look away from the screen (at the piece of paper with all the numbers you are typing in) and type in a bunch of numbers, only to look back and find out that not only are they in the wrong cells, but you have accidentally overwritten something interesting you used to have there.

My new book is here! Apress has just published a new collection of 36 essays from Joel on Software, aptly named More Joel on Software. Get yours today! Available from Amazon.com or wherever fine cheese is sold.

About the Author: I’m your host, Joel Spolsky, a software developer in New York City. Since 2000, I've been writing about software development, management, business, and the Internet on this site. For my day job, I run Fog Creek Software, makers of FogBugz—the smart bug tracking software with the stupid name, and Fog Creek Copilot—the easiest way to provide remote tech support over the Internet, with nothing to install or configure.

Enter your email address to receive a (very occasional) email whenever I write a major new article. You can unsubscribe at any time, of course.