About 1,118,707 results (3,164 milliseconds)
Giant blank space in document - tried removing all format, normal ...
https://support.google.com/docs/thread/37309312/giant-blank-space-in-document-tried-removing-all-format-normal-text-no-spacing?hl=en Apr 1, 2020 ... All of Docs templates are based on tables. I was able to remove the excess space by right-clicking in that cell and selecting Table properties > ...
How to remove empty cells from arrayformula result - Google Docs ...
https://support.google.com/docs/thread/259614391/how-to-remove-empty-cells-from-arrayformula-result?hl=en Feb 19, 2024 ... The result sorts the numbers (from A) in C but, also leaves blanks. | C |. 1|1114443333|. 2| |.
Removing Dead Space at the Top or Bottom of a Cell in Docs ...
https://support.google.com/docs/thread/20562048/removing-dead-space-at-the-top-or-bottom-of-a-cell-in-docs?hl=en Nov 20, 2019 ... Do I have that right? If so, please make sure that under "line spacing" there is no added space before/after paragraphs. If you don ...
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 ... Click "Clear" to clear all values, then click (Blanks) so that it is the only item checked; Click OK; Select all empty rows with your mouse, ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Split data into columns You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column ...
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 ... Your regex ^(\s*)$ will find cells that contain white space, or that ... Clear search. Close search. Main menu.
Reducing size of worksheets - Google Docs Editors Community
https://support.google.com/docs/thread/176566821/reducing-size-of-worksheets?hl=en Aug 25, 2022 ... You can go in and remove any blank space by selecting the empty columns and/or rows, right-clicking on the selected cells or the header and selecting Delete ...
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... The goal is to keep from having to type each character in a cell (boo carpal tunnel). Any ideas??? FYI using "Data-->Cleanup-->Trim White Spaces ...
TRIM function - Google Docs Editors Help
https://support.google.com/docs/answer/3094140?hl=en Google Sheets trims text input into cells by default. It is important to use TRIM when text is used in formulas or data validation because spaces in front of or ...
Large space that I cannot delete in my document! - Google Docs ...
https://support.google.com/docs/thread/6485484/large-space-that-i-cannot-delete-in-my-document?hl=en May 20, 2019 ... ... blank spaces equivalent to several lines of text that I can't remove. When I try to overcome the problem by typing text above the blank ...
Remove blank rows from IMPORTXML result - Google Docs Editors ...
https://support.google.com/docs/thread/35415791/remove-blank-rows-from-importxml-result?hl=en Mar 24, 2020 ... ... columns from a table on a web page. The actual items are returned properly. However, it lists each item with a space in between. How can I ...
add 1 empty cell inbetween unique function result - Google Docs ...
https://support.google.com/docs/thread/110891774/add-1-empty-cell-inbetween-unique-function-result?hl=en May 23, 2021 ... I think Jen is requesting to ADD empty cells between unique values, not eliminate the blank cell that normally is included. ... spaces as it will ...
Remove line above table - Google Docs Editors Community
https://support.google.com/docs/thread/32571948/remove-line-above-table?hl=en Mar 6, 2020 ... I have a document with a blank line at the top of the document above a table. ... There isn't any way to remove the line space completely. If you' ...
Export from Jasper reports to Excel
https://groups.google.com/g/idempiere/c/aBWPwW2LHGY Jul 20, 2023 ... ... remove.empty.space.between.columns" value="true"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value ...
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 ... Now drag-select with your mouse your list you created in the empty column, INCLUDING the blanks cell at the top. If you followed these ...
Replicate copy/paste "Skip Blanks" Excel functionality in Google ...
https://support.google.com/docs/thread/13401481/replicate-copy-paste-skip-blanks-excel-functionality-in-google-sheets?hl=en Sep 2, 2019 ... I used to do so in excel, copy the data from the reports and then use the paste functionality "Skip Blanks" to not overwrite my formula cells with empty cells.
How can I exclude blank cells from a filter function? - Google Docs ...
https://support.google.com/docs/thread/24137024/how-can-i-exclude-blank-cells-from-a-filter-function?hl=en Dec 29, 2019 ... So how do I get the filter formula to distinguish between a blank cell and a cell with 0 as I don't want the text of any unanswered questions to ...
Google Sheets automatically adds newline when editing cell ...
https://support.google.com/docs/thread/18235069/google-sheets-automatically-adds-newline-when-editing-cell?hl=en Oct 31, 2019 ... It doesn't help the annoyance but you can use the menu data - trim whitespace to remove the extra line. ... blank space. This changes the ...
arrays stacked vertically, omitting blanks - Google Docs Editors ...
https://support.google.com/docs/thread/32446468/arrays-stacked-vertically-omitting-blanks?hl=en Mar 5, 2020 ... I am having difficulty adding a nested query (or similar) to remove the blank rows from the stacked array. Attached is a screen shot of the ...
Docs keeps automatically adding a space after paragraph in my ...
https://support.google.com/docs/thread/16410311/docs-keeps-automatically-adding-a-space-after-paragraph-in-my-tables?hl=en Oct 9, 2019 ... ... Spacing, then select Remove Space After Paragraph. Worse, Docs sometimes doesn't apply spacing after paragraphs to all cells in the table ...