Microsoft-Office

How to use the RANDBETWEEN Function in Excel

The Excel RANDBETWEEN function is very popular function which is located in Math & Trig category. Microsoft Excel RANDBETWEEN function is used to returns a random number between the number you specify. This function returns a random number which is between a bottom and top range. The RANDBETWEEN function in Excel returns a unique random number every time when your spreadsheet recalculates with the help of F9 key. Read More

How to replace across multiple worksheets or entire workbook

You can easily find and replace any character, word or any cell contents in active worksheet. Sometime most of the excel users have to face problem to replace the data in whole workbook. Now this article helps you to quickly replace across multiple worksheets or entire workbook. Excel is an important utility application software which is used to solve different complex problem. Read More

Lock or Unlock particular areas of a protect worksheet in Excel

Excel is an important application software which is widely used around the world. There are lot of interesting features of Microsoft Excel. When you try to lock your worksheet it effect on whole worksheet at the place of particular area. This guide helps you to easily lock or unlock particular areas of a protect worksheet in Excel. By default all cells are automatically locked when you apply protection password on active worksheet. Read More

Quick way to delete blank cells using sort command in Excel

Hi Guys, during working on large worksheet we have to face lot of blank cells in Microsoft Excel. If you want to delete blank cells one by one then it will take lot of time. We don’t have enough time during preparing few urgent reports. In that situation most of the users want to search a quick way to delete blank cells using sort command in Excel. Read More

How to set alignment of different shapes in Word

During working on active document in Microsoft Word, we need to use different shapes along with text. But it’s not easy to properly set all shapes or images properly in the document. When you try to set all shapes or images alignment is corrupt and looking is poor. So, in this article we have to discuss how to set alignment of different shapes in Word. Read More

How to find duplicates using conditional formatting in Excel

Conditional formatting is an important feature of Excel. You can easily find duplicates using conditional formatting in Excel. With the help of conditional formatting you can easily prepare different patterns, trends on your data using icons, bars which highlight most important data. Most of the person aware with the conditional formatting feature in Excel.  Read More

VLookup to find first few characters in Excel

All we know VLookup function play an important role in MS Excel. It is used to search any specific value in the selected range of cells. Sometime we need to lookup few characters of one column to another. This guide helps you how to use VLookup to find first few characters in Excel. Read More

2 Ways to Fill blank cells with 0 or any specific value in Excel

Sometime when you are working with a large worksheet in which you have lot of blank cells and you want to now quick way to fill blank cells with 0 or any specific value in Microsoft Excel. If you fill manually 0 or any other specific value in blank cells it will consume lot of time. In this article I’ll tell you two quick ways to fill blank cells with 0 or any specific value in Excel. Read More

How to copy and paste only non-blank cells in MS Excel

Lot of time we need to copy selected range of cells along with blank cells and paste them to filled cells. At that time all data is overwrite with blank cells. At this situation you must need to know how to copy and paste only non-blank cells in MS Excel. This article helps you to quickly copy and paste only non-blank cells in MS Excel with few simple steps. Read More