Understanding Excel Row Vs Column enables users to get better insights into using the Excel software. This post will discuss the properties of Excel Row Vs Column, How to hide, unhide and freeze rows-columns, and how to convert row to column and delete contents in a row.
What is Excel Row Vs Column
The data that is represented horizontally is termed as Row. Rows are arranged from left to right. When you open a blank workbook in excel, you see numbers on the extreme left side of the page which indicates Rows. There are a total of 1,048,576 rows in an Excel blank Workbook. Default height of Row is 18.75 pt.
Fig. 1 – Introduction to Excel Row Vs Column
The data that is represented vertically is termed as Column. They are arranged from top to bottom. When you open a blank workbook in excel, you see letters or alphabets on the top of a page which is actually the column heading. Cell is the area that represents intersection of Row and Column. Number of columns is limited to 16,384. Default width of a column is 8.43 pt.
Fig. 2 – Excel Row Vs Column
How to Hide Row/ Column
Select the Rows or Columns you wish to hide and right click. Pop up window comes up with option to Hide. Alternatively, you can click on ‘Format’ Menu under ‘Home’ Tab to Hide a Row or Column.
How to Unhide Row/ Column
To Unhide specific Row/ Column, you need to select the entire Row above and below the hidden Row. Right Click and choose the option to Unhide.
Fig. 3 – Hide/ Unhide Row and Column using (a) Right Click (b) Format Menu
How to Increase Row Height
Select the Row for which you wish to increase the height and right click. Click on ‘Row Height’ option and enter the required dimension.
How to Increase Column Width
Select the Column for which you wish to increase the Width and right click. Click on ‘Column Width’ option and enter the required dimension.
How to Delete Contents of Row/ Column
Select the required Row/ Column and right click. Click on the option ‘Clear Contents’. It will clear the data.
How to Convert Row to Column
It is easy to convert Row to Column using the ‘Transpose’ feature of Excel using the below steps:
- Select the data you want to Transpose.
- Click on Copy.
- Click on any blank Cell where you want to copy the transposed data.
- Click on ‘Home’ Tab and select drop down arrow under ‘Paste’.
- While hovering your mouse on the different icons, you will see Transpose option.
- Click on Transpose and it changes Row to Column.
Fig. 4 – Converting Row to Column using Transpose Feature
How to Freeze Excel Row Vs Column
Freeze option helps you to keep the top Row and first Column visible though you scroll through the entire worksheet.
How to Select Multiple Rows/ Columns
To select Multiple Rows, select one Row initially and hold down Shift key or Ctrl key and select the other Rows/ Columns. Note that it works for adjacent Rows and Columns.
Also Read: iOS VS Android- Definition, Features, Pros and Cons, the Best One What is Radio Frequency I Type I Features I Uses I How to Improve
