Sat 15 Apr 2017

Downloads 14 - Excel Shortcuts Bible

By |Saturday, April 15th, 2017|Categories: Downloads|Tags: , , , , , , , |0 Comments

This is a mammoth work. Contains all short cut keys published by Microsoft and also all ALT keys which are not published by Microsoft.

Download it from Excel - Shortcuts Bible

Sat 23 Jul 2016

Tips & Tricks 141 - How to Disable Quick Analysis Tool in Excel 2013

By |Saturday, July 23rd, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , , , |0 Comments

In Excel 2013, we have a new feature called Quick Analysis Tool. If you select a range and press CTRL, you are presented with Quick Analysis Tool. It offers various commonly used functions which you can perform.

1

Few people don't like this. To disable it permanently -

File > Options > Uncheck the Red Zone

1

 

Sat 08 Aug 2015

Excel Quiz 18 - Excel Shortcuts Quiz - Part I

By |Saturday, August 08th, 2015|Categories: Quizzes|Tags: , , , , , , , |0 Comments

Excel Quiz 18 - Quiz on Excel Shortcuts

This is a quiz on shortcuts in Excel. We use shortcuts in Excel very often like CTRL+C for copy, CTRL+V for pasting etc. Let's test our knowledge of Excel shortcuts.

Sat 06 Jun 2015

Tips & Tricks 94 - Select Big Range Very Easily

By |Saturday, June 06th, 2015|Categories: Tips and Tricks|Tags: , , , , , |0 Comments

You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you.

Approach 1 - Put the range in Name Box and Press Enter

1

Approach 2

1. Press F5 (or CTRL+G)
2. Specify the range in Reference:
3. OK and you range is selected.

11