EDUCBA

Home Excel Excel Resources Excel Tips Excel Rows and Columns

Excel Rows and Columns

By Jeevan A YJeevan A Y

Rows and Column Example 3-4

Rows and Column in Excel (Table of Contents)

Introduction to Rows and Column in Excel

In Microsoft excel, if we open a new workbook, we can see that sheet will contain tables with light grey color. Basically excel is a tabular format which contains n number of rows and columns, where rows in excel will be in a horizontal line, and column in excel will be in a vertical line.

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

Rows and Column Example 1-1

  • As we can see in the above screenshot that each row can be identified by their row numbers like 1, 2, 3 etc.
  • Whereas we can find the column in excel, which can be identified by the column header like A, B, C. which will be shown normally in all excel sheets, which are shown below.

Rows and Column Example 1-2

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • In Excel, each column is named by its header, which shows the column header horizontally at the top of the excel sheet.

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.

Rows in excel range from 1 to 1048576, which is highlighted in red mark

Rows and Column Example 1-3

The column in excel ranges from A to XFD, which is highlighted in red mark.

Rows and Column Example 1-4

In this example, we will see how to navigate rows and columns with the below examples.

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.

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.

How to Select Rows and Column in excel?

In this example, we will learn how to select the rows and columns in excel.

You can download this Rows and Column Excel Template here – Rows and Column Excel Template

Rows and Column in Excel – Example#1

Normally, when we open a workbook, we can see that sheet contains tabular rows and columns where each row is specified by their row number and column specified by their column header.

Consider the below example, which has some data in an excel sheet. Here we will see how to select the rows and columns.

Rows and Column Example 2-1

In the above screenshot, we can see that names and age column have their own header name A and B, and each row has its own row number.

In excel, each time when we select a row or column, “Name Box” will display the specific row number and column name, which is shown in the below screenshot.

Rows and Column Example 2-2

In this example, we will select the Names and Age, and let’s see how the rows and column header is getting displayed.

Step 1 – First, select the cell Name John.

Step 2 – Once you select the cell name, John, we will get the row number and column name as A2 in the name box, which means that we have selected A column second row as A2, shown below screenshot with yellow highlighted.

Rows and Column Example 2-3

Step 3 – Now select cell 23, where it will show the selected cell is B2 which is shown in the below screenshot with yellow highlighted.

Rows and Column Example 2-4

Step 4 – Now select all the names and columns to show that we have 4 rows and 2 columns shown in the below screenshot.

Rows and Column Example 2-5

In this way, we can identify the row number and column name by selecting each cell in excel.

Example#2 – Changing Row and Column Size

This example shows how to change the row and column size by using the following examples.

Excel row and column width size can be modified by using the format option in the HOME menu, which is shown below.

Rows and Column Example 3-1

Using the format menu, we can change the row and column width where we have the list option, which are as follows:

  • ROW HEIGHT– This is used to adjust the row height.
  • AUTOFIT ROW HEIGHT– This will automatically adjust the row height.
  • COLUMN WIDTH – This is used to adjust column width.
  • AUTOFIT COLUMN WIDTH– This will automatically adjust the column width.

Let’s consider the below example to change the row and column width. Follow the below steps.

Rows and Column Example 3-2

Step 1 – First, select the second row as shown in the below screenshot.

Rows and Column Example 3-3

Step 2 – Go to the Format menu and click on ROW HEIGHT, as shown below.

Rows and Column Example 3-4

Step 3 – Once we select the ROW HEIGHT, we will get the below dialog box to change the height of the row.

Rows and Column Example 3-5

Step 4 – Now increase the row height to 25 so that the selected row height will get increased, as shown in the below screenshot.

Rows and Column Example 3-6

We can see that row height has been increased when compared to the previous one; alternatively, we can change the row height by using the mouse.

Example 3-7

Step 5 – Now go to the second option in the format list called AUTOFIT ROW HEIGHT, which will automatically reset the row to its original height.

Step 6 – Select the same row and go to the Format menu.

Step 7 – Now select the “AutoFit Row Height” as shown below.

Example 3-8

Once we click on the “AutoFit Row Height” option, the row height will reset to the original position, shown below.

Example 3-9

Adjusting Column Width

We can adjust the column width in the same way by using the format option.

Step 1 – First, click on the cell B cell as shown below.

Example 4-1

Step 2 – Now go to the Format menu and click on column width as shown in the below screenshot.

Example 4-2

Once we click on the Column width, we will get the below dialog box to increase the column width, as shown below.

Example 4-3

Step 3 – Now increase the column width by 15 to increase the selected column width.

Example 4-4

Example 4-5

In the above screenshot, we can see that column width has been increased; alternatively, we can adjust the column width by using the mouse where if we place the mouse cursor, we will get the + plus mark sign near to the column.

Step 4 – Now click on the next option called “AutoFit Column width”. So that the selected column will get reset to its original size, which is shown below.

Things to Remember 

  • In excel, we can delete and insert multiple rows and columns.
  • We can hide the specific row and columns using the hide option.
  • Row and column cells can be protected by locking the specific cells.

Recommended Articles

This has been a guide to Rows and Columns in Excel. Here we also discuss Rows and Columns in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Excel Compare Two Columns
  2. Unhide Columns in Excel
  3. Sort Columns in Excel
  4. Excel Columns to Rows
0 Shares
Share
Tweet
Share