Discard Spreadsheet Deed For Free

Sheet ID is an identifier of a Sheet in a Google Spreadsheet file. To obtain it, open the file for the desired Sheet, and locate it at the end of the URL after 'gid=' : .

Click the spreadsheet's name at the top of the Numbers window, then type a new name.

Print Titles is the term Excel uses to describe the rows and columns you want repeated when you print a sheet over multiple pages. You typically want to repeat the labels in the top row(s) and those in the left column(s) of the sheet. There is a dedicated button to define Print Titles on the Page Layout ribbon tab.

On both Windows and Mac, you can choose to print or not print the gridlines. Go to the Page Layout tab and check the box next to Print below Gridlines to print them or uncheck that box to hide them when you print.

You can specify a title for the spreadsheet and save it to a different location. Hold the Option key, then Choose File > Save As (from the File menu at the top of your computer screen). Enter a name in the Name field. Enter one or more tags (optional). Choose where you want to save the spreadsheet.Click Save.

Clicking the Format Brush one or more times will close the sidebar. Simply typing option-command-i will also hide (or display) the side panel.

Delete multiple rows or columns at once: Command-click the rows or columns, click the arrow, then choose Delete Selected Rows or Delete Selected Columns.

Hide or show a table title. Click the table, Control-click the row number for row 1, then choose Hide Table Title or Show Table Title.

Manually generate UNIQUEID() key values You can generate a unique value using a formula in the spreadsheet. An ID must be a value, not a formula, though, so copy (Ctrl+C) and paste as plain text (Shift+Ctrl+V) the result of the formula calculation into the cell meant to contain the new ID. That's all there is to it!

Simply, go to PAGE LAYOUT and uncheck Print in the Sheet Option as shown in the image below.