We can find the last column of excel by using the CTRL+RIGHT NAVIGATION ARROW KEY, or else we can use the horizontal scrollbars to go to the end of the column. We can find the last row of excel by using the keyboard shortcut key CTRL+DOWN NAVIGATION ARROW KEY, or else we can use the vertical scrollbars to go to the end of the row. In this example, we will see how to navigate rows and columns with the below examples. The column in excel ranges from A to XFD, which is highlighted in red mark. Rows in excel range from 1 to 1048576, which is highlighted in red mark In Microsoft Excel 2010 and the latest version, we have row numbers ranging from 1 to 1048576 in 1048576, whereas the column ranges from A to XFD in a total of 16384 columns which is shown in the below screenshot. In Excel, each column is named by its header, which shows the column header horizontally at the top of the excel sheet.which will be shown normally in all excel sheets, which are shown below. Whereas we can find the column in excel, which can be identified by the column header like A, B, C.As we can see in the above screenshot that each row can be identified by their row numbers like 1, 2, 3 etc.In excel, we can find each row by its row number, which is shown in the below screenshot, which shows vertical numbers on the left side of each sheet.Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |