In fact, it works exactly like selecting rows.Ĭlick a column letter to select the column. Sometimes, you may want to select an entire column of cells. Select One or More Entire Columns of Cells In the image below, we’ve deselected two rows from a selected range by holding down the Ctrl key while clicking the row numbers of the rows we didn’t want in the selection. In the image below, we’ve selected several rows that are noncontiguous.Īnd, just like with individual cells, you can also use the Ctrl key to deselect rows from a selected range. Then hold down your Ctrl key while clicking the row numbers of additional rows you want to add to the selection. To select noncontiguous rows, click the row number of a row you want to select. ![]() Either way, you’ll select a range of rows. Click on the drop-down button for any data column > deselect Blanks in the Filter. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select. Once you click on Filter, all the data columns will have drop-down buttons. ![]() I have had no such problem since I saved it to the new version. It started when I transferred my spreadsheet, produced by Office 2011 on OS 10.11, to my new computer, with the latest version of MacOS and MS 365. Continuing to hold down your mouse button, drag your cursor across all the rows you want to select. In reply to Neha Singh MSFT's post on January 29, 2022.
0 Comments
Leave a Reply. |