Scarlettrecords
New Member
- Joined
- Apr 6, 2010
- Messages
- 14
Hi, I am new to Excel and finding the other answers unclear as to this distinction. This is URGENT as our accounts info is overdue to our tax agent & I still have to enter it all.
I have created an income property accounts workbook with 12 worksheets, one for each month of the year. I have written in formulas so that all income and outgoings are automatically entered into the "In" and "Out" columns and so that all columns are automatically added up at the bottom of each sheet and those totals are carried through to the "year-to-date" cells in subsequent sheet.
I want to be able to input and correct data (rents in, expenses out) without being able to accidentally edit or erase formulas.
How do I do this?
I have created an income property accounts workbook with 12 worksheets, one for each month of the year. I have written in formulas so that all income and outgoings are automatically entered into the "In" and "Out" columns and so that all columns are automatically added up at the bottom of each sheet and those totals are carried through to the "year-to-date" cells in subsequent sheet.
I want to be able to input and correct data (rents in, expenses out) without being able to accidentally edit or erase formulas.
How do I do this?