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

  • 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...
  • 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...
  • Remove Non Printable Items from Text
    To Remove None Printable items from the cell containing text we just have to use a simple formula =Clean(Cell number) For Example In cel...