... ...
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.
To insert one row
To insert several rows
Update the formula
Delete a Row
Delete Several Rows
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.
To add a column
To add several columns
Update Formatting
Home > Excel Bookkeeping Templates > Free Excel Tutorials
Facebook Comments
Leave me a comment in the box below.