How to handle cells, columns, rows in a spreadsheet in Excel

The following article details you how to handle cells, columns, rows in spreadsheets in Excel 2013.

1. Change the width of columns, rows and cells in Excel 2013.

1.1 Change the size of a row or a column:

- Click and hold the left mouse button on the vertical part of the column and drag the mouse to change the size:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 1

- After dragging, the width of the column has been changed:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 2

- Similarly to change the width of a row -> click on the horizontal section of the row -> drag the mouse to change the size:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 3

1.2 Change the size of multiple rows or columns:

- Change the width of multiple columns: Select the columns to resize -> go to the Home tab -> in Cells -> Format -> Column width:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 4

- The Column width dialog box appears, enter the width of the column in Column width -> OK:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 5

- Result of the width of the resized column:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 6

- Similarly to resize rows you click Home -> in Cells -> Format -> Row Height.

2. Insert more cells, columns, rows in Excel 2013.

2.1 Insert more cells in a spreadsheet:

- Click to select a cell to locate the cell to be inserted -> Home -> Cells -> Insert -> Insert Cells .

How to handle cells, columns, rows in a spreadsheet in Excel Picture 7

- The result of the cell has been inserted in the worksheet and is usually inserted above the original cell selected.

How to handle cells, columns, rows in a spreadsheet in Excel Picture 8

2.2 Insert more columns for spreadsheets.

- Click to select a column to locate the column to be inserted -> Home -> Cells -> Insert -> Insert Sheet Columns

How to handle cells, columns, rows in a spreadsheet in Excel Picture 9

- After selecting the new column is inserted to the left of the original selected column:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 10

2.3 Insert more rows for spreadsheets.

- Similar to inserting columns: Click to select a row to locate the row to be inserted -> Home -> Cells -> Insert -> Insert Sheet Rows

How to handle cells, columns, rows in a spreadsheet in Excel Picture 11

- New row inserted above the selected original row:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 12

3. Delete columns and rows in Excel 2013.

- To delete a column, select the column to delete -> Home -> Cells -> Delete -> Delete Sheet Columns:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 13

- Similarly, to delete rows, click Delete Sheet Rows , delete the Delete Rows checkbox .

In addition to the above, you can use additional features available when right-clicking on cell, column and row objects on the worksheet:

How to handle cells, columns, rows in a spreadsheet in Excel Picture 14

The above is a detailed guide on how to handle cells, columns and rows in spreadsheets in Excel 2013.

Good luck!

4.5 ★ | 2 Vote

May be interested

  • Instructions on how to format data in ExcelPhoto of Instructions on how to format data in Excel
    instructions on how to format data in excel 2013. 1. format text. 1.1 font format, type, font size: - select the data to format - home - font - quickly select the font, font size, type as shown: where: + b (bold): type c
  • How to insert a SmartArt object in ExcelPhoto of How to insert a SmartArt object in Excel
    how to insert a smartart object in excel. excel has a tool to help you with smartart images that allows you to build complex diagrams quickly and easily. to insert smartart objects, do the following: 1. insert a smarta object
  • How to insert WordArt objects in ExcelPhoto of How to insert WordArt objects in Excel
    show you how to insert a wordart object in excel. wordart objects are indispensable in excel sheets. it is a tool to help your spreadsheet more diverse and rich, attracting readers. to insert a wordart object, follow the steps below
  • Insert image object in ExcelPhoto of Insert image object in Excel
    instructions on how to insert image objects in excel. insert image objects are available on the computer. for example, to add a photo to a spreadsheet: step 1: go to insert - illustration - pictures ...
  • How to insert Textbox in ExcelPhoto of How to insert Textbox in Excel
    instructions on how to insert textbox in excel. to insert textbox in excel, follow these steps: step 1: click insert - text - textbox: step 2: drag and select the area for textbox - enter the content for the textbox to create.
  • Insert special characters in spreadsheets in ExcelPhoto of Insert special characters in spreadsheets in Excel
    show you how to insert special characters in spreadsheets in excel. to insert special characters in excel, perform the following steps: step 1: place the cursor at the position where you want to insert special characters - insert - symbols - symbol: step 2: the symbol dialog box appears