Excel – Why is the maximum row height in Excel 546px

1. Insert a column
2. In first row insert formula =MOD(ROW(),7)
3. Copy down
4. Copy/paste special/values
5. Data/Filter out the ones you want (0 or 6, probably)
6. Delete the rest of the rows Remove filter Delete column

There may be an excess of blank rows or columns in the larger file. If this is the case, the larger file will have a much lager scroll-able area and much smaller scroll bars (along the right and bottom edges of the window).

To delete extra columns, highlight the first blank column, hold ctrl + shift, and press the right arrow key to select them all. Right click the highlighted columns and select "Delete" from the context menu. Next, select the first blank row, hold ctrl + shift, press the down arrow key and delete the extra row.

Now save the document. Once saved, the scroll bars should return to the appropriate size, the scrollable area should now include only the area of the spreadsheet that contains data, and the size of the file should decrease.