Questions tagged [formatting]

Styling information beyond the minimum of semantic elements: colours, styles (boldface, italic), sizes and special features.

Filter by
Sorted by
Tagged with
0 votes
1 answer
11 views

Google Sheets formula to format substrings of column concatenation?

If I have a spreadsheet with columns for author, year, title, publication, etc, could I add a column that concatenates and formats those as a citation for a bibliography? It would be something like ...
user avatar
  • 255
0 votes
1 answer
29 views

How do I keep exact text formatting when using a data validation dropdown list in Google Sheets?

I have a column that contains a bold number and a non-bold text part. I want to use this information as a drop-down selection list, but it currently isn't letting me keep the bold formatting on only ...
user avatar
0 votes
1 answer
33 views

How to copy plain text HTML/formatting method into Google Docs

I currently have a script that generates an amount of text. I want this script to be able to output some text with a formatting style into STDIN (preferably MD/HTML) and I can then paste it into ...
user avatar
0 votes
0 answers
16 views

Convert text color to text background in Google Slides

My project partner emphasized the text in a Google Slide document by changing the color of the text. This isn't ideal for a presentation when the slides must be at least 2 meters away from the ...
user avatar
  • 101
0 votes
1 answer
30 views

Conditional Formatting in Sequential Order in Sheets

I hope this all comes out clearly, I am in need of some help to save some major time. This is for sports betting tracking systems. I am trying to create a conditional format to where when I enter a ...
user avatar
0 votes
0 answers
122 views

How to permanently format column as plain text in Google Sheets?

I have a google sheet that reformats a csv. The desired functionality is the user pastes the csv contents into the sheet as plain text, and it is automatically formatted in a separate tab. I have all ...
user avatar
  • 1
0 votes
1 answer
93 views

Google Sheets: Re-enable default horizontal alignment -- numbers to right, text to left

Default horizontal alignment (in excel/Google Sheets) is great. Numbers go to right, text goes to left (even if it looks like number with accidental spaces in it). It is easy to spot visually the ...
user avatar
0 votes
0 answers
42 views

Hiding Google Sheets Formulas From Viewers

I've searched everywhere on the web, but couldn't find anything that helps me. I'm looking for a way to share a google spreadsheet but I want to hide my formulas from the viewers, the importrange ...
user avatar
0 votes
0 answers
17 views

Google Sheets Conditional Formatting for Expiration Dates with Colors

I need to create conditional formatting for expiration dates of gift certificates: Gift certificates are valid for 60 days. Cells should stay green between days 0-30 before expiration. Cells should ...
user avatar
0 votes
1 answer
24 views

When I input a number value in cell, can it auto format to show all numbers I input after decimal point

So 132.468 & -186.0152 & 167.03... I don't want to have click format button every time to adjust it to see the whole number.
user avatar
0 votes
1 answer
16 views

How to ask sub questions in google docs

I have already searched the internet for this but I'm getting solutions for only google forms and not google docs. I'm trying to create a simple MCQ paper that looks like this... Question one a. opt-...
user avatar
0 votes
0 answers
39 views

How to keep formatting with the column/ cell rather than cut when cutting and pasting data?

I work for a small mortgage company and we keep a Google spreadsheet active at all times with each officer’s open loans so that everyone has access to loan numbers and we can all keep track of where ...
user avatar
0 votes
0 answers
135 views

Short number format in Google Sheets in Indian format (Lacs, Crore etc); 1,53,642 → 1.54 Lacs, 28,18,76,724 → 28.19 Crore

How to truncate large numbers in Indian format? This question answers it perfectly for the US system. The custom number format for Million and Thousand is: [>999999]0.0,,\M;[>999]0.0,\K;0 Need ...
user avatar
0 votes
1 answer
597 views

How do I change the colors of most draw.io icons?

All I can find is documentation for changing "SVG" file colors on this page: https://www.diagrams.net/doc/faq/svg-edit-colours But most of the icons in the shapes library are not svg files, ...
user avatar
  • 1
3 votes
0 answers
38 views

Showing Inline Section Headers in Document Outline

I am attempting to follow the APA style guideline for section headers. Under their guidelines, there are 5 different styles of section headers. The first three levels are on their own line, but the ...
user avatar
1 vote
0 answers
60 views

