Cannot Add Rows

[ssbw93]

Hi,

When I try to add a row to my report, there is an error message saying "cannot shift objects off of the sheet". How can I fix this? I have attached a sample file.

Thank you!

[jonboy6257]

Just grab the bottom border and shift it down a row. It wouldn't let me insert one but I could adjust manually.

[lychee]

It appears you have colored all the rows from 261 down a grey color. Delete one of those rows first. You could save space if you Deleted everything below 260 and then used print area to select what you want to print.

[FDibbins]

Seems you have some formatting that goes down to the last row of that W/S, so excel thinks all the rows are used.

Delete all rows from about 300 down, then insert the rows you want