Formula Editing – small trick

It’s a small trick, might save some time for you. Often we need to select a part of cells in a big formula for operations like making absolute reference, deleting etc., and we keep selecting it with mouse cursor and end up selecting wrong cells or selecting nearby comma. it can be frustrating at times. Once attempting the same I discovered that if I click on that part of formula syntax which appear when I m trying to edit formula, that very part gets selected and I can perform the desired operations.

FE1

Advertisements

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