spreadsheets at work need adjustments

Please update your profile. Solutions may depend on your location due to Regional Settings. A country is close enough. And the solutions will also depend on the version of Excel you are using … not Windows.

I would first select the entire sheet and then remove all borders. You can select specific cells and put them back later.

Then, select the cell below the last row of data. Use Ctrl-Shift-End to select all the cells below the data. Now delete the cells/rows using the Delete icon on the Ribbon.

Next, do the same thing with all columns to the right of the data.

Finally, Save, Close, and Re-open the workbook.

Press Ctrl-Home to go to the first cell, probably cell A1. Then try Ctrl-End to see where that goes. Hopefully, just to the last data cell.

Also, look at the layout section. Check the Print Area and either clear it or set it to just the data area.

You're welcome.

No need to be embarrassed. If you don't know, you don't know. That's it. I was only guessing based on not a lot



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.