Data Entry: Basics of Spreadsheet: Modifying Worksheet: Insert Cells, Rows, Columns and Delete Cells

Doorsteptutor material for IAS/Mains/Optional Public-Administration is prepared by world's top subject experts: Get detailed illustrated notes covering entire syllabus: point-by-point for high retention.

Download PDF of This Page (Size: 252K)

Modifying a Worksheet

Insert Cells, Rows, Columns and Delete Cells

Insert blank cells on a worksheet

  • On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Cells.

  • You can also right-click the selected cells and then click insert on the shortcut menu.

  • In the Insert dialog box, click the direction in which you want to shift the surrounding cells.

Insert rows on a worksheet

On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Rows.

Insert columns on a worksheet

On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Columns.

Delete cells, rows, or columns

If you are deleting a cell or a range of cells, in the Delete dialog box, click Shift cells left, Shift cells up, Entire row, or Entire column.

Resizing Rows and Columns

Set a column to a specific width

  • Select the column or columns that you want to change.

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

  • Under Cell Size, click Column Width.

  • In the Column width box, type the value that you want.

Change the column width to fit the contents

  • Select the column or columns that you want to change.

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

  • Under Cell Size, click AutoFit Column Width. Too quickly, auto fit all columns on the worksheet, clicks the Select All button and then double clicks any boundary between two column headings.

Match the column width to another column

  • Select a cell in the column.

  • On the Home tab, in the Clipboard group, click Copy, and then select the target column.

  • On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special.

  • Under Paste, select Column widths.

Set a row to a specific height

  • Select the row or rows that you want to change.

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

  • Under Cell Size, click Row Height.

  • In the Row height box, type the value that you want.

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. Too quickly, auto fit all rows on the worksheet, clicks the Select All button and then double-clicks the boundary below one of the row headings.

Change the height of rows by using the mouse

  • To change the row height of one row, drag the boundary below the row heading until the row is the height that you want.

  • To change the row height of multiple rows, select the rows that you want to change, and then drag the boundary below one of the selected row headings.

  • To change the row height for all rows on the worksheet, click the Select All button, and then drag the boundary below any row heading.

  • To change the row height to fit the contents, double-cl

Move or Copy Entire Cells

  • Select the cells that you want to move or copy.

  • On the Home tab, in the Clipboard group, do one of the following:

  • To move cells, click Cut. Keyboard shortcut or CTRL+X.

  • To copy cells, click Copy. Keyboard shortcut or CTRL+C.

  • Select the upper-left cell of the paste area.

  • On the Home tab, in the Clipboard group, click Paste. Or CTRL+V.

Page Breaks

To set page breaks within the worksheet, select the row you want to appear just below the page break by clicking the row’s label. Then choose Page Layout→Setup Group→Breaks→Input Page Break. Excel will start a new page from the row selected.

Image of page Break

Image of Page Break

Page Setup

Select File→Page Setup from the menu bar to format the page, set margins, and add headers and footers.

  • Select Print from Office Button.

  • Select print.

  • Click Print Preview.

Print

  • Print Range - Select either all pages or a range of pages to print.

  • Print What - Select selection of cells highlighted on the worksheet, the active worksheet, or all the worksheets in the entire workbook.

  • Copies - Choose the number of copies that should be printed. Check the Collate box if the pages should remain in order.

  • Click OK to print.

File Open, Save and Close

Open an existing File

  • Go to windows explorer and find out the file you want to open. Double-click on the file.

  • Start MS Excel. Click on office button on the dropdown menu click 'open'. Select the file you want to open from the pop-up menu.

  • When you have finished your work on the file you can save it by either clicking on the 'file save' icon at the top left corner or Click on office button → click on save at the dropdown menu.

  • Saving the worksheet

  • Select Print from Office Button

  • Select (Click) Exit Excel Command to exit from MS Excel

Workbook Protection

Set a password for a workbook

  • Click the Microsoft Office Button, and then click Save As.

  • Click Tools, and then click General Options.

  • If you do not want content reviewers to accidentally modify the file, select the Read-only recommended check box. When opening the file, reviewers will be asked whether they want to open the file as read-only.

  • Click OK.

  • When prompted, retype your passwords to confirm them, and then click OK.

  • If prompted, click yes to replace the existing workbook.

Developed by: