Print Preview

%3CLINGO-SUB%20id%3D%22lingo-sub-2170487%22%20slang%3D%22en-US%22%3EPrint%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170487%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20Excel.%26nbsp%3B%20I'm%20trying%20to%20print%20my%20worksheet.%20In%20the%20Print%20Preview%2C%20it%20displays%20%221%20of%203%2C452%22%2C%20which%20means%203%2C452%20pages%20(1%20row%20at%20a%20time).%20My%20worksheet%20has%204%20pages.%26nbsp%3B%20What%20happened%3F%20How%20do%20I%20change%20that%20or%20what%20did%20I%20do%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2170487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2170757%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980486%22%20target%3D%22_blank%22%3E%40Each1ofus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%20do%20you%20end%20up%20if%20you%20press%20Ctrl%2BEnd%3F%20If%20it%20is%20far%20beyond%20the%20used%20range%20of%20the%20worksheet%2C%20select%20the%20unused%20rows%20and%20delete%20them%2C%20then%20select%20the%20unused%20columns%20and%20delete%20them.%3C%2FP%3E%0A%3CP%3ESave%2C%20close%20and%20reopen%20the%20workbook%2C%20then%20check%20whether%20the%20problem%20has%20been%20solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

I'm new to Excel.  I'm trying to print my worksheet. In the Print Preview, it displays "1 of 3,452", which means 3,452 pages (1 row at a time). My worksheet has 4 pages.  What happened? How do I change that or what did I do wrong.

1 Reply

@Each1ofus 

Where do you end up if you press Ctrl+End? If it is far beyond the used range of the worksheet, select the unused rows and delete them, then select the unused columns and delete them.

Save, close and reopen the workbook, then check whether the problem has been solved.