Google Docs paste, using formatting of destination document

I want to copy/paste a bunch of content from one Google Doc to another. The two documents have different formatting (particularly fonts for Headings). If I do a regular paste (ctrl-v), the headings ...
user avatar
  • 509
0 votes
1 answer
72 views

draw.io: How to remove the tiny white space between two lines

If you were to align two straight lines, one on top of the other, such as this: A tiny white space exists between them. Is there any good way to remove such an artifact? Obviously in this case above ...
user avatar
  • 101
0 votes
1 answer
189 views

Google Sheets: How to format decimal as fraction in drop down list (data validation)

I have a cell with data validation. The source of the validation is a long range of decimals in 0.0078125 (1/128) increments. The cell containing the validation is formatted to display fractions # ???...
user avatar
1 vote
0 answers
24 views

Google Slides Default Paragraph Line Spacing

Google Slides has seemingly changed default paragraph styles in a recent update. Now, after pressing Enter (i.e. inserting a new paragraph), the last line on the previous paragraph gets extra line ...
user avatar
  • 111
0 votes
1 answer
803 views

System of equations in draw.io

I'm looking for a way to write a system of equations in draw.io. I know how to do it in latex, but it seems that the syntax is different in draw.io. Could you tell me how to do it please? In latex I ...
user avatar
0 votes
1 answer
297 views

A *faster* faster way to access Strikethrough on Google Docs

