Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 199
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
putting 2 long columns into multiple columns in excel page and sor bob_mhc Excel Discussion (Misc queries) 1 April 25th 08 07:51 AM
Excel 2003 - change columns to rows and rows to columns Trish Excel Discussion (Misc queries) 0 August 17th 07 02:22 AM
Excel 2003 - change columns to rows and rows to columns JLatham Excel Discussion (Misc queries) 0 August 17th 07 02:05 AM
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
unable to insert columns in excel, insert- columns (disabled) iam_leearner Excel Discussion (Misc queries) 1 August 13th 06 02:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"