Common terms in Excel [Worksheets]

User avatar
Administrator
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum
Contact:

Common terms in Excel [Worksheets]

Postby Administrator 06 Apr 2020, 12:55

Worksheet
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.
sheet1.png
sheet1.png (4.43 KiB) Viewed 532 times

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.
insert.png
insert.png (1.6 KiB) Viewed 532 times

Result
added-sheet.png
added-sheet.png (1.68 KiB) Viewed 532 times

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.
rename.png
rename.png (14.78 KiB) Viewed 532 times

3. For example, type Sales 2016.
specific-name.png
specific-name.png (1.55 KiB) Viewed 532 times

Move a Worksheet
To delete a worksheet, right click on a sheet tab and choose Delete.

1. For example, delete Sheet2.
delete.png
delete.png (15.01 KiB) Viewed 532 times

Result:
one-worksheet-left.png
one-worksheet-left.png (1.27 KiB) Viewed 532 times

Split
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.
split-worksheet.png
split-worksheet.png (8.55 KiB) Viewed 531 times

2. On the View tab, in the Window group, click Split.
click-split.png
click-split.png (8.66 KiB) Viewed 531 times

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.
view-distant-parts.png
view-distant-parts.png (8.67 KiB) Viewed 531 times

4. To change the window layout, use the horizontal split bar that divides the panes.
use-split-bar.png
use-split-bar.png (8.6 KiB) Viewed 531 times

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.
click-new-window.png
click-new-window.png (9.41 KiB) Viewed 531 times

Excel opens a new window containing another view of the document.

3. On the View tab, in the Window group, click Arrange All.
click-arrange-all (1).png
click-arrange-all (1).png (8.86 KiB) Viewed 531 times

4. Select the desired arrange setting. For example, click Horizontal.
horizontal-arrange-setting (1).png
horizontal-arrange-setting (1).png (2.99 KiB) Viewed 531 times

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.
view-multiple-worksheets.png
view-multiple-worksheets.png (12.51 KiB) Viewed 531 times
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.
view-side-by-side (1).png
view-side-by-side (1).png (8.23 KiB) Viewed 531 times

Spelling
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.
spelling-errors.png
spelling-errors.png (2.73 KiB) Viewed 531 times

2. On the Review tab, in the Proofing group, click Spelling.
click-spelling.png
click-spelling.png (2.94 KiB) Viewed 531 times

3. Select a suggestion and click Change to correct the misspelling in cell A2.
change.png
change.png (9.81 KiB) Viewed 531 times

4. Click Change All to correct all instances of this misspelling (cell A2 and cell A7).
change-all.png
change-all.png (9.78 KiB) Viewed 531 times

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.
add-to-dictionary.png
add-to-dictionary.png (9.71 KiB) Viewed 531 times

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.
custom-dictionaries.png
custom-dictionaries.png (33.48 KiB) Viewed 531 times

7a. Click AutoCorrect to add this word to your AutoCorrect list (every time you type anwer, Excel will replace it with answer).
autocorrect.png
autocorrect.png (9.65 KiB) Viewed 531 times

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.
autocorrect-options.png
autocorrect-options.png (33.12 KiB) Viewed 531 times
_____________________
Thanks & Regards
Saran BL

www.i-metrik.com

Was This Topic Useful?

Last 10 Members Who Visited This Topic

User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: No registered users and 1 guest