Friday, January 29, 2010

Moving to the last or first cell in the rang

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.
at

1 comment:

  1. Michael LengAugust 10, 2018 at 2:36 PM

    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.

    Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above

    ReplyDelete

Subscribe to: Post Comments (Atom)

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...

  • Web Page from MS Excel
    If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...