I am trying to find how many columns and rows are in Excel 2007 and am tired
of holding down the arrow keys.

Thanks

"Betty Pratt" wrote in message
...
I am trying to find how many columns and rows are in Excel 2007 and am
tired
of holding down the arrow keys.

According to http://visio.mvps.org/Excel_2007.htm "...the last cell in Excel
has gone from IV65536 to XFD1048576. That is going from 256 columns to
16,385 columns and from 65,536 rows to 1,048,576 rows.

V

Worksheet size 1,048,576 rows by 16,384 columns

Go to help and click on What's New to find a list of specifications.

BTW............in a new blank worksheet to go to last row, hit CTRL + End +
Down Arrow

CTRL + Home to back to A1


Gord Dibben MS Excel MVP


On Fri, 30 Jan 2009 16:28:01 -0800, Betty Pratt
wrote:

I am trying to find how many columns and rows are in Excel 2007 and am tired
of holding down the arrow keys.

Thanks

Actually, it is 16,384 columns. To quickly move to the last column, you can
press CTRL-<Right Arrow.

HTH
Elkar


"Victor Delta" wrote:

"Betty Pratt" wrote in message
...
I am trying to find how many columns and rows are in Excel 2007 and am
tired
of holding down the arrow keys.

According to http://visio.mvps.org/Excel_2007.htm "...the last cell in Excel
has gone from IV65536 to XFD1048576. That is going from 256 columns to
16,385 columns and from 65,536 rows to 1,048,576 rows.

V