{"id":1,"date":"2018-06-25T14:14:26","date_gmt":"2018-06-25T14:14:26","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1"},"modified":"2024-03-14T13:28:59","modified_gmt":"2024-03-14T13:28:59","slug":"selecting-rows-and-columns","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/selecting-rows-and-columns\/","title":{"rendered":"Selecting Rows and Columns"},"content":{"rendered":"\n

In the previous lesson, I presented a few ways to select cells and ranges. This time, I will show you a few methods for selecting columns and rows.<\/p>\n\n\n\n

Selecting with mouse<\/h2>\n\n\n\n

To select multiple columns at once, click one of the letters at the top of the worksheet area and without releasing the mouse button, drag it to the right or left. In the same way, you can also select rows.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Selecting non-adjacent rows or columns<\/h2>\n\n\n\n

If you want to select multiple non-adjacent rows, you can do this by clicking the rows’ numbers while holding down the Ctrl<\/strong> key.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Using keyboard shortcuts to select rows and columns<\/h2>\n\n\n\n

You can also select rows or columns<\/a> by using the keyboard shortcuts. Use Shift + Space<\/span><\/strong> to select the entire row and Ctrl + Space<\/span><\/strong> to select the entire column.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Excel 365 Update<\/h2>\n\n\n\n