Category: Microsoft Excel

It not only bases the values in the range of cells but also fills the color based on the values in each cell. To change cell color based on value in excel Method-1: Change Cell Color Based on Value in Excel Enter different number values in each cell of a range. Select the range of…

Accounting number formats are useful for monetary values that are related to money or currency. To change the numbers or range of cells to accounting format in excel, follow the steps below. Method -1: Apply Accounting Number Format in Excel: Select the number or range of cells that you want to change numbers an accounting…

Add zero before a number: What most people don’t know is that adding zero before a number. It is very easy to add zeros before any number. This is very important for accounting, dialling codes, and so on. Steps to Add Zeros Before a Number in Excel: First, select the range of cells that you…

Many of our subscribers ask a question “Excel is not Recognizing Numbers in Cells”. That is why we are giving you a wonderful solution as per their wish. If Excel does not recognize the cell, it gives a 0 result when using any function, or shows only the function instead of the result when calculating…

To use a total formula in excel, one must know the excel interface and basic knowledge over a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions. To return the total in excel, we have many formulas and functions. Total Formula and Function in Excel: To add numbers in…

A Draw tab in Word is used to draw different colored inks with Pen, Pencil, and Highlighter with different effects. Adding Draw Tab to the Ribbon If your ribbon doesn’t have a draw tab, then add the draw tab to it. To add “Draw” tab, click “File” menu and select “Options” to launch a dialogue…

Giving full, partial, or no permission to edit the content of the selected range in a worksheet and protecting the rest of the worksheet completely with a password is called Allow Edit Ranges. If you want to give a password for the entire worksheet and also give a password to a range of your choice…

Break down a sentence, or a line, or a group of words based on the delimiters and fill them into each cell of a column is called Split Text to Columns. Steps to Split Text to Columns in MS Excel: Select text that you want to split text to columns On the Data tab, in…

Skip Blanks or Skip Blank Cells means, for example, if you copy the cells with and without value in a range called A and apply it to range B which is filled with values, then the values will be overwritten and the blank cells will be skipped. Steps to Skip Blanks or Skip Blank Cells…

Transpose means changing the row data as column data, or vice versa. This option is a part of the paste special in Excel. Steps to Transpose Data: For example, suppose you have the following data which is related to students details. SN First Name Last Name Roll Number Class Section 1 Vadithe Omkar 54 X…

Paste link is copying the range of a workbook’s sheet (with or without text) and linking it to another worksheet of the same workbook or another workbook’s sheet. Doing so will automatically update the content in the pasted range when you update or enter the content in the copied range. Link Range of Cells Between…

There is a difference between count and counta in excel. A function called count counts all the numbers (only numeric data) in a range of the cells or in the selected cells, whereas a function called counta counts all the characters such as numbers, letters, and any other characters in a specified range of the…

Create a Custom AutoFill Series List in Excel Create a Custom AutoFill Series List in MS-Excel:  Do you often waste your time by listing product names, country names, state names, currency names, employee names, or your family names in an Excel worksheet?  So, the custom Autofill series is a solution for you to stop typing…

Page Break Preview shows the worksheet by separating it as pages that contain contents that are to be printed. Before going to take a printout of the worksheet area, you may check out which part of the worksheet is to be printed by dividing the number of pages in it. When you enable this option,…

How to Copy Text as Picture in Microsoft Excel: Copy Text as Picture in Microsoft Excel: This command is a great way to copy the content as shown on the screen or as shown when printed in a Bitmap or Picture Format. And you can paste it wherever you want in the Microsoft Office Excel,…

Introduction to MS Excel Introduction to MS Excel & User Interface to Excel: Excel is an electronic spreadsheet program, developed by Microsoft Corporation.  An Excel Spreadsheet is used to record, validate and analyze the numeric data for maintaining Payrolls, Selling and purchasing product orders, Progress Reports, family budgets, and more. These are calculated whether using…

There are several ways to change the worksheet tab colour by using the shortcut keys or other commands in excel. Changing the worksheet tabs colours helps us to understand the difference between the tabs of different works easily. So, follow one of the 5 methods you like or all. Method-1 to Change Worksheet Tab Color…

We can rename a worksheet to suit our needs. Renaming is useful to identify the sheet type. Below is how to change the sheet name in different ways. Method-1 to Rename a Worksheet in MS-Excel: Double-click the Sheet tab, and then type the name you want. Method-2 to Rename a Worksheet Tab in MS-Excel: Right…

There are several ways to duplicate a worksheet in excel using the shortcut keys or other commands in excel. So, learn all of the following methods. Method-1: Copy or Duplicate One Worksheet: Right click on any “Sheet tab” Then click “Move or Copy” (or drag and drop the sheet as explained above) Select the sheet that you…

To apply borders to the cells in Excel, you can select the Line Color or Line Style or Both you want for a different border format, or otherwise, leave it as it is if you wish to apply the default line styles and colors. On the Home tab, in the Font group, Chick the expand…

There are several ways to expand the Row Height and Column Width in Excel. By default, the size of a Row Height is 15.00 points whereas the Column Width is 8.43 points. However, we can expand the maximum height of a row is 409 Points whereas the maximum width of the column is 255 Points….

Merging cells is the process of combining more cells into one cell. Similarly, dividing a cell into multiple cells is called unmerge cells. 1. Merge & Center: Combining more cells into one cell and centring the text is called the Merge & Centre. Go to the Home tab Select the range of cells and enter the text…

Clear Formats: Used to remove each and every format like colour, size, and other from the selection in a worksheet. Clear All: Used to remove all content and formats in an Excel Worksheet. Clear Contents: Only removes contents in a Worksheet Clear Comments: Removes comment in a Worksheet. Clear Hyperlinks: Clears Hyperlinks from the selection in…

In this article, you can learn how to View and Print Gridlines and Headings in Excel. These options are especially useful when you print the worksheet using whether the gridlines and headings or not.  View Gridlines in Excel: View Gridline helps you see or remove the gridline in excel when you check or uncheck the…