USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
no, you can put part of your worksheet on another tab
|
|
|
yes, click on the cell you want to split, view tab, window group, split button
|
|
|
yes, click on the cell you want to split, right click, split button
|
|
|
no, what is split?
|
Detailed explanation-1: -When you split a sheet into separate panes, you can scroll in both panes independently. Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.
Detailed explanation-2: -Split cells In the table, click the cell that you want to split. On the ribbon, select the Layout tab. Select Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.
Detailed explanation-3: -The Split button is found on the View tab of the ribbon. To split your screen vertically, select a cell in the top row and click the Split button. A divider will appear which you can drag left or right to adjust the size of the two panes. Scroll from side to side in one pane and the other won’t move.
Detailed explanation-4: -Then click the “View” tab in the Ribbon. Then click the “Split” button in the “Window” button group to split the current worksheet into four separate panes. This lets you scroll each pane to independent sections of the same worksheet. You can click the “Split” button again to remove the split panes, when finished.