Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Microsoft 2007

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Microsoft 2007

Resolved · Low Priority · Version 2007

Reply Tue 17 Feb 2009, 15:23Delegate Raymond said...

Raymond has attended:
Excel VBA Advanced course

Microsoft 2007

I believe Excel 2007 can have more than the 66k rows allowed per sheet in 2003. Is there a limit to the 2007 number?

For upcoming training course dates see: Pricing & availability

Reply Tue 17 Feb 2009, 16:12 Edited on Tue 17 Feb 2009, 16:22Trainer Carlos said...

RE: Microsoft 2007

Hi Raymond

The Microsoft Office Excel 2007 grid is made up of 1,048,576 rows by 16,384 columns.

The columns now end at XFD instead of IV.

Hope this helps

Carlos

Excel articles

· Never Lose It In Translation With Excel
· How To Pick The Best Chart Type In Excel
· Why Excel Has More Cloud Coverage
· Why Should I Learn Visual Basic in Excel?
· The Mysteries Of Excel Explained

Please browse our web site to find out more about
advanced excel training and other Microsoft training courses.

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips