Excel: Stop arrow keys from doing weird stuff in chart wizard and elsewhere

Problem:

  • You are in an Excel cell, or you are in an input in the chart wizard.
  • You try to use the arrow keys to move around the text within a cell.
  • Unexpected stuff occurs. Particularly in the chart wizard, where you get a load of garbage inserted into your formula.

Solution:

Press F2!

Amazing. This has transformed my life.

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