How many rows and Columns are there in Excel 2003?

Excel worksheet consists of rows and columns.

Rows run horizontally and are identified by numbers (1, 2, 3, 4, …).

How many rows and Columns are there in Excel 2003?

Columns run horizontally and are identified by letters (A, B, C, D, …).

How many rows and Columns are there in Excel 2003?

The intersection of a column and row is called a cell. The cell is identified by the row number and column header, for example, B3.

How many rows and Columns are there in Excel 2003?

Number of columns and rows in one sheet

Depending on the Excel version you use, there is a different number of rows and columns.

Excel 2003

In Excel 2003 there are 65,536 rows and 256 columns (IV).

Excel 2007 and newer

Since Excel 2007 the number of rows and columns is much bigger than before. This time there are 1,048,576 rows and 16,384 columns (XFD).

Therefore the last cell is XFD1048576.

Determining the column number

To know the number of rows is easy, but it’s much more complicated with the column header. How you can quickly determine what is the header for the column 2000?

You can use the following formula.

=LEFT(ADDRESS(ROW(),A2,2),FIND("$",ADDRESS(ROW(),A2,2),1)-1)

=LEFT(ADDRESS(ROW(),A2,2),FIND("$",ADDRESS(ROW(),A2,2),1)-1)

Just enter it to a cell and type the number into cell A2.

The column header for the 2000th column is BXX.

How many rows and Columns are there in Excel 2003?

If you want to know more about other ways to get column header, read an article about this subject.

Moving one cell at a time

To move one cell left, right, up or down you can use keyboard arrows.

You can also use:

Enter – move down

Tab – move right

Shift + Enter – move up

Shift + Tab – move left

Moving to the first/last column/row

To move to the last column, use Ctrl + right arrow.

How many rows and Columns are there in Excel 2003?

To move to the last cell, use Ctrl + down arrow.

How many rows and Columns are there in Excel 2003?

It only works if you don’t have any cell in your way, otherwise, it will stop on the last cell in this area. In this case, you have to use the keyboard shortcut one more time.

In the following example, I selected cell A2. Now I press Ctrl + right arrow and the cursor stops at C2. I press one more time and it stops at E2.

How many rows and Columns are there in Excel 2003?

Use the keyboard shortcut one more time. This time it will go to the last column.

How many rows and Columns are there in Excel 2003?

This topic explains how to work around the Excel 2003 row limitation when you export paginated reports to Excel. The workaround is for a report that contains only a table.

Excel 2003 supports a maximum of 65,536 rows per worksheet. You can work around this limitation by forcing an explicit page break after a certain number of rows. The Excel renderer creates a new worksheet for each explicit page break.

To create an explicit page break

  1. Open the report in SQL Server Data Tools - Business Intelligence or the Reporting Services web portal.

  2. Right click the Data row in the table, and then click Add Group > Parent Group to add an outer table group.

    How many rows and Columns are there in Excel 2003?

  3. Enter the following formula in the Group by expression box, and then click OK to add the parent group.

    =Int((RowNumber(Nothing)-1)/65000)

    The formula assigns a number to each set of 65000 rows in the dataset. When a page break is defined for the group, the expression results in a page break every 65000 rows.

    Adding the outer table group adds a group column to the report.

  4. Delete the group column by right-clicking on the column header, clicking Delete Columns, selecting Delete columns only, and then click OK.

    How many rows and Columns are there in Excel 2003?

  5. Right click Group 1 in the Row Groups section, and then click Group Properties.

    How many rows and Columns are there in Excel 2003?

  6. On the Sorting page of the Group Properties dialog box, select the default sorting option and click Delete.

    How many rows and Columns are there in Excel 2003?

  7. On the Page Breaks page, click Between each instance of a group and then click OK.

    How many rows and Columns are there in Excel 2003?

  8. Save the report. When you export it to Excel, it exports to multiple worksheets and each worksheet contains a maximum of 65000 rows.