A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
Select a Worksheet
When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its sheet tab at the bottom of the document window.
Insert a Worksheet
You can insert as many worksheets as you want. To quickly insert a new worksheet, click the plus sign at the bottom of the document window.
Rename a Worksheet
To give a worksheet a more specific name, execute the following steps.
1. Right click on the sheet tab of Sheet1.
2. Choose Rename.
3. For example, type Sales 2016.
Move a Worksheet
To delete a worksheet, right click on a sheet tab and choose Delete.
1. For example, delete Sheet2.
Split your worksheet to view multiple distant parts of your worksheet at once. To split your worksheet (window) into an upper and lower part (pane), execute the following steps.
1. First, select a cell in column A.
2. On the View tab, in the Window group, click Split.
3. Notice the two vertical scroll bars. For example, use the lower vertical scroll bar to move to row 49. As you can see, the first 6 rows remain visible.
4. To change the window layout, use the horizontal split bar that divides the panes.
5. To remove the split, simply double click the split bar.
Note: in a similar way, you can split your window into a left and right pane by selecting a cell in row 1 before you click View, Split. You can even split your window into four panes by selecting a cell that is not column A or row 1. Any changes you make to one pane are immediately reflected in the other ones.
View Multiple Worksheets
If you want to view multiple Excel worksheets at the same time, execute the following steps.
1. Open a workbook.
2. On the View tab, in the Window group, click New Window.
Excel opens a new window containing another view of the document.
3. On the View tab, in the Window group, click Arrange All.
4. Select the desired arrange setting. For example, click Horizontal.
5. Click OK.
The titles (view-multiple-worksheets:1 and view-multiple-worksheets:2) indicate that two windows of the same file are open.
6. In the lower window, select the sheet tab of Wk2. You can now view the sales in week 1 and week 2 at the same time.
Note: any changes you make to one window are immediately reflected in the other window.
7. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both worksheets at the same time.
Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list.
1. Open a worksheet with some spelling errors.
2. On the Review tab, in the Proofing group, click Spelling.
3. Select a suggestion and click Change to correct the misspelling in cell A2.
4. Click Change All to correct all instances of this misspelling (cell A2 and cell A7).
5. Click Ignore Once to ignore the misspelling in cell A2. Click Ignore All to ignore all instances of this misspelling.
6a. Click Add to Dictionary to add this word to your custom dictionary.
6b. To edit this list, click Options (or if you don't have this screen open, click File, Options, Proofing), and then click Custom Dictionaries.
7a. Click AutoCorrect to add this word to your AutoCorrect list (every time you type anwer, Excel will replace it with answer).
7b. To edit this list, click Options (or if you don't have this screen open, click File, Options, Proofing), and then click AutoCorrect Options.
1 post • Page 1 of 1
Was This Topic Useful?
Last 10 Members Who Visited This Topic
Who is online
Users browsing this forum: No registered users and 1 guest