As you all know there are to ways that we could do any task in excel one with mouse and another with keyboard.
1. With Keyboard
• Vertically from top to bottom, press Ctrl+Down Arrow.
• Vertically from bottom to top, press Ctrl+Up Arrow.
• Horizontally from left to right, press Ctrl+Right Arrow.
• Horizontally from right to left, press Ctrl+Left Arrow.
1. With Mouse
Double-click one edge of the selected cell when the mouse image changes to four directional arrows.
That's a very good shortcut key. It helps to save time and operate it with more ease. Thank you so much for your useful article.
ReplyDeleteCtrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above