Manipulate Rows and Columns

Add and Modify Column(s)

Add column(s)

1.   Select existing column(s) to place additional column(s) to left or right

NOTE:  Hold SHIFT and select column headings or click and drag the mouse over the column headings to select multiple columns at the same time 



2.   Do one of the following:

  • Right click selected column(s) and choose one of insert options on the shortcut menu
    • Insert 1 left or Insert <#_of_columns> left
    • Insert 1 right or Insert <#_of_columns> right

3.   From the Menu Bar, go to Insert menu > choose one of insert options on the drop down menu

    • Column left
    • Column right
    • <#_of_columns> left
    • <#_of_columns> right

 


 

Change the Width of Column(s)

1.   Select existing column(s) to place additional column(s) to left or right

NOTE:  Hold SHIFT and select column headings or click and drag the mouse over the column headings to select multiple columns at the same time

 


2.   Do the following:

  • Move the mouse to between the two column headings where the mouse turn into a double-headed arrow
  • Hold and drag the column to make it wider or narrower

NOTE   Unlike Microsoft Excel, double-click in between columns to auto-size them can’t be used in Google Docs

Add and Modify Row(s)

Add Row(s)

1.   Select existing row(s) to place additional row(s) to above or below

NOTE   Hold SHIFT and select row number headings or click and drag the mouse over row number headings to select multiple rows at the same time

 


2.   Do one of the following:

  • Right click selected row(s) and choose one of insert options on the shortcut menu
    • Insert 1 or <#_of_row> above
    • Insert 1  or <#_of_row> below

3.   From the Menu Bar, go to Insert menu > choose one of insert options on the drop down menu

  • Row above
  • Row below
  • <#_of_rows> above
  • <#_of_rows> below

 


4.   Scroll down to the bottom of the spreadsheet, do the following to add multiple rows at the bottom of the spreadsheet:

  • Enter a number between 1 and 100 to add multiple rows at the same time in the box 
  • Click Add button 

 

Change the Height of the Column

1.   Move the mouse to between the two row number where the mouse turn into a double-headed arrow

2.   Hold and drag the column to make it wider or narrower

NOTE   Unlike Microsoft Excel, double-click in between columns to auto-size them can’t be used in Google Docs

Hide Column(s) or Row(s)

1.   Select column(s) or row(s)

2.   Right click on selected column(s) or row(s) and select hiding options on the shortcut menu

 

Expose Hidden Column(s) or Row(s)

1.   Place the mouse between the two arrows > the mouse turn into the finger pointing out

2.   Left click and the hidden column(s) or row(s) will be exposed

 

Delete Column(s) or Row(s), do the Following:

1.   Select column(s) or row(s)

2.   Right click on selected column(s) or row(s) and select deleting options on the shortcut menu