CELL Function Archives

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

May 31, 2022 Excel Basics

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)

May 30, 2022 Excel Basics

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)

May 26, 2022 Excel Formulas

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)

Jun 27, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 23, 2022 Advanced Excel 2

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)

May 22, 2022 Excel Formulas

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)

May 22, 2022 Excel Formulas

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)

May 22, 2022 Excel Basics

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)

May 18, 2022 Excel Functions

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)

May 18, 2022 Excel Basics

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)

May 16, 2022 Excel Basics 1

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

May 14, 2022 Excel Formulas

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)

May 14, 2022 Excel Basics

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)

May 14, 2022 Excel Formulas

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