COMP 228 Lecture Notes - Lecture 13: Dialog Box, Tab Clear, Status Bar
Document Summary
Freezing: keep headings on screen both rows & columns just top row or first column. Select cell below row(s) & right of column(s) to freeze view window group click freeze panes. Hide: rows, columns & sheets are invisible does not affect data or visible cell that references data in hidden element. Select row/column/sheet home cells group click format hide or unhide hide. Unhide: home cells group click format hide or unhide unhide unhide dialog box choose sheet. Unlock cell/range others can modify: select cell/range home cells group click format click format. Cells protection tab clear check mark on locked ok. Protect the rest: home cells group click format click protect sheet. Calculation: compute formulas & display results in cells that contain the formulas. Default recalculation: when cells that formula refers to change. Recalculation schemes: office button excel options formulas category. Manually recalculate: formulas calculation group click calculate now or press f9.