To restore normal use of the Excel arrow keys for movement between cells, we must turn OFF Scroll Lock. Once pressed, Excel Scroll Lock is switched ON. The image on the left shows the function's route and the screenshot on the right demonstrates how you can use the OFFSET. As the result, this OFFSET formula returns the value in cell B4. And also, scroll left one column, or right one column.Įxcel arrow keys Scroll Lock is a toggle lock key enabled on the keyboard similar to the CAPS LOCK keyboard key. The formula tells Excel to take cell A1 as the starting point (reference), then move 3 rows down (rows argument) and 1 column to the left (cols argument).
However, if we press those same arrow keys while Excel arrow keys Scroll Lock is turned on, we can only scroll up one row, or down one row. Typically, when we select cell on an Excel sheet and then click on the arrow keys (keyboard), our selection cursor moves across each cell, either up, down, right, or left depending on which arrow key is pressed. Use the (Down Arrow key) to select the Entire column, and press Enter. Press Shift + (Right Arrow key) to select multiple cells. Whenever Scroll Lock is enabled, we can use the Excel arrow keys for scrolling through our worksheet without affecting the highlighted cell. Select the cell into which you want to insert a blank column. They are great for skimming through data.Įxcel arrow keys Scroll Lock is displayed on the status bar. The arrow keys in Excel allow us to scroll through our worksheet without changing the highlighted cell.
#Excel shift cells right but skip column how to#
How to use the Arrow keys Scroll in Excel – Excelchat
0 kommentar(er)
