Now right click on the column header and choose “Hide” or press the shortcut key “Ctrl + 0” to hide all the selected columns.Īs you can see above, they can access only ten rows and ten columns.Įxample #4 – Restrict Users Action to Minimal Rows & Columns.

Similarly, select all the columns except the first 10 columns.

Now users can access only 10 rows, but all the 16k + columns.

Right-click on the row header and choose “Hide”, or you can press the shortcut key “Ctrl + 9”, and it will hide all the selected rows.

After selecting the 11th rows, press the shortcut key “Ctrl + Shift + Down Arrow” it will selectin all the remaining rows, which are below.

Select other rows except for the first ten rows, to select quickly first select the 11 th row.

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

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.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

How do i hide columns in excel 2007