I did it as a three step process. If you read the message you Replied to you'll see that the number of Columns & Rows is fixed.For Excel 2011 on Mac its different. After that, press Ctrl + A to select the filtered data. In situations when you want to select or copy rows with relevant data, use Excel's AutoFilter to filter such rows. Done In the screenshot below, we are deleting rows containing 'dress': If cell contains, select or copy entire rows. In the Delete dialog box, select Entire row, and click OK.
![]() Add In To Highlight Row And Column Of Active-Cell In Excel 2011 Update Level OfAI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. As well as your present version update level of Office. Indicate the specific steps being taken, a description of the worksheet, etc. It's never to your advantage to tack a question onto another user's conversation even though it maySeem to be related.
0 Comments
Leave a Reply. |
Details
AuthorKaren ArchivesCategories |