Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Work in multiple windows one workbook in Excel

How to work in multiple windows two workbook in Excel 2013

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.

How to see or work simultaneously in two horizontal windows on one worksheet in Excel 2013

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.

Vertical spliting workbook or worksheet on two working window in Excel 2013
If you want to move synchronously Scrollbar while working on two Excel window then turn on Synchronous Scrolling.

How to synchronize and coordinate simultaneous slip or move data to two working window in Excel 2013

Rename or edit names of the worksheet in Excel 2013

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.

How to change the name of the worksheet in Excel

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 commands 'Cells' click to order 'Format' and then from the drop-down menu or drop-down list, choose the command 'Tab Color' 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 color of the template choose the color you want to paint the name of the worksheet in Excel.

How to color the tab or the name of the worksheet in Excel