About 1,975,542 results (2,459 milliseconds)
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... Is there a way to delete every blank row on a sheet without highlighting, right clicking and then deleting? And only being able to do the rows ...
Replacing empty cells via Find and Replace not working - Google ...
https://support.google.com/docs/thread/217248400/replacing-empty-cells-via-find-and-replace-not-working?hl=en May 23, 2023 ... It looks like the Edit > Find and replace feature in Google Sheets can locate zero-length text strings "" but cannot locate truly blank cells.
How do I clear contents of a cell or multiple cells? - Google Docs ...
https://support.google.com/docs/thread/120509506/how-do-i-clear-contents-of-a-cell-or-multiple-cells?hl=en Aug 9, 2021 ... To clear multiple (discontinuous) cells, select the first one, hold down <Ctrl>, then click on the other cells you want, and then the Delete key.
How do I mass remove line breaks in Google Docs? - Google Docs ...
https://support.google.com/docs/thread/4814034/how-do-i-mass-remove-line-breaks-in-google-docs?hl=en Apr 24, 2019 ... ... cell - say a cell in Column C, cell C1. Solution : 1. back up your spreadsheet ;)!. 2. in a separate cell / separate column - away from your ...
This has to be simple, but how do I turn off insert, or overwrite of text ...
https://support.google.com/docs/thread/3653333/this-has-to-be-simple-but-how-do-i-turn-off-insert-or-overwrite-of-text-in-cells?hl=en Apr 5, 2019 ... What I tried is the following; click on an empty cell and then press ... If You have No Insert Key - Just click the cell & Remove num-lock and ...
How can I insert paste instead of replace paste in Sheets? - Google ...
https://support.google.com/docs/thread/3408051/how-can-i-insert-paste-instead-of-replace-paste-in-sheets?hl=en Apr 1, 2019 ... ... Excel? I'm not seeing it in the menu, in searches in your ... If an extra blank row is left in place of the moved rows, just delete it.
Keyboard shortcuts for Google Sheets - iPhone & iPad - Google ...
https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DiOS ... cell to the next empty cell in the specified direction. ⌘ + Shift + Up/Down/Left/Right arrow. Delete content from cell, Backspace/Delete. Give feedback about ...
How to add a blank option in a data validation drop down list ...
https://support.google.com/docs/thread/5750893/how-to-add-a-blank-option-in-a-data-validation-drop-down-list?hl=en May 8, 2019 ... The delete key is genius!!! ... Now drag-select with your mouse your list you created in the empty column, INCLUDING the blanks cell at the top.
Removing a blank page at end of a document - Google Docs Editors ...
https://support.google.com/docs/thread/54884155/removing-a-blank-page-at-end-of-a-document?hl=en Jun 22, 2020 ... I've never seen a separate 'delete-key', at least I cannot find one on a Mac-keyboard. Unless you mean a short-cut key of some kind? Of course I ...
I cannot delete a row in Google Docs - Google Docs Editors ...
https://support.google.com/docs/thread/112404269/i-cannot-delete-a-row-in-google-docs?hl=en Jun 4, 2021 ... When I right-click on one of the table rows (where ... Put your cursor in the blank space between row #7, and the row you want to delete.
how do you delete unwanted rows and columns when there is 100s ...
https://support.google.com/docs/thread/46063392/how-do-you-delete-unwanted-rows-and-columns-when-there-is-100s-of-them?hl=en May 11, 2020 ... Select whole range of unwanted/empty rows/columns that are together. Hold CTRL+SHIFT+[arrow key] to select all cells in the row/column, depending on direction.
Google Sheets "no fill" option for cell color? - Google Docs Editors ...
https://support.google.com/docs/thread/236813187/google-sheets-no-fill-option-for-cell-color?hl=en Sep 27, 2023 ... I imported an excel file to Sheets without cells filled in any colored. I colored the cells in Sheets, but now I want to change them to No ...
Optional Button for Adding Rows & Columns & Way to Add >1 at a ...
https://support.google.com/docs/thread/152809645/optional-button-for-adding-rows-columns-way-to-add-1-at-a-time?hl=en Mar 1, 2022 ... Even when using hotkeys to add 15 rows, it takes a long time. ... empty rows at the end then it will add columns. The formula is meant ...
Un-merge entire spreadsheet at once - Google Docs Editors ...
https://support.google.com/docs/thread/149539545/un-merge-entire-spreadsheet-at-once?hl=en Feb 5, 2022 ... ... delete the extra row? ... This would copy the formatting of the selected cell to the entire spreadsheet, separating any merged cells in the ...
Formula to remove blanks and shift data - Google Docs Editors ...
https://support.google.com/docs/thread/23664448/formula-to-remove-blanks-and-shift-data?hl=en Dec 23, 2019 ... I would like to delete these empty cells and shift data to line up removing the blanks. In Excel, I know you can use Ctrl + G and select the empty cells, then ...
How do I Insert Multiple Rows in spreadsheet easily - Google Docs ...
https://support.google.com/docs/thread/1955600/how-do-i-insert-multiple-rows-in-spreadsheet-easily?hl=en Mar 1, 2019 ... how do you remove them. L. Llewellin Belton. Dec 29 ... If the cells requiring splitting are blank, you can highlight two adjacent empty cells ...
how to insert blank row between each change in dates in google ...
https://support.google.com/docs/thread/25744916/how-to-insert-blank-row-between-each-change-in-dates-in-google-sheets?hl=en Jan 16, 2020 ... ... shortcut work, choose Help > Keyboard shortcuts > Enable compatible spreadsheet shortcuts. It is unclear why you want to insert the blank rows.
Add or move columns & cells - Android - Google Docs Editors Help
https://support.google.com/docs/answer/54813?hl=en&co=GENIE.Platform%3DAndroid You can add, change, move, or delete your spreadsheet's columns, row, or cells. Android ComputeriPhone & iPad. More. More. More. Add rows or columns. On your ...
How to clear a column of values without losing headers? (header ...
https://support.google.com/docs/thread/2687134/how-to-clear-a-column-of-values-without-losing-headers-header-rows-are-frozen?hl=en Mar 19, 2019 ... That should put headers for the three columns and if you delete columns B and C they will come back automatically. ... It will not skip over blank ...
How to remove data validation for selected cells - Google Docs ...
https://support.google.com/docs/thread/193872200/how-to-remove-data-validation-for-selected-cells?hl=en Dec 21, 2022 ... Select cells, open the data validation menu and remove validation. The data validation menu has been changed to a list of rules for the whole spreadsheet.