More questions about excel | AccountingWEB

More questions about excel

I am in the middle of a spreadsheet and am entering bank details.
I have a bank account in columns 1 - 6 ie date, detail, property , in, out, total.
When I enter the transaction details, it gets transferred to a column for the various properties.
How do I, instread of having more and more columns for the properties, have a separate sheet for each property.
The next question is I have the property details at the top of the sheet.
I am now way down the page and cannot see which property it is.
How do you make sure the top couple of lines are always visible?
Any help gratefully received.
Angela Brownless

There are 3 comments. Login or register to view them.


leoludwig |
leoludwig's picture

For the second part regarding reporting for a property

ACDWebb |
ACDWebb's picture

Top couple of rows

Anonymous |