Sometimes cutting and pasting blows up my excel file to an enormous size, normally I can simply go to the last row, select the row right beneath it cntrl+shirt down, right click and delete. BUT this freezes excel most of the time. I was hoping there was a macro that could do this so I could program a keyboard shortcut. This happens all the time and would love a fix. Thanks