USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
makes it so the rows are visible when scrolling through the worksheet
|
|
|
makes it where another user can not edit those rows
|
|
|
makes it where it hides the rows
|
|
|
it makes your computer screen cold so it won’t overheat while you are working in excel for a long period of time
|
Detailed explanation-1: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-2: -Freezing panes allows you to keep certain rows or/and columns visible when scrolling across the worksheet. Splitting panes divides the Excel window into two or four areas that can be scrolled separately. When you scroll within one area, the cells in the other area(s) remain fixed.
Detailed explanation-3: -Freeze panes to lock specific rows or columns 2. On the View tab, in the Window group, click the arrow below Freeze Panes. time, click Freeze Panes. Unfreeze Panes so that you can unlock any frozen rows or columns.
Detailed explanation-4: -On the View tab, click Freeze Panes > Freeze Panes.