ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How many columns in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/218553-how-many-columns-excel.html)

Betty Pratt

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

Thanks


Victor Delta[_2_]

How many columns in Excel?
 
"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


Gord Dibben

How many columns in Excel?
 
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



Elkar

How many columns in Excel?
 
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




All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com