I accidentally discovered that some of those cell navigation keys work differently when a block of data is selected. To move between unlocked cells on a protected worksheet Move to the last unused cell in the bottom-most row Move to the edge of the current data region When you are working on one, you know how often you have to move from cell to cell and from one end to the other. And, that’s because Excel is all about data in cells. These are keys you will require almost always. Move to the next/previous worksheet pane in a worksheet that has been split Move to the previous sheet in the workbook And, to navigate to different workbooks we take help of the Windows taskbar.
Most of us use the mouse to navigate to adjacent worksheets on a workbook. Tip: We have another super guide on all MS Excel shortcut keys that work with Function keys (F1 through F12) combination.
0 kommentar(er)
