0
What do you use in Excel to move to a cell in a part of the worksheet you cannot see?
There are lots of ways you could do it. You could use the Page Up or the Page Down keys. You could use the Goto option by pressing the F5 key and typing in a cell address. You could also create a link in a cell that when you click will bring you to another part of the worksheet. You could also use a Custom View to jump to another part of a worksheet.
What else can I help you with?
How do you move a worksheet in Excel 2007?
The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.
What is the function of the MS Excel vertical scrollbar?
It enables you to move up and down the worksheet.
Explode Excel worksheets into separate Excel workbooks?
If your Excel workbook has several worksheets and you want to save them into separate Excel workbooks, try the following: Position your mouse on the worksheet tab (bottom left of the screen). Right mouse click on the worksheet tab and select "Move or copy" from the shortcut menu. This opens the Move or Copy dialog box. In the "To book:" field, choose "(new book)"Click the check box for Create a copy if you want to keep the worksheet in the original workbook, or leave it unchecked if you want to move the worksheet from the original workbook. Click OK to finish the steps.
What is the use of move or copy sheet tab in Microsoft Excel?
If you have two workbooks and want to move a worksheet from one to the other, you would use the move option. If you want to copy the worksheet so that it is in both workbooks, you would use the copy option.
What key do you use on the keyboard to navigate a worksheet?
The F5 key is used on the keyboard to navigate a worksheet in Microsoft Excel. This allows you to use the "Go To" feature and move around the various cells on the sheet.
When typing in a cell in Excel what does a TAB do?
The Tab key will move from one cell to the next in Excel, or through different options in a dialog box if one is open. If you are typing when you hit the tab key it will enter what you have typed into that cell and move the cursor one cell to the right.
What is the key that selects the cell down one worksheet window from the active cell?
If you have multiple worksheets open, then Ctrl - PageDown will move to the one to the right. If you have a number of panes on a worksheet, the F6 and the Shift-F6 key combinations can be used to move between them.
What to do when in excel worksheet pointer not work as copy pointer or as move pointer?
All you need to do is just press the arrow keys and the cursor will move in the direction of the arrow that has been pressed. If you press and hold the one of the Shift keys at the same time, then it will also select cells as the cursor moves.
What is navigate in MS Word or Excel?
To navigate is to move around. In Word or Excel you need to move around your document or worksheet. You can do this in lots of ways. You can click on different parts of your page or worksheet. You can use the navigations keys, which are the cursor keys, Home, End, Page Up and Page Down. In combination with other keys you can navigate in different ways. You can also navigate using bookmarls.
What Selects the cell one worksheet window to the right?
If you have multiple worksheets open, then Ctrl - PageDown will move to the one to the right. If you have a number of panes on a worksheet, the F6 and the Shift-F6 key combinations can be used to move between them.
Shortcut key to jump to the last row in Excel?
To move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column, press and hold the Ctrl key and then press the End key. If you want to go to the actual last row of the entire worksheet, use the Goto command, which you can activate by pressing F5. Then you need to type in the address of the cell that you want to go to.
When data is entered into a cell by pressing the enter key the cell pointer will?
It will normally move to the cell underneath it, but you can change the settings in Excel so that it does not do that.
