Start from Home

Does it irritate you to open and see an excel file with active cell not at the first cell or top left corner and then you have to scroll every worksheet to see it from start or It might simply annoy your boss to open an excel file sent by you with active cell not in top left.

CTRL + HOME is short cut key to take to the top left corner and CTRL + PAGE UP is the short key that takes you to worksheet on left.

So if you start with the last worksheet of excel file keeping CTRL button pressed, start pressing HOME  and PAGE UP alternatively.

After doing this you will end up at the first worksheet of your excel file with active cell at top left of every worksheet.

For that matter, it can be an excel best practice to save every file with active cell at top left.

CIAO!

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