Microsoft Excel

What is Cell Reference?
Cell Reference refers to the set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersecti...
Tue, Nov 25, 2014 at 3:47 PM
How can I delete a cell?
To delete a cell or cells: Select the cell(s) you want to delete. In the Edit menu, click Delete. In the Delete dialog box, click the directi...
Mon, Dec 1, 2014 at 3:41 PM
How do I insert rows or columns on my worksheet?
To insert rows or columns: Select the same number of rows or columns as you wish to inset. On the Insert menu, click Rows or Columns.  Your orig...
Tue, Nov 25, 2014 at 3:48 PM
What is the #REF! error? How can I fix it?
When cells, rows, or columns are deleted, Excel updates formulas by adjusting cell reference to the shifted cells, reflecting their new locations. You will ...
Tue, Nov 25, 2014 at 3:48 PM
How can I delete rows or columns?
To delete rows or columns: select the rows or columns you wish to delete. In the Edit menu, click Delete.  The other rows or columns will shift ...
Tue, Nov 25, 2014 at 3:49 PM
How do I insert a blank worksheet?
To insert a blank worksheet: Select the sheet tab where you want to insert a new worksheet. On the Insert menu, point to Sheet, then click Blank...
Tue, Nov 25, 2014 at 3:49 PM
How do I delete a sheet?
Please note, deleted sheets can't be recovered.  To delete a sheet: Select the sheet you wish to delete. On the Edit menu, click Delete She...
Tue, Nov 25, 2014 at 3:49 PM
When I move or copy a cell in Excel, will the formatting still be in place in the new location?
Yes.  When you move or copy a cell in Excel, the content of the moved or copied cell overwrites any data in the destination cell. Also, any formatting a...
Tue, Nov 25, 2014 at 3:49 PM
How do I move or copy cells?
To move or copy a cell: Select the cells or range of cells that you wish to move or copy. Point to the border of the cell or range that you sele...
Tue, Nov 25, 2014 at 3:50 PM
How do I move or copy rows or columns in Excel?
To move or copy rows or columns: Select the rows or columns you wish to move or copy. Point to the border of the cell or range that you selected...
Tue, Nov 25, 2014 at 3:50 PM