How to work in multiple windows in two Excel Workbook
You can see the names of the workbook when creating a new workbook window (worksheet-tutorial: 1 - Excel and workshet-tutorial: 2 - Excel). I reduced the screenshots to show in this tutorial. In this way you can work on two different worksheets in the same workbook or in two different workbooks (two different files).
Working in two horizontal windows on the same Workbook
If you want to work on the same Excel worksheet that contains a large amount of data, you do not have to constantly move scrolbar up and down, you can split the worksheet into two horizontal sections. At the top of the window, you can position the top of the worksheet and the second window, you can change the data at the bottom of the worksheet.
Working in two vertical windows on the same Excel workbook
If you have created a worksheet that contains a large amount of data that are placed in columns, you do not have to constantly move scrolbar left or right, you can split the worksheet into two vertical windows. In each window, positioning is particularly the data you want to watch while you make changes to the second part of the table or data.
If you want to move synchronously Scrollbar while working on two Excel window then turn on Synchronous Scrolling.
Rename or edit names of the worksheet in Excel
You, as a beginner who has just started to learn to work in Excel 2013 are probably wondering how to rename the name of the worksheet. If you want to change the name of the worksheet, then do the following (also see figure below instructions):
The first way to change the name of the worksheet in Excel:
- Right-click mouse on the name of the worksheet (worksheet tab)
- From the shortcut menu, choose the command Rename and then type the name of the worksheet
Another way to change the name of the worksheet in Excel:
- On the toolbar, the Home click to group commands Cells, click on the Format button, and then from the drop-down menu select the command Rename Sheet.
Assign Colors to Worksheet Tabs in Excel 2013
Excel 2013 allows us filling our color tab worksheet (worksheet name) a certain color. Coloring the names worksheet can be done in two ways
On the toolbar, the 'Home' in the group 'Cells' commands click to order 'Format' and then from the drop-down menu or drop-down list, choose the command 'Color Tab' and then the frame with the template color, choose the color you want.
The second way is called a coloring worksheet via the shortcut menu. Click on the Worksheet tab, right-click mouse, and then the command 'Tab Color' and the box containing the templates color choose the color you want to paint the name of the worksheet in Excel.