How Many Rows and Columns in Excel (2003, 2007, 2010, 2016)
This is the common question you can expect in an interview that requires excel skills. Not many of us not even looked at the last row or last column in a worksheet. This could be because we have never faced the situation where we have needed to go to the last row or last column. But is important to be aware of these things. Not only last row or last column when we work with data actual last row or column will not be the end of the actual row or column but it is the end of the data row or column. So, in this article, we will show you how many rows and columns in Excel?
Example #1 – Rows & Columns in Excel
- From Excel 2007 onwards (2010, 2016, etc) we have exactly 10,48,576 rows and 16,384 columns.
- 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.
- When it comes to rows & columns in excel for both of them we have headers. For row headers, we have numerical headers like 1, 2, 3 and with regards to columns, we have alphabetic headers like A, B, C.
- 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. (we can change the column heading to numbers as well). So, column header “XFD” is the last column in the worksheet.
Anyway, 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.
Example #2 – Traveling with Rows & Columns
When it comes to excelling worksheet our productivity and efficiency are decided by how well we work with rows and columns of excel. 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.
When the worksheet is empty it is easy to go to the last row and last column of the worksheet. For an example look at the below screenshot of the worksheet.
In this worksheet active cell is A1, from this cell if we want to go the last row of the worksheet we need to scroll down keys rather we need to press the shortcut key “Ctrl + Down Arrow” to go the last row in the worksheet.
Similarly, if you want to travel to the last column of the worksheet we need to press the shortcut key “Ctrl + Right Arrow”.
Example #3 – Show Minimal Number of Rows & Columns to Users
Often times we don’t use all the rows and columns so we may want to restrict the user’s action to minimal rows and columns.
For example assume we need to show only 10 rows and 10 columns, so by hiding other rows we can show minimal rows and columns. First, we will hide rows and then we will hide columns.
Select other rows except for the first ten rows, to select quickly first select the 11th row.
After selecting the 11th rows press the shortcut key “Ctrl + Shift + Down Arrow”, it will selectin all the remaining rows which are below.
Right-click on row header and choose “Hide” or you can press the shortcut key “Ctrl + 9” and it will hide all the selected rows.
Now user can access only 10 rows but all the 16k + columns, similar select all the columns except the first 10 columns.
Now right click on the column header and choose “Hide” or press the shortcut key “Ctrl + 0” to hide all the selected columns.
As you can see above they can access only ten rows and ten columns.
Example #4 – Restrict Users Action to Minimal Rows & Columns
If you follow hide method they can unhide rows and columns and access them, but using one more method we can restrict their action.
For example assume we need to limit the user action to the range of cells from A1 to G10, right-click on the worksheet and choose the “View Code” option.
This will open up the visual basic editor window.
Select the worksheet that you want to restrict the user action, in my case worksheet is “Data”, after selecting the worksheet press F4 key to open the properties window.
In the properties window, we have an option called “Scroll Range”, in this enter the range of cells that you want to give access to the users.
Now users can access only cells from A1 to G10.
Things to Remember
The number of rows and columns from Excel 2007 onward in 10,48,576 rows and 16,384 columns.
This has been a guide to How Many Rows and Columns in Excel. Here we’ll learn how to show the minimal number of rows & columns to users along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –