Brother International WP7550JPLUS Owner's Manual - English - Page 122
Block, Functions
View all Brother International WP7550JPLUS manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 122 highlights
All Off This function is used to reset all the attributes of the selected cells to their default settings (underline off, bold off, fixed auto decimal, currency and percent off, no commas, formula text off, no display off). 1. Move the cursor to a corner of the range of cells that you want to reset and press MENU and select Style; then select All Off from the function menu. 2. Proceed as you would with the Underline function to select the range of cells. After the range is selected, the All Off window appears. OK to delete format? Use cursor to select and press RETURN. I E5 [NO] • YES: Deletes all the Style settings and restores the default settings in the selected range. • NO: Cancels the function and returns to the previous display. Block Functions Style FIN Sliee[ Option Mae Copy(A Range of Cells) Copy(One Cell Is Olher Cells) Clear Copy to Clip Board Pill; from Clip Board You can press CANCEL at any time to cancel the function. The Block operations will move the Style settings of the individual cells with the cells. Use the Block functions from the function menu to modify the location of an entire range of cells: Move: Moves a range of cells to another location. The original location is left empty. Copy (A Range of Cells): Copies a range of cells to another location. The original lot-adult is left unchanged. Copy (One Cell to Other Cells): Copies one cell to all the cells in a range. Clear: Empties all cells in a range. Copy to Clip Board: Copies a range of cells to the Clip Board. Paste from Clip Board: Pastes the contents of the Clip Board into the worksheet. Absolute and relative addresses Whenever the layout of your spreadsheet is altered, and the data within a cell has been copied, the cell reference in the formulas are updated accordingly. A cell with a relative address will be updated to reflect most layout changes. A cell with an absolute address is generally not updated when you change the layout. However, there may be times that you do not wish the cell address in the formula updated. Cell addresses are considered relative, unless a $ (dollar sign) is placed at the beginning of the cell address in the formula: Al is a relative address; $Al is an absolute address. Spreadsheet 114