A quick way to that is press F5 and type F:IV to delete columns F to IV, or 5:65536 to delete rows 5 to 65536 If pressing Ctrl+ End brings you far beyond your data range then try resetting the last cells. When you format whole rows and columns, some types of formatting can cause the last cell to be set to a cell far below or to the right of the actual range that is in use.
The most common cause of the last cell being set outside the worksheet range that is currently in use is excessive formatting. Locate and reset the last cell on a worksheet This causes the file size of the workbook to be larger than necessary and may result in more printed pages when you print the worksheet or workbook.
Empty cells may contain formatting that causes the last cell in a row or column to fall outside of the range of cells that contains data. When you save a workbook, Excel stores only the part of each worksheet that contains data or formatting. This sometimes happens when those cells have formatting but no data
