Question

Explain inserting removing and resizing of columns & rows in ms excel

Answer 1

Answer:

Explanation:

Change the row height to fit the contents

Select the row or rows that you want to change.

On the Home tab, in the Cells group, click Format.

Under Cell Size, click AutoFit Row Height

Answer 2

Answer:

Highlight the first and third rows' headings, then right-click on one of the highlighted rows and select the «Insert» option. Use the hot keys CTRL+SHIFT+PLUS to add a row or a column to Excel after you've highlighted the appropriate row or column. Selecting the contents of a cell in a row or column you want to delete is another quick way to delete rows and columns. This will bring up a pop-up menu. Then select Delete Row or Delete Column from the drop-down menu.

Explanation:

You can easily add or remove table rows and columns after you've created an Excel table in your worksheet with these steps:

1. To add rows and columns to a table, use the Resize command in Excel:
2. The Table Tools option appears when you click anywhere in the table.
3. Starting with the upper-leftmost cell, select the entire range of cells you want to include in your table.
4. The original table in the example below covers the range A1:C5. The table will cover the range A1:E8 after resizing to add two columns and three rows.
5. When you've decided on a range for your table, click OK.

Select Design > Table Resize from the drop-down menu:

The "AutoFit" feature in Excel can also be used to automatically resize columns and rows. Excel's "AutoFit" feature automatically adjusts the width and height of columns and rows to fit the largest entry in each. Select the columns you want to adjust to AutoFit their width. To select every cell in the worksheet, look for and click the Select All button just below the name box. Place your mouse over a row line to make the cursor a double arrow. Increase or decrease the row height by clicking and dragging the mouse, then releasing the mouse when you're done.