Hello friends , one of my viewer Requested me to solve this Error. Here i gave you a explanation about #DIV/0! error from microsoft page. What is #DIV/0! error in excel ? Excel displays the #DIV/0! error when a number is divided either by zero (0) or by a cell that contains no value. Symptom Excel displays the #DIV/0! error in... Read More »
Hi Friends, after a little break of heavy work i come back to update my blog again. today will check how to insert formula's in blank rows & columns in between of large data. This will help to complete your task quickly with single minute. lets go inside the How to's. These are the simple steps to insert formulas in... Read More »
Make easy and quick navigation by using this keys in your excel Previous sheet CTRL + Page Up Next sheet CTRL + Page Down Launch GO TO Dialog (from here you can select special or jump to a cell or range) F5 Go to top left (will go to top left of freezed pane if set) CTRL + Home Go... Read More »
Use this shortcut keys for Selection in your Excel. Select the whole column CTRL + SPACE Select the whole row SHIFT + SPACE Select table SHIFT + CTRL + SPACE bar Save CTRL + s Select visible cells only ALT + ; Select entire region CTRL + A Select range from start cell to far left SHIFT + Home... Read More »
Here some useful tips to copy and paste images in your excel sheet. 1. Click on the image Right Click => copy => paste in next cell. 2. Use Keyboard shortcut keys Ctrl + C for (copy) Ctrl + V for (paste) 3. Click on the image hold Ctrl + Drag with mouse. ... Read More »
Learning excel is very interesting for me.everyday i must try to learn something new in excel. Try this simple trick in your excel file to impress your boss. Here learn how to insert image into comment box in your excel data sheet.i used for this trick chandoo's the legend in Microsoft Excel's New podcast image to insert in comment box.you... Read More »