Page 27 - Plus V4 with Adobe class 6
P. 27
Automatically Fit Column/Row Content
You can adjust the row height and column width according to the height and width of the contents in
the cell. To fit column/row content automatically, follow these steps:
Double-click on any boundary between 2
Click on the Select two column/row headings.
1
All button.
INSERTING ROWS/COLUMNS
Suppose you want to add more data between two rows or column than you might need to shift the
data by copy and paste method to create space between rows/column. But this process is not available
when you have large data. So you can insert rows/column to overcome his problem.
To insert a row/column in a worksheet, follow these steps:
2 Click on Home tab. 3 Click on Insert command.
Click the row
1 heading/column
heading
4 Select the Insert Sheet Rows /Insert Sheet Columns option.
MERGING CELLS
While working on Excel you might need to combine some cells to show a part of data under one heading.
Combining two or more cells is known as merging. To merge cells, follow these steps:
Click on Merge &
Click on Home tab. 2 Center command. 3
Select two or more
1 adjacent cells that
you want to merge.
#More on Excel 2019 25

