If you click the mouse wheel and move your mouse up or down it also scrolls the screen. You might already be using mouse wheel to scroll up or down the windows. It will scroll the worksheet by one screen height or width. Scroll the screen using key board arrow key without changing the active cell.Įxcel Tip #2 – Scroll a complete screen in excel at onceĬlick either side of the scroll bar within the scroll box area.Now you can scroll the worksheet screen using arrow keys.You will be able to see a status bar note at bottom left corner of the window that it has activated the “Scroll Lock” mode. Activate the scroll lock by pressing the “Scroll Lock” key or “fn” + “Scr lk” keys depending on the keyboard.In the laptop keyboards this key might be provided as a secondary function key along with a main key such as “Num lock”. There is a key called “Scroll lock” in the standard keyboard.What you have to do is very simple to activate this scroll mode. Sometimes it will be handy to scroll the screen using keyboard while keeping the active cell unchanged. If you press the arrow keys while in excel worksheet it changes the active cell based on the arrow key direction you are pressing. Excel Tip #1 – Screen Scroll with arrow keys in excel while scroll lock on
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |