Limit Spreadsheet Paper For Free

On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Crop each worksheet to its used range A good way to reduce your Excel file size is to get rid of the empty rows and columns. Here's how to do that: Select all unused rows and columns (Shortcut = Ctrl+Shift+Right/Down Arrow) Right-click > Delete.

I. Removing Blank Rows with Find & Select Click Find & Select. Click to Go to Special. Choose Blanks. Click OK and then all the blank rows/cells will be highlighted. Choose the Delete under Cells section on the Home Tab. Click Delete Sheet Rows.

Hide Rows and Columns in Excel Open your workbook and select the worksheet you want to hide rows and columns in. ... Press and hold the Shift and Ctrl keys on the keyboard. ... Right-click one of the row headings to open the contextual menu. ... The worksheet now shows only the data in rows 1 through 30.

You can reduce your file size by saving your spreadsheet as a binary workbook (. xslb) instead of the default format (. xslx). The default format is XML based, which is important if you're using your data with third-party programs because XML is an open standard.

On the Layout tab, under Print, select the Fit To check box. In the page(s) wide and page(s) tall boxes, enter the number of pages on which you want to print the sheet. On the File menu, click Print. Note: Excel ignores manual page breaks when you use the Fit To option.

Select all blank columns - click on the first column letter, press Shift, and then click the letter of the last blank column. Right-click the selected columns and choose Delete from the pop-up menu.