Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

Home » Microsoft Excel

Category: Microsoft Excel

Microsoft Excel (Office 360) is a spreadsheet application software. It is used to calculate numeric data, store, share..DigiRuns

How to Change Cell Color Based on Value in Excel

Posted on 20/06/202102/01/2022 by DigiRuns

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

Posted on 19/06/202103/01/2022 by DigiRuns

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

Posted on 19/06/202103/01/2022 by DigiRuns

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

Posted on 17/06/202117/04/2022 by DigiRuns

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

Posted on 16/06/202105/04/2022 by DigiRuns

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

Posted on 08/06/202104/01/2022 by DigiRuns

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 ms-excel)

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

Posted on 08/06/202118/04/2022 by DigiRuns

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

Posted on 30/05/202115/04/2022 by DigiRuns

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

Posted on 24/05/202105/01/2022 by DigiRuns

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

Posted on 23/05/202115/04/2022 by DigiRuns

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

Posted on 19/05/202101/01/2022 by DigiRuns

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

Posted on 13/05/202103/01/2022 by DigiRuns

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

Posted on 13/05/202103/01/2022 by DigiRuns

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

Posted on 12/05/202103/01/2022 by DigiRuns

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

Posted on 15/04/202116/04/2022 by DigiRuns

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​

Difference Between Functions and Formulas in Microsoft Excel

Posted on 01/07/201924/05/2022 by DigiRuns

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 MS-Excel

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

Posted on 10/12/201908/04/2022 by DigiRuns

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

Posted on 06/11/201917/01/2022 by DigiRuns

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

Posted on 27/09/201917/01/2022 by DigiRuns

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

Posted on 08/08/201920/02/2022 by DigiRuns

(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

Posted on 11/07/201903/01/2022 by DigiRuns

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

Posted on 08/06/201903/01/2022 by DigiRuns

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

Posted on 07/06/201908/04/2022 by DigiRuns

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

Posted on 09/04/201901/01/2022 by DigiRuns

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

Posted on 27/04/201905/04/2022 by DigiRuns

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

Posted on 29/04/201903/01/2022 by DigiRuns

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

Posted on 26/11/201821/02/2022 by DigiRuns

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

Posted on 23/10/201808/04/2022 by DigiRuns

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

Posted on 07/12/201801/05/2022 by DigiRuns

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 either by…

Read more

4 Ways to Rename a Worksheet in MS-Excel

Posted on 27/04/201905/01/2022 by DigiRuns

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

Posted on 30/04/201921/02/2022 by DigiRuns

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

Posted on 14/04/201901/01/2022 by DigiRuns

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

Row Height and Column Width in Excel – 2022’s Master

Posted on 24/04/201905/04/2022 by DigiRuns

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

Read more

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

Posted on 12/04/201912/01/2022 by DigiRuns

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

Posted on 12/04/201901/01/2022 by DigiRuns

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

Posted on 29/06/201901/01/2022 by DigiRuns

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

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

Posted on 20/08/202021/04/2022 by DigiRuns

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. It is an online source. To insert it, 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

Posted on 26/05/202122/04/2022 by DigiRuns

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

Recent Posts

  • A Table Generator for Word and Office 360 – 2022’s Trick
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • How to Print a Word Document and Ppt Slides – 2022’s Master
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Select Objects That are Behind Text in Word – 2022
  • How to Make a Transparent Text Box or Shape in Word