## How to Change Cell Color Based on Value in 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

## Ways to Apply Accounting Number Format in Excel – 2022

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

## How to Add Zeros Before a Number in Excel – 2022’s Best

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

## [Fixed] Excel is Not Recognizing Numbers in Cells – 2022

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

## How to Use Total Formula in Excel – 2022’s Secret

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

## The Draw tab in Word, Excel, and Ppt – 2022’s – Hidden

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

## How to Freeze Panes (Rows and Columns) in Excel – 2022

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

## How to Show or Hide Ink in Excel, Word, and Ppt

By default, you can’t use the show or hide ink option . To use the ink annotation you need to add the draw tab to the ribbon, or you can use it directly if your computer has touch screen. Ink Annotation in MS-Word, Excel PowerPoint is used to highlight the content or draw something you … Read more

## How to Allow Edit Ranges in Excel – 2022’s Priceless

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

## How to Split Text to Columns in Excel – 2022

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

## Apply Data Validation to Range of Cells in Excel – 21 Steal

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

## How to Skip Blank Cells in Excel – 2022’s Bonus

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

## How to Transpose Data in Excel -2022’s Effortless

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

## How to Use Paste Link in Excel – 2022’s Light

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

## Difference Between COUNT and COUNTA in Excel – 2022

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 in Microsoft Excel

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

## The Conditional Formatting in Excel | Advanced | 2022’s New

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

## How to Recover Unsaved Word Document, Workbook & Ppt 2022

Recover Unsaved Word Document, Workbook & Ppt: Did you lose your document or workbook which you not saved? So, don’t worry, here is a solution to Manage all your unsaved documents or excel workbooks by recovering necessary or deleting unnecessary files. To do so get started now. Getting Started with How to Recover Unsaved Files … Read more

## Create a Custom AutoFill Series List in Excel

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

## Multiple Choice Questions and Answers (MCQ & A) – MS Office

(Objective) MCQ – Multiple Choice Questions and Answers – MS Office This article on Objective-Multiple Choice Questions of MS-Office is useful for any interviews and competitive exams. Objective-(MCQ) Multiple Choice Questions – MS-Word (Office 360): Home, Insert, Design Layout, References, Mailings, Review, and View in MS Office Word, Excel, and PPT are called—- Tabs or … Read more

## What is Page Break Preview in MS Excel? – 2022

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

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

## Paste Special Shortcuts in Excel & Word {With Examples}- 22

The Paste special is a feature, used to paste the copied contents in a specific format. Using this feature, you can paste several formats like formulas, values, comments, data validation, number formats. Also, you can add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet. To use Paste … Read more

## Introduction to MS Excel & User Interface to MS 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 … Read more

## 6-Ways to Insert New Worksheet In Microsoft Excel

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

## Change Worksheet Tab Color in 5-Ways in MS-Excel

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

## File Menu Options in Microsoft Word, Excel and Ppt – 2022

File Menu Options in Microsoft Word The File Menu Options controls and accesses the file functions of the MS Office Products. Formally, a file menu handles the files by using various commands. The list of file menu commands is info, New, Open, Save, Save as, Print, Share, Export, Account, Share, options, and Close. What is an … Read more

## Page Setup in MS Word, Excel, Ppt – 2022’s Big

When you open a blank document in Microsoft Word, you can choose how you want the page to look by using the Page Setup option. The Page Setup in MS Word provides an easy way to adjust the margins, text direction, page orientation, and page size. You can also adjust the page orientation to print … Read more

## The Selection Pane in MS-Word, PPT, and Excel – 22’s Master

Selection Pane is one of the great ways to select, show, hide, rename and change the order of the objects in the word document, Excel worksheet, and PowerPoint. This will help you speed up the object related work on your document. Launching the Selection Pane in MS-Word We can launch the Selection Pane in 2 … Read more

## 4 Ways to Rename a Worksheet in MS-Excel

It is essential to rename the worksheet to suit our content. A name change is useful to identify different types of sheet. Below is explained how to change the sheet name in 4 different ways. Rename a Worksheet in MS-Excel: 1. Rename a sheet by double clicking the sheet tab: Double-click the Sheet tab, and … Read more

## 6-Ways to Duplicate a Worksheet in MS-Excel

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

## Apply Borders to the Cells in MS-Excel

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

## Tricks to Set Row Height and Column Width in Excel

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

## How to Merge or Unmerge Cells in MS-Excel – 2022

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