Word: Print on a different paper size
You can use Page Setup to change the paper size for an existing document, but Word doesn't automatically fit each page to the new size. You may need to fit the pages manually by adjusting the document's page breaks and layout. With Word's Zoom feature, you can print a document on a different paper size without making permanent adjustments to the layout.
Zoom automatically scales each page of the document to fit the new paper size. For example, to print an 8 1/2 by 11 inch letter-sized document on A5 (148 x 210 mm) paper, follow these steps:
Zoom automatically scales the document's fonts, graphics, and margins to print on the smaller A5 paper, while retaining all of the original document's page layout and page break settings.
Excel: Copy subtotals
When you apply Data Subtotals, Excel automatically displays outline symbols to the left of the spreadsheet. Using these symbols, you can collapse the data to show only the subtotals and the grand totals. For instance, you could show the total monthly payroll for each employee, without the weekly details. However, when you try to copy and paste the monthly subtotals, both the detail rows and subtotals are pasted to the new location.
To copy only the subtotals, use the Go To command with Copy. Follow these steps:
Combining Go To with Copy enables you to copy the subtotals without the details.
Access: Add the Chart Wizard button to the Toolbox
To add a chart to an existing form or report, you can either select Chart from the Insert menu or use the Chart Wizard button on the Toolbox. However, by default, the Chart Wizard button isn't included on the Toolbox. To use the Chart Wizard button, you need to first customize the Toolbox.
Follow these steps to add the wizard to the Toolbox:
To use the Chart Wizard button, select it in the Toolbox, and click where you want the chart to appear in your form or report. This activates the Chart Wizard. Follow the Chart Wizard to build your chart.