Google Sheets is similar to Microsoft Excel and many of Excel’s features are replicated or mirrored inside Sheets, making it easy to make the switch from Microsoft’s productivity suite to Google’s own offerings. Users with basic spreadsheets (those without custom macros or design elements) can in fact just directly import their Excel files into Sheets without any problems or glitches. Show
One problem that spreadsheet users have had is that in the process of importing and collating data from multiple sources (one of the many tasks that spreadsheets are great at), it is not at all uncommon for random empty cells, rows, and columns to appear inside the document. Although this problem is manageable in smaller sheets, where you can just delete the rows manually, it’s a huge problem when it crops up in larger documents. However, removing these blank spaces is quick and easy if you know the proper steps. In this article, we’ll show you how to remove all the empty rows and columns in your Google Sheets document using an auto-filter. Deleting Empty Rows and Columns in Google Sheets using the Keyboard ShortcutIf you’re trying to delete all of the empty rows below your content, you can.
You can do the same for all the columns to the right of your data as well. Using the same commands as above, use the Right Arrow, highlight all columns, right-click, and delete. This leaves a much cleaner looking datasheet. Deleting Empty Rows and Columns using the Auto-FilterPut simply; an auto-filter takes the values inside your Excel columns and turns them into specific filters based on the contents of each cell—or in this case, the lack thereof. Though originally introduced in Excel 97, auto-filters (and filters in general) have become a massive part of spreadsheet programs, despite the small minority of users who know about and use them. Setting Up an AutofilterThe auto-filter function can be used for a number of different sorting methods. In fact, they’re powerful enough to sort and push all of the empty cells to the bottom or top of your spreadsheet.
To be safe, you can just have the filter cover the entirety of your document. To input this into your document, type something like A1:G45, where A1 is the starting cell and G45 is the ending cell. Every cell in between will be selected in your new filter. Using the Autofilter to Move Blank CellsThis next bit may seem a bit odd because it will be moving and reorganizing your data in a way that seems counterintuitive at best and destructive at worst.
This will likely make your data a confusing, unreadable mess—don’t worry, this will all work out in the end. Deleting Your Blank CellsOnce your blank cells have been moved to the bottom of your spreadsheet, deleting them is as simple as deleting any other cell.
Reorganizing Your SpreadsheetNow that you’ve removed the offending blank cells, you can reorganize your spreadsheet back to normal order. While clicking on that same triple-lined menu button from earlier inside the filter will only allow you to organize in alphabetical or reverse alphabetical order. There is another sort option: turning your auto-filter off.
Your spreadsheet will return to normal like magic but without the blank cells, you deleted earlier. With the cells deleted, you can resume reorganizing and adding data back into your spreadsheet. If, for whatever reason, this method causes your data to fall out-of-order, reversing it is as simple as diving into your documents’ history and reverting to an earlier copy. You can also use the copy and paste function to move your data around easily, without having to deal with hundreds of blank cells blocking your path. This isn’t a perfect solution but it does work to push your data above the mass of blank cells in your document. And at the end of the day, it’s a lot easier than mass-deleting rows one by one. How do I mass Delete columns in Google Sheets?Delete Multiple Cells in Excel or Google Sheets
If we want to delete columns with selected cells we have to choose Delete Sheet Columns under the tab Home-Cells-Delete.
How do I Delete multiple columns at once?To remove several columns, select the columns by using Ctrl + Click or Shift + Click. The columns can be contiguous or discontiguous. To remove all columns except the selected column, select one or more columns, and then select Remove Other Columns.
How do I Delete multiple rows and columns in Google Sheets?To select more than one row in the data view, click one row, then hold the Control (Windows) or Command (Mac) key and select each of the other rows you wish to edit or remove. To select a continuous list, click one row, then hold the Shift key and click the last row. Was this helpful?
How do I select multiple columns in Google Sheets?Select a row or column to resize. To highlight multiple rows or columns: Mac: ⌘ + click the rows or columns. Windows: Ctrl + click the rows or columns.
|