Brother International WP7550JPLUS Owner's Manual - English - Page 130

Delete Ifyou select NO, insertion is canceled. Ifyou select YES, insertion will beperformed with data lost, except i_fone or more cells among the data to he lost is protected, in which case this window appears and insertion is canceled: Protected cell error! Press any key to continue. This function removes columns or rows fi -om the worksheet. 1. Move the cursor to the first column or row that you want to delete. And press MENU and select Sheet; then select Delete from the function menu. The DELETE window appears: €€ DELETE» DELETE COLUMNS OR ROWS: MEMO NUMBER OF COLUMNSfROWS TO DELETE: 1 Press SPACE to change setting and press RETURN. 2. Use CURSOR UP and CURSOR DOWN to move the cursor to the desired setting. Use SPACE BAR to alternate between COLUMNS and ROWS, and type a number. • DELETE COLUMNS OR ROWS : COLUMNS Deletes column(s). • DELETE COLUMNS OR ROWS : ROWS Deletes row(s). • NUMBER OF COLUMNS/ROWS TO DELETE: Enables specification of the number of columns or rows to be deleted (1 - 99). 3. Press RETURN. This message appears: Delete? Use cursor to select and press RETURN. BYES (NO] Select YES to delete, or NO to cancel, then press RETURN. • Relative addresses in aformula are automatically adjusted. Example: D1 contains (B1 +C1) and you delete column A. D1 becomes Cl and now contains (Al+B1). • After deletion, subsequent columns or rows are renumbered. • Ifone or more cells among the data to be deleted areprotected, this window appears, and deletion is canceled: . Protected cell error! [ Press any key to continue. Spreadsheet 122