CELL Function

How to Split Sheets into Separate Workbooks in Excel (4 Methods)

When you have a larger dataset covering numerous working sheets, you may need to split those worksheets into dedicated workbooks for analyzing ...

How to Hyperlink to Cell in Same Sheet in Excel (5 Methods)

We’re going to show you 5 methods in Excel to create a Hyperlink to a cell in the same sheet. To demonstrate our methods, we’ve taken a dataset with ...

How to Find Excel Sheet Name Using Formula (3 Examples)

In a Microsoft Excel file usually, we get the sheet name from the bottom of each sheet. But there are other options to find sheet names. We will ...

How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

While working with large Microsoft Excel, sometimes we need to convert numbers to text. We can convert the numbers to text with 2 decimal places. We ...

How to Convert Number to Text and Keep Trailing Zeros in Excel (4 Ways)

While converting numbers to text in Excel, you will find that Excel removes the trailing zeros after the decimal point of a number. There is a simple ...

How to Highlight Active Row in Excel (3 Methods)

If your Excel dataset has a lot of columns, it becomes quite difficult to find data from one end to another end of a row. But if you generate a ...

How to Use Sheet Name Code in Excel (4 Applications)

In this article, we will learn how to use and get sheet name code to excel. In Microsoft Excel, we can use the sheet name directly in a formula as a ...

How to Get Excel Sheet Name (2 Methods)

This article illustrates 2 convenient ways to get the sheet name in Excel. The sheet name is a name property of the Worksheet Object in Excel. ...

Uses of CELL Color A1 in Excel (3 Examples)

Mainly CELL Color A1 (reference) is an info_type operation of the CELL function. In this article, we discuss the CELL color reference option and its ...

How to Use CELL Function in Excel (5 Easy Examples)

The CELL function is categorized under the information function in Excel. The CELL function returns information about the cell contents, formatting, ...

How to Highlight Selected Cells in Excel (5 Easy Ways)

Highlighting cells offers users to make entries stand out from the rest of the dataset and make sure entries get investigated. In this article, we ...

How to Use Excel Sheet Name From Cell Value (Three Ways)

In many cases, you may need to use an Excel sheet name from a particular cell value such as creating an excel sheet name from a cell value, referring ...

Excel Hyperlink to Another Sheet Based on Cell Value

In Microsoft Excel, there are several useful and quick methods to add or create a hyperlink to another sheet based on cell value. We can use ...

How to Create Dynamic Hyperlink in Excel (3 Methods)

Excel allows you to deal with links. Cases can be like hyperlink to cell, find links, deal broken links, and many more. Today we are going to show ...

Excel Search for Text in Range (11 Quick Methods)

In Microsoft Excel, there are numerous methods available to search for text in a range of cells or an array. You can search for a text value and ...

ExcelDemy
Logo