Excel Basics Archives - Page 145 of 177

How to Perform If Zero Leave Blank Formula in Excel (3 Methods)

Apr 12, 2023

In this article, we will discuss how to perform if zero leave blank formula in excel. Sometimes you are dealing with a worksheet that requires you to ...

How to Perform If Zero Leave Blank Formula in Excel (3 Methods)

How to Generate Moving Average in Excel Chart (4 Methods)

Feb 20, 2023

Moving average is a common term in time-series analysis to review previous data and predict the future. In this article, I’ll show the fundamental ...

How to Generate Moving Average in Excel Chart (4 Methods)

How to Convert Date to Number in Excel (4 Methods)

May 19, 2022

In many situations, we need to convert Date to Number in Excel to accomplish a calculation. Working with Date and Time values is one of the trickiest ...

How to Convert Date to Number in Excel (4 Methods)

How to Hide Columns in Excel (4 Simple Methods)

May 31, 2023

In some situations, you may want to hide one or more columns in an Excel worksheet. Obviously, Excel allows users to easily hide columns. You might ...

How to Hide Columns in Excel (4 Simple Methods)

Different Types of Lookup to Apply in Excel (8 Types)

Feb 9, 2023

Certainly, one of the frequent uses of Excel is looking up a value in a table or data range. Now, Excel contains a couple of dedicated lookup ...

Different Types of Lookup to Apply in Excel (8 Types)

How to Freeze Rows in Excel (6 Easy Methods)

Feb 19, 2023

In this article, we will discuss how to freeze rows in Excel. Often, we have to work with spreadsheets containing a larger number of rows and ...

How to Freeze Rows in Excel (6 Easy Methods)

How to Select Row in Excel If Cell Contains Specific Data (4 Ways)

Mar 23, 2023

Sometimes you may need to select an entire row based on any specific data in a cell of that row. You can do the task in multiple ways. In this ...

How to Select Row in Excel If Cell Contains Specific Data (4 Ways)

How to Lock Rows in Excel (6 Easy Methods)

Feb 7, 2023

When working with huge datasets in Excel, it is common to wish to lock some rows or columns. So we can see their contents while navigating to another ...

How to Lock Rows in Excel (6 Easy Methods)

How to Move Cells in Excel with Arrow Keys (6 Methods)

May 31, 2023

Sometimes while working on a large worksheet, we need to move cells in Excel to work faster and for the ease of working. We can move cells in Excel ...

How to Move Cells in Excel with Arrow Keys (6 Methods)

How to Copy a Cell in Excel Using Formula(7 Methods)

Mar 5, 2023

Copying a cell in Microsoft Excel is an important feature when we deal with different kinds of data. There are lots of ways to copy a cell value. ...

How to Copy a Cell in Excel Using Formula(7 Methods)

Fix: Excel Cannot Shift Nonblank Cells (4 Methods)

Feb 19, 2023

While working in Excel, sometimes we need to add or Shift a Row or Column in our Worksheet. When we insert a new Cell then it pushes the next cell up ...

Fix: Excel Cannot Shift Nonblank Cells (4 Methods)

If Cell is Blank Then Show 0 in Excel (4 Ways)

May 29, 2023

In Excel, if there is no data in any cell, it normally remains blank. But you can display 0 in the blank cells by following some techniques. In this ...

If Cell is Blank Then Show 0 in Excel (4 Ways)

How to Convert Timestamp to Date in Excel (2 Suitable Cases)

Feb 12, 2023

In short, a timestamp is a sequence of characters used to specify the date and time of a day. Of course, any specific time or event can be expressed ...

How to Convert Timestamp to Date in Excel (2 Suitable Cases)

How to Unhide Rows in Excel (8 Quick Ways)

Feb 27, 2023

On the off chance that there is data on our worksheet we don't have to see, we can hide those which we would rather not see. Then, when we want that ...

How to Unhide Rows in Excel (8 Quick Ways)

How to Use Excel EXACT Function (6 Suitable Examples)

May 22, 2023

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...