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 »

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

Many of our subscribers ask the 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 »

Using Total Formula in Excel – 2022

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 »
How to freeze panes (rows and columns) in ms-excel)

How to Freeze Panes in MS-Excel- 2022’s Secret

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. Remove freezing the rows, columns, or both is called Unfreeze Panes. In other words: For example, If the data in the […]

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 »
Data Validation in Excel

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 – 2021

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 »
Sum Function in Difference Between Functions and Formulas​

The Real Difference Between Functions and Formulas in Excel

Introduction to the main “Difference Between Functions and Formulas in Excel”: The function is a pre-defined operation that means it already exists and were developed by Microsoft Corporation as a part of an Excel Application. Whereas Formula is a user-defined operation that means it is like a general calculation doing by the wish of the […]

Read More »
Conditional Formatting in MS-Excel

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 »

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 & 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 »

Tricks to Minimize, Restore, Maximize, Close, Etc. – 2022

What is Minimize, Restore, Maximize, Close, Etc. Called? Minimize, Restore, Maximize, Close, Resize, and Move buttons are also called the Window Controller, Window Control Buttons, or Control Buttons. Some of these appear at the top right corner and some appear by right-clicking the title bar of any (Application) Window of a Chrome browser, Mozilla Firefox […]

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, & 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. Launching the Selection Pane in MS-Word We can launch the Selection Pane either by Inserting the Objects or directly going to the Layout tab. So, do either of the […]

Read More »

4 Ways to Rename a Worksheet in MS-Excel

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 […]

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. 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 […]

Read More »

Apply Borders to the Cells in MS-Excel

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 […]

Read More »

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

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 […]

Read More »

Clear Formats, Contents, Comments and Hyperlinks in Excel

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 […]

Read More »

View and Print Gridlines and Headings in Sheet Options-Excel

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 […]

Read More »

Inserting 3D Models Tools in Word, Excel, & Ppt- 2022

Recently, Microsoft Corporation released a new update i.e. 3D Model, it is a tool that has been added in Microsoft Office 2019, and Office 365. This is an online source. To insert this, an internet connection is necessary. 3D models can be rotated to look like real objects and can be viewed from all angles. […]

Read More »
Flash filling the list of names

How to Use Flash Fill in Excel – 2022’s Rich

The Flash Fill in Excel is a unique and intelligent tool that saves time. If you enter the first row of data from the list in the left or right column with some modification of your choice and use the flash fill command, it will fill the rest with the data in a fraction of […]

Read More »