Navigation powered by "Ctrl" in Excel

Have you ever wondered the power of the key "Ctrl" while you are navigating in an excel worksheet or workbook...?


The best accelerator key for navigation in excel is "Ctrl"...




  • Move to the beginning of a row                  Ctrl + left arrow
  • Move to the end of a row                          Ctrl + right arrow
  • Move to the beginning of a column              Ctrl + up arrow
  • Move to the end of a column                      Ctrl + down arrow
  • Move to a different worksheets                   Ctrl + Page Up or Page Down
  • Juggle between active workbooks                Ctrl + tab
  • Move to the beginning of worksheet             Ctrl + home
Isnt this is a power house...? 

So next time you use excel.... dont forget your power key to navigate...!

Comments

  1. AnonymousApril 21, 2010 at 5:40 PM

    Bariya Hai..........

    ReplyDelete
  2. Arvind mpsSeptember 13, 2020 at 4:15 PM

    Arvind๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน๐ŸŒน

    ReplyDelete
  3. idrisiannaconeNovember 7, 2022 at 9:43 AM

    Gambling apps, although, are a billion-dollar rounding error in that noticeable bump. It's the equal of the money Apple can shake out of the sofa cushion. It's in all probability much less per yr than Apple will save by being more selective in hiring. We're not anticipating an enormous keynote speech about playing adverts connected to playing habit restoration apps. We do not suppose Apple will hold it up as exemplary corporate conduct in its earnings. It's easy to say that Apple has a lot money that it shouldn't be penny-pinching like ๋ฃฐ๋ › this, however after all {you do not get|you aren't getting|you do not get} to be profitable should you're not very careful with the underside line.

    ReplyDelete
  4. AnonymousDecember 8, 2022 at 1:17 PM

    House of Fun is meant for those 21 and older for amusement purposes solely ์ฝ”์ธ์นด์ง€๋…ธ and doesn't supply "real money" gambling, or a possibility to win real money or real prizes based mostly on sport play. Playing or success on this sport doesn't imply future success at "real money" gambling. If you like a bit extra of a challenge, might also|you can even} play slot machines with added options such as missions and side-games. It's a great way|a good way|an efficient way} to loosen up at the end of the day, and is a treat for your senses too, with beautiful graphics and immersive games. Slotomania is meant for those 21 and older for amusement purposes solely and doesn't supply ‘real money’ gambling, or a possibility to win real money or real prizes based mostly on sport play.

    ReplyDelete

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Image
" Ctrl + + " (add rows or columns) and " Ctrl + - " (delete rows or columns) are the easy shortcuts one may remember while adding and deleting rows/columns in Microsoft Excel. Adding rows or columns: If you wish to add rows above the current cell... just press "shift + spacebar" (discussed in my earlier post) to select the current row and then press "Ctrl + +". It will insert a row over the current row. Press "Ctrl + +" repeatedly to insert as many rows. Similarly, "ctrl + spacebar" and then "Ctrl + +" adds a column before the current column. You may try pressing "Ctrl + +" without selecting a row or a column. In such a case, you may get a pop-up (as shown in the image) where you can choose an option of adding a row or a column. Deleting rows or columns: "shift + spacebar" followed by "Ctrl + -" deletes the selected row & "ctrl + spacebar" followed by "Ct
Read more

"CountIF" or "SumIF" with an extra "S" makes the difference...

Image
Most of the users are very used to formula like " COUNTIF "or " SUMIF "... Excel offers "S" factor adding spice to these handy formulas...  Sumif: usual syntax is =Sumif(criteria range, criteria, sum range) where you want to sum a given range of cells based on a condition in another range of cells. "Sumifs" acts one step further. The syntax is =Sumifs(Sum range, Criteria range1, criteria1, Criteria range2, criteria2...) and go on to add upto 9 criteria . This is handy when we need to sum a range based on more than one criteria. Similarly, we are quite used to "Countif" formula while counting a given range based on a filter criteria. Just like sumifs, countifs offers the same operation with multiple criteria filtration. Countif syntax: =Countif(Count range, Criteria). The countifs syntax gets changed to =countifs(Criteria range1, criteria1, criteria range2, criteria2....) . This too works upto 9 criteria . Excel really mak
Read more

Alternative for SUMIF and SUMIFS

Image
Ever wondered while using "SUMIF" function, the sum range cannot be more than one column!!  This indeed is a big drawback while using a large data set where you need to sum matching certain conditions. I often end up using multiple sumif with "+" which makes the formula very long. So was thinking of some alternative that can make life easier. Thanks to the search engines these days, I did come across a workaround. Refer to the above image: In the above example, I have a table with 4 columns where H1 and H2 are identifiers. H3 and H4 is the data which needs to be summed up. Condition 1 (alternative for SUMIF): I need to sum values of H3 and H4 where the identifier H2 is "Y". The formula will be =SUM(IF(B2:B5=B9,C2:D5)) followed by Ctrl + Shift + Enter which will make it a array formula. The final formula will look like this:  {=SUM(IF(B2:B5=B9,C2:D5))} Condition 2  (alternative for SUMIFS) : I need to sum values of H3 and H4 where the
Read more