The keyboard shortcut for strike-through in the Google Docs web UI is AltShift5 (yes that is a five), and the toolbar doesn't have a strike-through button. It's very awkward (I actually have to swivel ...
user avatar
  • 267
0 votes
1 answer
120 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
user avatar
  • 1
0 votes
1 answer
77 views

Specifying the position of an element (e.g. line) in draw.io

I'm wondering if it's posssible to specify the exact position of a line in draw.io. It seems that the only way to do that is the reduce the size of the grid.
user avatar
1 vote
0 answers
17 views

Insert section break odd/even page

In Microsoft Word, when I insert a section break, I can tell it to start the next page on an odd page or even page: Is there a way to do this in Google Docs?
user avatar
  • 509
1 vote
0 answers
95 views

How to use unofficial features in Facebook group post editor?

Recently formatted text cannot be pasted into Facebook group post editor. It will be converted to plain text. This is inconvenient if you have a well formatted text, and now have to reformat it again. ...
user avatar
  • 742
7 votes
1 answer
7k views

How do I create a checklist in a slack message?

I'm trying to create a task list for myself in a private chat with my supervisor on Slack. I'm pretty familiar with markdown, and I thought that Slack supported it too. On GitHub, you can create tasks ...
user avatar
  • 71
1 vote
1 answer
35 views

Formatting options in Gmail

I used to be able to see the formatting options (bold, italic, strike-through, etc) next to the "Send" button, but since some months I can't see it anymore (as in image). How can I bring it ...
user avatar
  • 113
1 vote
1 answer
810 views

A Google Sheets format that returns time durations in days, hours, and minutes

I have a formula in a cell that returns the duration of a certain task in days. I'd like to express it in terms of days, hours, and minutes. (For instance, 3.25 might be written like 3 6:00.) I ...
user avatar
1 vote
0 answers
13 views

Is it possible to format row fill colour by a cell in an expandable way? if new job number, new row colour

I keep a to do list. Each row has a job number. There are several entries for each job number. I'd like to ask google sheets to look at the job number in column. Give the row a colour. Every time a ...
user avatar
2 votes
1 answer
2k views

How do I make double-line horizontal table borders in Google Docs?

I want to get a double-lined horizontal border for my table in Docs, like Word has. How do I do it?
user avatar
  • 301
0 votes
2 answers
4k views

Why can't these strings be formatted as numbers in Google Sheets?

In this sheet, the numbers are actually text. I tried Format->Number then Number, Percent and Scientific, and they still appear as text. As experiments: I cannot add 1 to these, and I cannot pass ...
user avatar
0 votes
1 answer
80 views

Cannot get rid of some space/margins

I'm working on my resume in Google Docs (Word processing) and I'm trying to add my name + personal information at the top, but I'm seeing a line of space above it. As you can see, I'm trying to get ...
user avatar
0 votes
1 answer
2k views

Google Sheets: Fill out dates and replace blank cells with zeroes

I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable: I think there are two reasons for this: Not all dates have values associated with them, and ...
user avatar
1 vote
1 answer
994 views

Does GitHub have an escape character for their markup?

Background I realize that markup is implementation without a specification but it basically is just a tiny little node stemming from SGML and the like. On GitHub I always use the ` symbol with a ...
user avatar
2 votes
1 answer
332 views

Google Docs: changing formatting of normal text without affecting automatically affecting headings

Applying a change to the indentation of normal formatting (e.g. first line indent) in google docs results in an automatic change to the indentation settings of all the other styles. It seems they have ...
user avatar
1 vote
1 answer
2k views

Finding merged cells in Google Sheets

I'm often trying to freeze columns in a Google Sheets and I get the error as below The way I get around this is to manually hunt for the merged cells and unfreeze them, but this can be difficult on ...
user avatar
  • 6,173
6 votes
5 answers
20k views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". In other words, I want to highlight them so that they can be copied, formatted, etc. How ...
user avatar
6 votes
4 answers
3k views

How do I keep borders when dragging down to fill cells?

I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill ...
user avatar
0 votes
1 answer
273 views

Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS

When I copy numbers using either "Edit/Copy" or "Crtl+C" in Google Sheets on PC and then use "Edit/Paste/Special/Paste Values" or (Crtl+shift+V), the numbers are indeed pasted. They appear normal and ...
user avatar
2 votes
1 answer
950 views

How to format clipboard text as data row in Google Sheets?

I've noticed copying text with a link preserves the link when pasted in Google Sheets. I've also tried copying an inline list from an HTML page and noticed it gets copied as two rows. Is it possible ...
user avatar
6 votes
2 answers
8k views

Force Google Docs/Sheets to ALWAYS paste values only (merge formatting)

I do a LOT of copying from external sources and pasting into Google Docs/Sheets. Is this at all possible? I know the keyboard shortcut but can't seem to get used to it. Would save me so much time!
user avatar
1 vote
1 answer
4k views

Adding date picker to Google Sheets cells while data validation is customized

I have a column with customized data validation (custom formula) that accepts only dates, provided that a few other conditions are met. How can I add a date picker to the cells of this column? ...
user avatar
  • 123
2 votes
1 answer
4k views

Partial cell formatting with CONCATENATE in Google Sheets

Is there a way to format partially using CONCATENATE in Google Sheets? For example, =CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the * bolded or blue in color or something else. I ...
user avatar
1 vote
1 answer
3k views

How do I remove custom currencies in Google Sheets?

In Google Sheets, you can add custom currency things under the formatting tab and google sheets with keep them saved. I was playing around with this function and added a few ones to test it out but ...
user avatar
1 vote
1 answer
3k views

How to add an outline border to a table in Google Docs?

I am trying to add only a border outline to a table in Google Docs however when trying to make all lines except the border lines another colour, this happens: As you can see, white spots where the ...
user avatar
  • 113
4 votes
1 answer
4k views

Why does Google Docs make some H1 headings bold in the Table of Contents and some not bold?

In my Google docs document I have added a Table of Contents. It's the kind with page numbers. In the Table of Contents, some of the Heading 1 (top-level) headings are bold, and some are not bold. Why? ...
user avatar
1 vote
1 answer
90 views

How to prevent sub-lists numbering restart under each bullet?

Google doc's numbered list functionality restarts sub-list "numbering" or "sequential lettering" like this: 1) First thing a) b) 2) Second thing a) <- Sub-list numbering / sequential ...
user avatar
0 votes
1 answer
50 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
user avatar
  • 479
0 votes
1 answer
215 views

Formatting script applicable to a range, not an entire sheet

I have the following script, which applies formatting in row 1 to an entire spreadsheet. How can I limit the formatting application to a range (ex. A7:AN135), so that the header rows are excluded from ...
user avatar
1 vote
2 answers
3k views

Google Sheets auto move to next cell

I have an ID format checker that has a row of cells that can only have one specific kind of character in each cell, and then all characters are compiled in order into another cell to create the ...
user avatar