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. Show
Number of columns and rows in one sheetDepending on the Excel version you use, there is a different number of rows and columns. Excel 2003In Excel 2003 there are 65,536 rows and 256 columns (IV). Excel 2007 and newerSince 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 numberTo 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. 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. If you want to know more about other ways to get column header, read an article about this subject. Navigating Rows and ColumnsMoving one cell at a timeTo 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/rowTo move to the last column, use Ctrl + right arrow. To move to the last cell, use Ctrl + down arrow. 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. To help control the size of an Excel worksheet, you can limit the number of columns and rows that a worksheet displays. In this guide, we show you how to hide (and unhide) rows and columns in Excel 2019, Excel 2016, Excel 2013, and Excel for Microsoft 365, as well as how to limit access to rows and columns using Microsoft Visual Basic for Applications (VBA). Hide Rows and Columns in ExcelAn alternative method for restricting the work area of a worksheet is to hide sections of unused rows and columns; they'll stay hidden even after you close the document. Follow the steps below to hide the rows and columns outside the range A1:Z30.
Unhide Rows and Columns in ExcelWhen you want to view the data you hid, you can unhide the rows and columns at any time. Follow these steps to unhide the rows and columns you hid in the previous example.
Limit Access to Rows and Columns With VBAYou can use Microsoft Visual Basic for Applications (VBA) to temporarily limit the range of usable rows and columns in a worksheet. In this example, you'll change the properties of a worksheet to limit the number of available rows to 30 and the number of columns to 26. Changing the scroll area is a temporary measure; it resets each time the workbook is closed and reopened.
FAQ
|