How do you remove all empty unused rows and column

Question

I accidentally enlarged the data range I was working on and now the scroll bars on the sides and bottom won't reset. I had this problem before and I found out how to do it, but now I've forgotten :/ Does anyone know the trick, I think it involves using Ctrl+End to locate the last cell of the active worksheet but I can't quite recall.

This is for Excel btw.

Thank you.

Answer 1

• Goto cell A1 (not really necessary)
• Hit Alt-F11 to open VBA editor
• Open Immediate Window (if not already opened)

• Type: ActiveSheet.UsedRange+Enter (there will be no response)

• Done (you can close VBA editor)