Microsoft 2007

Resolved · Low Priority · Version 2007

Tue 17 Feb 2009, 15:23 Delegate 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?

Tue 17 Feb 2009, 16:12 Edited on Tue 17 Feb 2009, 16:22 Trainer 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 tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Microsoft 2007

Microsoft 2007

RE: Microsoft 2007

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010