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
• 13,640 points
1,222 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 gaurav
• 22,040 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 gaurav
• 22,040 points
1,133 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 gaurav
• 22,040 points
1,658 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 gaurav
• 22,040 points
120 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 gaurav
• 22,040 points
176 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 gaurav
• 22,040 points
532 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 gaurav
• 22,040 points
140 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 gaurav
• 22,040 points
415 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 gaurav
• 22,040 points
851 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP