Computers in those days

Introduction to Computers - What is Computer

What is a Computer?

Computers in those days

In the olden days, people make use of primitive materials in performing some activities, which of course lead them to less effective result. This was occasioned by the use of less technologically advanced equipment that can perfectly perform those tasks. With time, man began to improve on that equipment; the consequential result is more effective outcome. In the last two centuries, machines were invented that could serve variety of task. Among those machines, computer was the most important as it usage in the modern days has affected the lives of people, to an extend that many have began to imagine the world without computer.

How to Delete cells, rows, or columns

How to Delete cells, rows, or columns

·         Select the cells, rows, or columns you want to delete. 

How to select rows, columns and cells

·         In the Cells group, on the Home tab select a command to delete.

·         Click the arrow beside the Delete and click Delete Cells to Delete Cells. 

 
 
 
 
 

• For rows, click the arrow beside Delete, and click Delete Sheet Rows.
• For columns, click the arrow beside to Delete, and click Delete Sheet Columns. 

 

Or

By using the shortcut menu, Right click a selection of cells, rows, or columns, click Delete, and select and click on the option that you desire.

·       

      

 For you to Delete a cell or a range of cells, 

in the Delete dialog box, 

click Shift cells left, Shift cells up, Entire row, or Entire column.

   

 ·   Deleting rows or columns automatically shift other rows or columns up or to the left.

learn about inserting rows, columns and cells 

how to modify and adjust columns, rows, and cells

how to select characters in a cell

 

How to select characters in a cell

How to select rows, columns, and cells

To select the contents of a cell

·         In the cell, Double-click the cell, and then drag across the contents of the cell that you want to select.

·         In the formula bar

·         Click the cell, and

·         Drag across the contents of the cell that you want to select in the formula bar.

By using the keyboard        

·         Select the cell that you want to edit

·         Press F2 to edit the cell, 

·         Use the arrow keys to position the insertion point, 

·         Then press SHIFT+ARROW key (i.e left arrow key or right arrow key) to select the contents.

How to insert rows, columns, and cells
Learn about deleting rows, columns, and cells 
Learn how to modify and adjust  columns 

How to select rows, columns, cells, or range of cells

How to select rows, columns, cells, or range of cells

To select a single cell,

• Click the cell, or press the arrow keys to move to the cell.

To select a range of cells,

•  Click the first cell in the range,

•  then drag to the last cell

·         Or hold down SHIFT while you press the arrow keys to extend the selection.

• Select the first cell in the range, and then press F8 to extend the selection by using the arrow keys.

• To stop extending the selection, press F8 again.

To Insert rows, columns and cells on a worksheet

How to modify columns, rows, and cells

How to insert rows, columns and cells on a worksheet

In Excel, you can insert blank cells above/below or to the left/right of the active cell on a worksheet shift other cells in the same column down or in the same row to the right. you can also insert rows above or below a row and columns to the left or to the right of a column. You can as well delete cells, rows, and columns. The Excel has limits of 18,278 A to Z columns wide by 1,048,576 rows tall.

How to insert rows on a worksheet

•  Select the row below where you want the new row to appear.

 How to select rows, columns, and cells

• Click on the arrow next to Insert on the Cells Group under Home tab
• And then click Insert Sheet Rows.

• The new row always appears above the selected row.
• If you select just the cell and then click Insert, only a new cell will appear.

•  So make sure you select the entire row below where you want the new row to appear and not just the cell.

•  Notice that when you insert rows on your worksheet, all references that are affected by the insertion adjust accordingly, whether they are relative or absolute references. The same applies to deleting rows, except when a deleted cell is directly referenced by a formula.

·         If you want references to adjust automatically, it is a good idea to use range references whenever appropriate in your formulas, rather than specifying individual cells.

Tips: when you want to quickly repeat this action of inserting a row, click the location where you want to insert the row, and then press CTRL+Y that is to Redo an action. 

how to select character in a cell

How to insert columns on a worksheet

• Select the column to the right of where you want the column to appear.
• In the Cells group under Home tab,
• Click the arrow next to Insert,

•  And then click Insert Sheet Columns.

• The new column always appears to the left of the selected column, only a new cell will appear when you select just the cell and click insert so make sure you select the entire column to the right of where you want the new column to appear and not just the cell.  

How to insert blank cells on a worksheet

• Select the cell or the range of cells where you want to insert the new blank cell
• Select the same number of cells as you want to insert. For example, to insert five blank cells, you need to select five cells.
• Click on Insert Cells in the Cells group on the Home tab an insert dialog box will appear

You can cancel a selection of cells by clicking any cell on the worksheet.

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

• And click ok

Right click the selected cells and then click Insert on the shortcut menu.

How to Modify/Adjust Row height