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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

Freezing the Upper, Left, or both parts of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes. Removing the freezing rows, columns, or both is called Unfreeze Panes. Why do we use Freeze (sticky or floating) Panes? For … Read more

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 … Read more

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 … Read more

Data validation is the application of a required restriction to a cell or a cell range. After doing so, if a user enters any restricted value into any cell of data, it will give a reminder-like message without accepting that value. Here, only unrestricted value can be accepted. Getting Started With Data Validation to Range … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

Difference Between Functions and Formulas: A function is a pre-defined operation, developed by Microsoft Corporation in an Excel application. The formula is similar to a simple calculation, which is defined according to the user’s need and desire. Difference Between Functions and formulas in Excel: S. No. Function Formula 1. It is a pre-defined (built-in) operation … Read more

Conditional Formatting in Excel is one of the best features to format or highlight cells (with different colours) that contain data. This feature will help us easily spot certain cells with data based on the condition we have given. The data in the cells may include Less than any number, Greater than any number, Equal … Read more

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 … Read more

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, … Read more

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, … Read more

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 … Read more

How to Insert New Worksheet In MS-Excel: In an excel spreadsheet, there are several options are there to insert the “New Worksheet”. These are whether the Keyboard shortcuts or other options from the ribbon. in this article, 6 different ways are provided below to insert a new worksheet in excel. Method-1: Click the New Sheet Tab Button: Click on … Read more

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 … Read more

There are several ways to duplicate a worksheet in excel using the shortcut keys or other commands in excel. To do so, learn all of the following methods. Copy or Duplicate a Worksheet in Excel: 1. Duplicate a worksheet by using move or copy: Right-click on any “Sheet tab” Then click “Move or Copy” (or … Read more

It is necessary to apply color and style to the borders/lines to a range of cells for certain categorized contents to make the content easy to identify and beautify. 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, … Read more

There are several ways to set the row height and the 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 … Read more

Combining two or more cells into a single cell is called merging cells. Similarly, division of a cell into multiple cells is called unmerged cells. Let’s see how to do them! 1. Merge & Center: Combining more cells into one cell and centring the text is called the Merge & Centre. Go to the Home tab Select … Read more

Clear Everything or part of content: Clear Formats:  Used to remove each and every format like text colour, size, and background color 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 … Read more

This gridline is used to boldly change the vertical and horizontal lines of cells in the block of the selected worksheet to view or print. 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, … Read more

Flash Fill in Excel is a unique and smart time saving tool. If you enter the data in the first row of the list in the left or right column with some modification you like and use the Flash Fill command, it fills in the list of data in the remaining column in seconds in … Read more