What are your favorite Excel worksheet tricks? Microsoft Excel offers lots of featured functions. Some of them are very funny and useful on doing worksheet works. If you don’t use them, you will work harder than you have to. Here I want to share three Excel worksheets tricks which are my favorite worksheet-related tricks.
1: Resize Worksheet Tabs
Sheet tabs usually are small for most users. But in fact we can change the default size as follows in Windows XP (classic):
1. Go to the Start menu, select Control Panel.
2. Double-click Display.
3. Click the Appearance tab.
4. At the bottom right area, click Advanced.
5. From the Item dropdown, choose Scrollbar.
6. Change the setting, accordingly - the larger the setting, the larger the tabs.
7. Click OK, Apply, and then OK.
If you’re using Windows 7, do the following:
1. Also go to the Start menu, select Control Panel.
2. Click Appearance & Personalization
3. Click Change Window Glass Color in the Personalization section.
4. Click Advanced Appearance Settings.
5. From the Item dropdown, choose Scrollbar.
6. Change the setting, accordingly - the larger the setting, the larger the tabs.
7. Click OK, Apply, and then OK.
The bad side of this trick is this setting is an all-or-nothing setting. It will also change the size of scrollbars.
2: Determine the Number of Worksheets
By default, Excel offers three worksheets in a new workbook. You can add and delete sheets, as you like. But in fact, you can also change the default setting of the number of worksheets. Do as the followsteps:
1. Go to the File tab and then click Options under Help. In Office 2007, click the Office button, and then go to Excel Options. In Word 2003, choose Options from the Tools menu.
2. In the left pane, choose general section area. In Word 2003, click the General tab.
3. In the “When creating new workbooks” section, we can change the number of sheets at will from the “Include this many sheets” dropdown. In Word 2003, use the Sheets In New Workbook dropdown.
1: Resize Worksheet Tabs
Sheet tabs usually are small for most users. But in fact we can change the default size as follows in Windows XP (classic):
1. Go to the Start menu, select Control Panel.
2. Double-click Display.
3. Click the Appearance tab.
4. At the bottom right area, click Advanced.
5. From the Item dropdown, choose Scrollbar.
6. Change the setting, accordingly - the larger the setting, the larger the tabs.
7. Click OK, Apply, and then OK.
If you’re using Windows 7, do the following:
1. Also go to the Start menu, select Control Panel.
2. Click Appearance & Personalization
3. Click Change Window Glass Color in the Personalization section.
4. Click Advanced Appearance Settings.
5. From the Item dropdown, choose Scrollbar.
6. Change the setting, accordingly - the larger the setting, the larger the tabs.
7. Click OK, Apply, and then OK.
The bad side of this trick is this setting is an all-or-nothing setting. It will also change the size of scrollbars.
2: Determine the Number of Worksheets
By default, Excel offers three worksheets in a new workbook. You can add and delete sheets, as you like. But in fact, you can also change the default setting of the number of worksheets. Do as the followsteps:
1. Go to the File tab and then click Options under Help. In Office 2007, click the Office button, and then go to Excel Options. In Word 2003, choose Options from the Tools menu.
2. In the left pane, choose general section area. In Word 2003, click the General tab.
3. In the “When creating new workbooks” section, we can change the number of sheets at will from the “Include this many sheets” dropdown. In Word 2003, use the Sheets In New Workbook dropdown.
3: Change Worksheet Tab Color
Worksheet tab color is the same color as the worksheet by default. However, if we want to change worksheet tab color, we can do as the follow steps below:
1. Right-click the sheet tab.
2. Choose Tab Color.
3. Select a color!
Worksheet tab color is the same color as the worksheet by default. However, if we want to change worksheet tab color, we can do as the follow steps below:
1. Right-click the sheet tab.
2. Choose Tab Color.
3. Select a color!
If we want to apply the same color to multiple worksheet tabs, we can group them first. Wish these threes Excel worksheet tricks are useful for all of you. By the way, what are your favorite Excel worksheet tricks?