MS Excel - Working with Row & Column

Working with Row & Column

Merge Cell

 This option is used to merge one or more people together, which we call merge, for this we must first select all those people who have to be merged, after selecting them all together, click on this option. Clicking on the option will merge all the cells.

MS Excel Row

In Microsoft Excel, the data of a single person is inputted in a row. This input row is made up of multiple horizontal cells.

MS Excel Column

In Microsoft Excel, any one type of data is inputted in a column. This input row is made up of multiple vertical cells.

Ms Excel Row और Column

MS Excel Version	Number of Rows	Number of Columns
MS Office 2003	65536 Rows	256 Columns
MS Office 2007	1048576 Rows	16384 Columns
MS Excel 2010	1048576 Rows	16384 Columns
MS Excel 2019	1048576 Rows	16384 Columns

Ranges

Vertically or horizontally selection of multiple cells is called ranges.

Resizing Rows and Columns

We can increase or decrease the Height of Rows and Width of Columns of MS Excel. In Excel, the Height of Rows, Default Sizes are 14.4 or 15, similarly the Width of Columns is 8.43 Point Scale, which we can resize by going to the Format Group of the Home Tab.

We can resize (change) the Rows and Columns of MS Excel as per our requirement

Type	Minimum	Maximum Size	Default Size
Column	0 (hidden)	255	8.43
Row	0 (hidden)	409	15.00

We can resize the rows and columns of MS Excel in two ways. First by drag & drop Columns Header and Row Header and second way by format option.

Resize Columns Header and Row Header (Format option)

1.     First click on the Home Menu.

2.     Select the sales Group in it.

3.     Now Click on Format Option.

4.     Click on Row Height or Column Width

5.     Enter Row Height or Column Width

6.     Click on the Ok Button

Resize Columns Header and Row Header by drag & drop

1.     Select the Row or Column Header.

2.     Increment or Decrease the line given in the Header.