Sat 27 May 2017

Excel Quiz 52

By |Saturday, May 27th, 2017|Categories: Quizzes|Tags: , , , , , , , , , , |0 Comments

Excel Quiz 52 - A Quiz on Formulas Tab in Excel

This quiz checks your knowledge about Formulas tab.

Sat 01 Oct 2016

Tips & Tricks 146 - When I input a number, Excel automatically inserts a decimal with 2 decimal points

By |Saturday, October 01st, 2016|Categories: Tips and Tricks|Tags: , , , , |0 Comments

Sometimes, you might face a problem that you input a number say 567 and it automatically becomes 5.67. If you enter 8, it becomes 0.08.

To correct this problem > File > Options > Advanced and uncheck Red Zone

1

Sat 17 Oct 2015

Tips & Tricks 113 - Drag and Drop a Picture in Excel Sheet

By |Saturday, October 17th, 2015|Categories: Tips and Tricks|Tags: , , , , , , , , |0 Comments

Try dragging and dropping a picture in a worksheet - What happens. You will notice a plug sign which means that a picture will be added. But when you release the cursor to drop the picture in Excel sheet nothing happens.

Reason - Excel doesn't support dragging and dropping the picture in a worksheet.

Now, what to do. If you are dealing with too many pictures, it is cumbersome to use Insert > Picture command.

Fortunately, there is a work around in place. Microsoft Word supports dragging and dropping of pictures. Also good thing is that, you can select all your pictures in one go and drop in Word document.

Now, you can either drag and drop the pictures from the Word document in Excel sheet or you can cut/copy and paste from Word to Excel sheet.

Side Note - OpenOffice / Libre Office supports drag and drop to their respective spreadsheet programs. (Note, but you can not drag or copy and paste pictures into Excel from Open Office / Libre Office spreadhseets like you can drag or copy / paste from Word)

Sat 05 Sep 2015

Excel Quiz 20 - Excel Interface Quiz - Part I

By |Saturday, September 05th, 2015|Categories: Quizzes|Tags: , , , , , , , , , , , |0 Comments

Excel Quiz 20 – Excel Interface Quiz – Part I

Quiz about Excel interfaces like menu, ribbons etc.