PDF and office guides

Print the stock room range from an Excel workbook

·

A workshop keeps supply counts in a workbook with a visible reserves sheet and a hidden internal worksheet. Make a PDF of the stock room’s saved range, then decide whether to include the reserves.

Excel to PDF

Keep only the stock room’s saved print area

Select Load stock workbook example. Leave Stock room selected and choose Use first selected sheet’s paper, orientation and scale. Its saved settings are A4 landscape and 80% scale. The print list shows A1:C6.

The preview shows a merged heading, 37.5% beside Cable ties and 20 in the TOTAL row. The workbook stores 20 as the result of SUM(B3:B4). The hidden fifth row and the note in E3 are excluded.

Download the workshop stock workbookMicrosoft Excel page setup and print area reference

Include another worksheet or narrow the print range

Check Reserves to add A1:B2 from that worksheet after the stock room. Each print area starts on a new page. For a smaller PDF, select only Stock room and enter A2:B4 in Custom A1 range. This prints the item names and box counts without the allocation column.

Choose Print or save PDF and select Save as PDF. Turn off browser headers and footers, check the chosen paper and use 100% browser zoom for the print. Worksheet scaling is already applied in the tool.

Microsoft Excel page setup and print area reference

Check saved values and layout before sharing

The tool reads common worksheet cells, uses cached formula results and keeps merged cells within the selected area. Basic solid colors and text styles are included. The browser uses available fonts and may substitute a similar font.

Print the workbook from a spreadsheet program if you need charts, embedded images, conditional formatting or an exact rendering of custom number formats. Recalculate and save a new workbook first if any displayed formula result is missing.

Microsoft Learn on SpreadsheetML document structure

Common questions

Can I print a worksheet with no saved print area?

Yes. The preview starts with the used range. Select one worksheet and enter an A1 range to override it.

Does Fit to width make a tall sheet one page?

Fit to width limits horizontal scaling. A long table can continue onto later pages. The browser dialog shows the print page count.

Sources

Put it into practice.

Related guides