... ...

Free Excel Tutorial

Excel Tutorial Videos and Bookkeeping Tutorials

These free excel tutorial videos will help you learn how to work in excel.

At the same time, these videos double-up as bookkeeping tutorials because we teach you how to manipulate information in our excel cash book which is a great and free template for any small business to start their bookkeeping in.

We also have available a range of other excel bookkeeping templates.

Free Excel Tutorial #1
Insert Rows to Excel and Update Formula in New Cells

To insert one row

  • Left click on the row number, in the left margin, below where you want the new row (the row will be inserted above)
  • Right click and select Insert

To insert several rows

  • Left click on the row number, in the left margin, below where you want the new rows.
  • Hold the left click down and drag down the number of rows that corresponds to how many new rows you want. So if you want 2 rows, drag down over 2 rows.
  • Let go of the left click and right click, select Insert

Update the formula

  • If you have a column with formulas, click in the new cells within that column and look in the formula bar.
  • If it is blank, then you need to copy the formula from an original cell and paste it into the new cells.
  • A quick way is to hover your cursor on the small square on the bottom, right corner of the original cell. When it changes to a black cross, left click and hold, drag down into the new cells.
  • This will paste the formula into the new cells – click on each new cell and check the formula bar.
  • Test that it works by entering random data into the new rows to see if the formula includes that data in its calculations

Free Excel Tutorial #2
Excel Remove Delete Rows and fix Formula Error #ref! (hash ref)

Amend Hash Ref Formula Result

Delete a Row

  • Move your cursor to the left margin
  • hover over the number of the row you want to delete so that the black, right-facing arrow pops up
  • right click your mouse and select Delete.

Delete Several Rows

  • To delete say three rows, once again move your cursor to the left margin
  • hover until the black arrow appears (usually a split second),
  • press the left mouse down and hold it down,
  • drag down three rows, let go of the left button and click the right mouse button.
  • Select Delete.

Amending #Ref! (hash ref) Symbol
This usually appears in cells with formulas which are missing the information that was previously on the spreadsheet. In this case, because rows have been deleted, the ‘link’ to those deleted cells is broken so the formula is unable to complete its calculations.

To correct this, we need to simply copy and paste a working formula from a cell that has one, usually a cell above where the rows were deleted.

  • Go to the bottom right corner of the working cell
  • hover over the small square in the corner until you get a small black cross 
  • click the left mouse button, hold it down and drag all the way down the cells that have the #Ref! symbol. 
  • This replaces the broken formula

Free Excel Tutorial #3
Add Columns in Excel

To add a column

  • Left-click your mouse at the top of a column next to where you want your new column to be added
  • Click the right mouse button and select Insert 

To add several columns

  • Follow step one above but hold the left-click down and drag across the existing columns by the number that you want to add. 
  • So, if you are adding three columns, drag across three, right click and select Insert.

Update Formatting

  • If the formatting on the new columns is wrong, copy the formatting from the good cells
  • Left click and drag across the good cells and select the formatting field box in the Quick Access Toolbar
  • Then left-click, hold the click down and drag across the cells that need updating. 

Home > Excel Bookkeeping Templates > Free Excel Tutorials

Facebook Comments

Have your say about what you just read!
Leave me a comment in the box below.