So I have a basic income statement, but I need to add columns into the top (where all the property details and information go) without carrying them through to the middle of the worksheet where all the $ amounts are.

best way to do this?

Insert some cells, pushing the others to the right, in the rows where the property details need to go.

And if necessary post a sample sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

haha answers my question, but I guess that was only part of my original concern. Is there a way that I can change the size of certain columns without it affecting (for example) rows below 6?

No, column widths apply to the entire column. You'll have to be clever with the design/layout of your worksheet.

thats what I thought, thanks!