Select a Sheet tab containing the format you want to use for another Sheet, hold down the Ctrl key and click the Sheet tab to update. From the File menu, select Page Settup , click OK to acknowledge. (With Office 2007, select the Print command from the Office Button, in the Print window, click the Preview button, then select the Page Settup icon from the toolbar in the Print Preview window).
Basic tips with Sheet in MS Excel Picture 3
5. Hide the workspace in the Sheet
To hide a sheet, click to select it and go to the Format menu, select Sheet > Hide (to show it again, select Unhide ). But in a data spreadsheet, when you need to hide a selected area, do the following: Click the first column or row of the data area to hide, then hold down the mouse while dragging the range of the data area. then right-click and select Hide . To show it again, simply access the Format > Row > Unhide or Format > Column > Unhide commands.