Shortcut to select rows or columns in Excel

Have you ever tried selecting an entire row or a column without the click of a mouse...?


Its very simple!


To select a row use "Shift + spacebar" and to select a column use "Ctrl + spacebar"..! These two shortcuts used together i.e. "Shift + Ctrl + spacebar".... the entire worksheet gets selected..!


Isn't it easy?

Comments

  1. proofread my dissertation at low costMarch 17, 2018 at 3:48 AM

    If you need my experience I can share it and I ma pleased to help you.

    ReplyDelete
  2. kavyagaurJuly 9, 2020 at 6:57 PM

    Your post is very great.i read this post this is a very helpful. i will definitely go ahead and take advantage of this. You absolutely have wonderful stories.Cheers for sharing with us your blog. python training in noida

    ReplyDelete
  3. DucatDecember 18, 2020 at 11:57 AM

    My Name is Abhay Kumar. I’m a Blogger living in India. I am a fan of technology, design, and writing. I’m also interested in programming and blog. I would like to share articles related to SEO, blogging tutorials, WordPress Tutorial, Make money online. You can read my blog.https://www.ducatindia.com/python-training-course-in-gurgaon

    ReplyDelete
  4. DucatFebruary 26, 2021 at 10:14 AM

    My Name is Abhay Kumar. I’m a Blogger living in India. I am a fan of technology, design, and writing. I’m also interested in programming and blog. I would like to share articles related to SEO, blogging tutorials, WordPress Tutorial, Make money online. You can read my blog.
    ethical hacking training in gurgaon

    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

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

Solving issues with "VLOOKUP"

Image
VLOOKUP syntax We often encounter "#N/A" while using VLOOKUP function to compare two lists. One of the most common problems that give rise to this error is extra spaces either to the end or to the beginning of the string. What's the way out? The simplest way out is to use "TRIM" function as a sub function. Example While trying to use VLOOKUP in the normal course, the result will be "#N/A", whereas with TRIM nested in the VLOOKUP function will give the positive result. (TRIM function removes the unwanted spaces in the beginning and end of a string.)
Read more