answersLogoWhite

0

Use 'COUNTA' function.

for example: if you want to know the last cell of column B, use the formula below

=COUNTA(B:B)

It'll give you the cell reference

If you want to know the value then use formula below

=INDIRECT("B"&COUNTA(B:B))

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

What is the refernce name of the last cell in the first row in excel 2007?

XFD1 is the cell reference at the end of the first row in Excel. Column XFD is the 16384th column.


How do you insert rows in Excel 2007 past IV?

Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.


What is the last cell of Excel?

In Excel 2007, I got XFD1048576. In Excel 2003, I got IV65536. In Excel 2002, I got IV65536. NOTE: You can open MS Excel, click a cell, then press Ctrl + Right arrow, Ctrl + Down arrow to get the result.


What is the last column letter in Excel 2010?

That depends on the version. Up to version 2003, it was row 65,536. From Excel 2007 onwards, it is row 1,048,576.


Why IZ10 is invalid cell address?

IZ10 would be an invalid address in version 2003 of Excel and earlier versions. The last column in Excel 2003 is column IV, so there is no column IZ. In versions from Excel 2007 onwards, IZ10 would be a valid cell address.


What is the cell address of the last cell of the Microsoft Excel 2003?

The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.


Where do the column headings begin and end in Excel?

Column headings start at A. After reaching Z, the next is AA, then AB and so on. What the last column is will depend on the version of Excel that you have. Column IV, which is the 256th column, is in the versions up to Excel 2003. From Excel 2007 there are 16,384 columns and last one is column XFD.


Which is the last column in a spreadsheet?

In Excel 2003 and earlier, there are 256 columns, so the last column is IV. From Excel 2007 onwards, there are 16,384 columns, so the last column is XFD.


What is latest column of Excel 2010?

The last column is column XFD which is the 16,384th column.


In word Excel 2007 what are the last three letters of the columns?

XFD is the column label on the last column in a Microsoft Excel 2007 worksheet.


What are the Letters in the last column in Microsoft Excel?

In Microsoft Excel, the letters in the last column are represented by combinations of the letters A to Z. Once you reach the letter Z in the column headers, the next column will be labeled AA, AB, AC, and so on. This pattern continues with BA, BB, BC, and so forth, allowing for a virtually unlimited number of columns in Excel.


What is the easiest way to create a sum of all the numbers in a column in Excel?

By using the Autosum feature. Select the cell below the last number and click on the Autosum and it will automatically total the numbers in the column.

Trending Questions
How many gigabytes are available on a PC? can you unlock Trixy on subway surfers Trixy on subway surfers? What do we call the image which pops up on the screen whenever the computer remains idle for a short time? What does the term VGA mean sexually? Cmos setup allows a technician to change configuration settings on a motherboard stored in what? If you have multiple partitions on a hard drive will deleting a partition delete the operating system in it? When signals come into the soma from the many dendrites they are added together When the sum of these signals reaches a critical point a signal is fired down the axon When it reaches the end of th? When used to refer to a poetic technique the word catalog refers to? What is the small pin-sized hole on the front of the CD drive? How is Dell's marketing strategy different from HP in the Southeast Asia market? Where can you find anime desktop icons? What is halfway point between clayton county Ga and Dekalb county Ga? How do you get more loops for pro tools se? Why can you not simply leave Windows Firewall off when you deploy an actual web server? What is another name for a hard drive? How Does getting a better WiFi router increase internet speed? How long can a computer survive with its fan blocked up? Why when I try to sync music from itunes to my iPod from a new computer does it tell me all my music on my iPod will be erased? What are the disadvantage of computers with their possible solutions? How do you install windows 64bit on PC running with window 32bit with core 2 duo 8600 CPU?