Select other rows except for the first ten rows, to select quickly first select the 11 th row.
![how to sum a column in excel 2003 how to sum a column in excel 2003](https://d13ot9o61jdzpp.cloudfront.net/images/3d_sumif_1.png)
First, we will hide rows, and then we will hide columns. Because when we work data, we need to navigate through these rows and columns, so it is important to learn about these rows and columns’ navigation.įor example, assume we need to show only 10 rows and 10 columns, so by hiding other rows, we can show minimal rows and columns. When it comes to excelling worksheet, our productivity and efficiency are decided by how well we work with rows and columns of excel. Example #2 – Traveling with Rows & Columns
#HOW TO SUM A COLUMN IN EXCEL 2003 HOW TO#
So, the column header “XFD” is the last column in the worksheet.Īnyway, we have got to know how many rows are there and how many columns are there, now we need to look at how to travel with these rows and columns in excel. (we can change the column heading to numbers as well). We can say by looking at the row number, this is the last row, but when it comes to columns, this isn’t straight forward because of alphabetical headings.read more, we have numerical headers like 1, 2, 3, and with regards to columns, we have alphabetic headers like A, B, C. To hide or reveal row and column headers, press ALT + W + V + H. For row headers Row Headers Excel Row Header is the grey column on the left side of column 1 in the worksheet that contains the numbers (1, 2, 3, etc.). When it comes to rows & columns in excel for both of them, we have headers.But with Excel 2003 version, we have only 65000 rows & 255 columns, so in this data craven world, this is never going to be enough.
![how to sum a column in excel 2003 how to sum a column in excel 2003](https://mtrapnell.files.wordpress.com/2010/03/blog_m_pivot_11.png)
You can download this How Many Rows and Columns Excel Template here – How Many Rows and Columns Excel Template Example #1 – Rows & Columns in Excel