Finish Spreadsheet Notice For Free

Mark a file as final In your Word, PowerPoint, or Excel file, click File >Info > Protect (Document, Presentation, or Workbook) > Mark as Final.

To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.

To turn off these green triangles or auto-calculating checks, do the following: On the File tab, click the Options button: In the Excel Options dialog box, on the Formulas tab, scroll down to the Error Checking section and uncheck the option Enable background error checking:

To close a Sheet View and return to the default view, select View > Sheet View > Exit. To switch between views, select View > Sheet View, and then select your view from the Sheet View menu.

Enable or disable security alerts on the Message Bar In an Office program, click the File tab. Click Options. Click Trust Center, and then click Trust Center Settings. Click Message Bar. The Message Bar Settings for all Office Applications dialog box appears.

Save as read only Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document. Click Tools. Click General Options. Click the Read-only recommended check box. Click OK. Save the document.

Do one of the following: In the upper-right corner of the Excel window, click Close. . On the File tab, click Exit.

Hold down CTRL and press the down arrow key (cursor key) on the keyboard. You are taken to the bottom row. In the modern versions of Excel there are 1,048,576 rows.

Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here's an example.

Hide error indicators in cells On the Excel menu, click Preferences. , and then clear the Enable background error checking check box.