Data literacy · Excel · ICT proficiency · Timesavers · Top tip · Working with Data

#195 Changing direction of the Enter key in Excel

This is a very quick tip that solves an irritating problem. If you are entering data in Excel that goes from left to right, rather than top to bottom (or any other direction for that matter), then you’ll want to change the direction that the Enter key sends your data.

By default Enter in Excel will send your cursor down to the box below, however, this is not always where you want it to be. To stop you faffing about with the arrow keys or your mouse, simply quickly change the direction that the Enter key sends your cursor.

Feature image: “Direction” by 23am.com licenced under CC BY 2.0

Advertisements

One thought on “#195 Changing direction of the Enter key in Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s