4/16/2023 0 Comments Excel 2016 bible for mac![]() Then select the Blanks radio box and click OK. ![]() Now, in the Go To screen, click the Special button. If you use the Mac version of Excel, you can find this function under Edit > Find > Go to. That’s it! Now your workbook looks better. ![]() In my case, I want the empty columns removed. This makes it easy to delete the cells you don’t want.įrom the Home tab, under the Cells group, click Delete and then choose whether you want to delete the blank cells in rows or columns. You’ll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet. Under the Home tab > Editing group, click Find & Select and then click Go To Special.Ĭhoose the Blanks radio box and click OK. To do so, highlight just the range of data containing the blank cells. Between each column, there are blank cells those are the cells I want to delete. The screenshot below displays a workbook with data in multiple columns. Delete Blank Cells within an Excel Workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |