how to select entire row in excel keyboard shortcut

But those are the keys associated with it. Youre isolated, youre alone, youre ungrouped. On the Mac, the memory tricks are a little bit cuter I think, kumbaya is all that coming together as one group and jerk I dont like camp songs. So, shift your alternative political views to the right, you get the deal.

Left is more liberal, open, exposed, ungrouped.

In contrast, the shifting the alternative political views to the left. Think of right as conservative closed, hidden, grouped together. What you want to be able to do is select those cells, right, that actually have the grouping and then use your SHIFT + ALT + LEFT if youre on a PC or SHIFT + COMMAND + J if youre on a Mac and that will ungroup it and then youll lose the ability to hit the plus or minus sign.įun little memory tricks on how to keep these shortcuts at the top of your mind, if you are on the PC you want to think of shifting your alternative political views to the right. To do the reverse, to actually ungroup the cells that have been grouped already. What happens is not only am I able to expand or collapse by using the plus or minus, but I can actually interact with this interface in such a way that its visible and its obvious and its clear to the user, which is something that does not happen with hiding and unhiding. So, I want to go ahead and select a couple of columns and then use my SHIFT + ALT + RIGHT if Im on a PC or SHIFT + COMMAND + K if Im on a Mac. In contrast, this is all about grouping and ungrouping rows and columns which is actually the same thing except for one key difference. In the previous video, I showed you how to hide and unhide rows and columns. In this video, Im going to teach you the shortcut on how to group and ungroup rows and columns. Have you ever looked at a spreadsheet and had the reaction of, whoa, too much information? If so, chances are that theres information that could have been grouped and hidden from view. In this video, I will teach you how to group and ungroup rows and columns to only show whats relevant and important.ĭownload FREE Hands-On Exercises Full Video Transcript: Detailed spreadsheets are great, but sometimes seeing everything all at once can be overwhelming and confusing.

How to select entire row in excel keyboard shortcut