Excel Reference To Current Cell

0 votes

How do I obtain a reference to the current cell?

For example, if I want to display the width of column A, I could use the following:

=CELL("width", A2)

However, I want the formula to be something like this:

=CELL("width", THIS_CELL)

Mar 23 in Database by Edureka
• 9,320 points
43 views

1 answer to this question.

0 votes

Create a formula with the name THIS CELL.
Select cell A1 in the current worksheet (this is critical!)

(Ctrl+F3) to open the Name Manager

To begin, select New...

In the Name: field, type "THIS CELL" (or just "THIS," as I prefer).

In the Refers to box, type the following formula:

=!A1

Make sure that cell A1 is chosen. The ActiveCell is used in this formula.

Select Workbook from the Scope drop-down menu.

Close the Name Manager by clicking OK.

=CELL("width",THIS CELL) 
answered Mar 25 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

Insert a value to a cell in excel using formula in another cell

Select the cell where the formula should ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
49 views
0 votes
1 answer

What is the Excel formula to countif text partially makes up a cell?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

answered Mar 30 in Database by Edureka
• 8,820 points
21 views
0 votes
1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

answered Mar 30 in Database by Edureka
• 8,820 points
29 views
0 votes
1 answer

How to Convert Excel Numeric Cell Value into Words

To translate numbers to words, create the ...READ MORE

answered Mar 31 in Database by Edureka
• 8,820 points
25 views
0 votes
0 answers
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
82 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
37 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
34 views
0 votes
1 answer
0 votes
1 answer

How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
101 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP