The Excel software automatically expands rows and columns when you sort data and more room is needed for the extra data. You can stop this feature from occurring in the Excel AutoCorrect properties window. The property is set by default to expand the spreadsheet rows and columns for each new spreadsheet, so you must change this property each time you create a new Excel spreadsheet.
-
1.
Open the Excel software, and open the spreadsheet in which you want to sort the records.
-
2.
Click the "File" menu item, and select "Excel Options." Click the Microsoft Office button if you have Excel 2007 to find the options menu item.
-
3.
Click the "AutoFormat as You Type" tab. Remove the check box next to the "Include New Rows And Columns In Table" option. Click "OK" to save the changes.
