Basic tips with Sheet in MS Excel
Instead of using tabs (tabs) to manage multiple windows as in some applications, MS Excel supports the integration of Sheets (spreadsheets) as cards to help you easily manage the tables. count and link them together. If you don't like the existing settings of the Sheet, you can customize it according to your preferences and incorporate other basic operations in the process of working with the Sheets.
1. Change the display size of the Sheet card
By default, you will see that the tab displays the following Sheets of small size, so to increase its size makes it easy to see the following steps:
Basic tips with Sheet in MS Excel Picture 1
With Windows XP:
- Right-click on the Desktop screen and select Properties , browse to the Appearance tab, click the Advanced button below, from the Item list, click on Sroobar , change the size in the Size section and OK twice to acknowledge.
With Windows 7:
- Right-click on the Desktop and select Personalize , click the Windows Color item and click on the blue link in Advanced Appearance settings , then follow the same steps as for Windows XP.
2. Determine the number of Sheets displayed by default
By default the MS Excel window only displays up to 3 Sheets when opening a new work window, and you can easily add or delete a Sheet. However, to change the default number of Sheets displayed, from the Tools menu select Options , browse to the General tab and change the number in the Sheet in new workbook . (With Office 2007, click the Office Button button and select Excel Options , in the Popular section on the left panel, change the number after the Include this many Sheet text option in the When creating new workbooks frame).
Basic tips with Sheet in MS Excel Picture 2
3. Change the Sheet color card
As you can see, the Sheet tags all have the same color as the following, the purpose of setting a separate color for each Sheet is so that you can easily classify the spreadsheet. So to change your default color, right click on any Sheet and select Tab Color then select the color and OK .
4. Copy the format of a Sheet
Each Sheet has a different print format before printing, so that you don't need to repeat these formats for another sheet, you can quickly copy it using the following steps:
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.
You should read it
- Tips with spreadsheets (sheet) in Excel
- How to hide and hide sheets in Excel and show them again
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- Tips for adding in Excel you need to know
- Guidance on how to align Excel correctly
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to display sheet tabs in Excel
- 14 time-saving tips when using Microsoft Excel
- MS Excel 2007 - Lesson 7: Create Macros in Excel 2007
- Instructions on how to automatically open a Workbook when you open Excel
- How to print an Excel spreadsheet in a page
- How to create a password protection for Excel sheets