COMPUTER 3RD QUARTER

• Change the column width:

  • Drag the border between two heading columns to the right side until the column is adjusted to the desired width.
• Change the row height:

  • Drag the border between two heading rows downward until the row is adjusted to the desired height
• Alt+H+O+W = adjust column width
• Alt+H+O+H = adjust row height
• Alt+H+O+I = autofit column width
• Insert a blank row and column cell:

  • Select a cell, go to the Home tab, click Insert, then choose Insert Sheet row to add a row or Insert Sheet Column to add a column
• Copy and Paste in a cell:

  • Copy and move can be applied to the worksheet
  • Copy duplicates content, move permanently cuts or pastes the contents
  • Using keyboard:
  • Copy: Ctrl+C, Paste: Ctrl+V
  • Using Mouse:
  • Drag the fill handle in the lower right of the active cell
  • Using the Home tab:
  • Click the copy icon, select the cell to paste, then click the paste icon
  • Using the Right Mouse Button:
  • Right click the cell to copy, click copy, select the cell to paste, right click and click paste
• Move and Paste in a cell:

  • Using keyboard:
  • Move: Ctrl+X, Paste: Ctrl+V
  • Using the Keyboard:
  • Select the cell to move, drag to the cell to paste
  • Using the Home tab:
  • Click the move icon, select the cell to paste, then click the paste icon
  • Using the Right Mouse Button:
  • Right click the cell to move, click cut, select the cell to paste, right click and click paste
• Alt+H+O+A = autofit row height
• Delete a blank row and column cell:

  • Select a cell, go to the Home tab, click Delete, then choose Delete Sheet row to remove a row or Delete Sheet Column to remove a column
• Delete a specified cell: Select a cell, go to the Home tab, click Delete, then choose Delete cell to remove a new cell
• Shortcut key for move and paste in cell: Ctrl+X, Ctrl+V
• Shortcut key for copy and paste in a cell: Ctrl+C, Ctrl+V