Click Here to get Amazon Quiz Answers & Win Bose Speaker System

Paste-special

Fill Blank Cells in Excel With Value from Above

Sometime we have an worksheet in which more than one cells left blanks and you need to fill blank cells in Excel with value from above. After filling all the blank cells you can easily sort, filter apply formatting as per your need. In this tutorial you’ll learn a simple trick how to fill blank cells in Excel with value from above cells. Read More

How to link data between two or more workbook in Excel

Copying data from one workbook and paste to another workbook is an easy task. But copy and paste method doesn’t create a relationship between the source and target file data. You must have to know how could you link data between two or more workbook in Excel. You can easily establish, refresh, remove the link either between two or more workbook or worksheets as per your need. Read More

How to quickly convert positive number into negative number

There are billion of users who are working on the MS Excel on daily basis. Sometime you need to quickly change all positive number to negative numbers. In this guide we will discuss how to quickly convert positive number into negative number. Paste Special is an important feature of Excel. This feature allows you to quickly convert positive number into negative number. Read More