Spread Out Spreadsheet Form For Free

Shrink a worksheet to fit on one page Click Page Layout. ... Select the Page tab in the Page Setup dialog box. Select Fit to under Scaling. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ... Press OK at the bottom of the Page Setup dialog box.

Sharing A Template in Google Sheets It's easy to share a Google Sheet as a template that others can use and edit: Open your Google Sheet and click the green share button in the upper right corner of the screen. Click ?get shareable link? and select ?anyone with link can view,? then click ?copy link.?

Select the cell, range, or entire column that contains the text values that you want to split. On the Data tab, in the Data Tools group, click Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into separate columns.

On your computer, open a spreadsheet in Google Sheets. Select a row or column to resize. To highlight multiple rows or columns: Mac: ? + click the rows or columns. ... Right-click the row number or column letter. Click Resize row or Resize column. Then, choose an option: Enter a custom height or width. ... Click OK.

You can shrink or enlarge a worksheet for a better fit on printed pages. To do that, in Page Setup, click the window launcher button. Then, click Scaling > Adjust to, and then enter the percentage of the normal size that you want to use.

To quickly expand or collapse all rows and columns in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell, then press the Enter key.