Forum Discussion
SAVE AS, is not saving work, when printing, work drops top rows under the heading
Hello 5connerys,
in Excel you can define which cells of the spreadsheet to include in the printout. Your spreadsheet may have wrong settings for this, so you may want to start with clearing these settings.
Open the Excel spreadsheet and on the Page Layout ribbon find the dropdown command for Print Area. Click the dropdown and select Clear Print Area. That's probably all you need to do to fix your problem.
Now click File > Print and check in the print preview if you like what you see. If so, go ahead and print.
If the print preview shows too much content and you want to print less than what the print preview shows, go back to the sheet, select the cells you want to include in the printout and click Page Layout Print Area > Set Print Area.
You can also click the View ribbon and select the Page Break Preview. It shows blue outlines around the content and you can see which cells end up on which page.
Save As is used to save the workbook with a new name. The original version of the spreadsheet stays as it was and the changes you made are saved in a new workbook. You probably don't want to use that for plain saving your work. Just use the Save command or the floppy disk icon in the window bar.