2022 Developer Survey is open! Take survey.

Questions tagged [text-formatting]

DO NOT USE THIS TAG. Text formatting refers to the appearance of text beyond the use of a standard character set in its simplest form. This includes: highlighting or colour, to draw attention; cursive, for informality; and other aids to the reader such as italic rather than Roman, eg for book titles, or monospaced, eg for code, and size, kerning, direction, small caps, strikethrough etc. Note tags [highlight], [special-characters] and [emoji] exist.

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

Rotate a shape in Google Slides without rotating the text

I've used PowerPoint almost all my life - have used Star/Open/Libre Office Presentations as well without much issue. I'm relatively new at using Google Slides. Here's what I want: I'm using the built ...
user avatar
  • 103
3 votes
2 answers
9k views

How can you add clickable text hyperlinks in youtube comments?

My question is how can i add clickable text hyperlinks and by that i mean : <a href="https://example.com">example</a> BUT in YouTube comments, I know it is possible because of a ...
user avatar
  • 33
1 vote
0 answers
502 views

Retain formatting when pasting into Gmail & Yahoo Mail on Firefox

I tend to write somewhat complex responses to friends that include bold and italics as well as font size and color changes (not available here?). I take my time and do it offline using Word or ...
user avatar
4 votes
1 answer
3k views

Ordered list in Gmail with letters instead of numbers?

The Gmail composer appears to only offer numbered and bulleted lists. Shortcuts: Ctrl+Shift+7 for a numbered list Ctrl+Shift+8 for a bulleted list Is there a straightforward way to create an ...
user avatar
  • 173
0 votes
1 answer
76 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
1 vote
1 answer
33 views

How do I make the “Text contains” evaluate any word written in the cell?

I just want the cell in Google Sheets to change its fill color when any text is inputted in the cell? But it has to be text excluding numbers. Please help!
user avatar
  • 11
0 votes
2 answers
145 views

Google Sheets duration format does wrap around 24

If I format the cells of a sheet to duration, it wraps around 24h So adding those three cells (which should represent HH:MM): 05:00 18:00 02:00 with SUM, the result is 01:00 where I need the result ...
user avatar
1 vote
2 answers
2k views

How can I quickly change the color of text in a cell in Google Sheets?

How can I quickly, with either a single or double click, assign a color to the text in a cell in Google Sheets? In order to quickly determine the status of certain pieces of data in a spreadsheet I ...
user avatar
  • 119
1 vote
0 answers
622 views

Google Docs auto bold formatting

How to automatically make any sentence starting with Q: and ending with ? bold? For example if Q: Who does the program plan? is typed in a Google Doc it should turn bold. I am looking at options like ...
user avatar
1 vote
1 answer
76 views

How can I change the font of selected text within a cell in Google Sheets using keyboard shortcuts?

I am attempting to change the font of selected text within a cell in Google Sheets using a keyboard shortcut. I have attempted the steps meant for google docs here: How can I change the font in ...
user avatar
2 votes
1 answer
4k views

How can I float text by text in Google Docs

See the attached image below, which shows that a side-note is added so that the normal text of the document "floats around it": How is that technique called - Is there a name for it? And how can I ...
user avatar
  • 123
1 vote
1 answer
72 views

Assert cell style onto text pasted into that cell

I'm not quite sure how to word this so I couldn't find any answers to my question after some searching. I am trying to copy and paste values into my Google sheet. These values are copied from another ...
user avatar
1 vote
1 answer
24 views

Adding mm:ss times when expressed as TEXT

I have a series of numbers that, for a reason out of my control I can not change, are expressed as plain text strings on google sheets. The numbers are supposed to be minute second. mm:ss. For the ...
user avatar
1 vote
1 answer
27 views

Looking for a way to get the current date represented as a numbered month with decimals

Essentially I'm hoping to find a formula that would return the current date as a month in decimal form. So if it's October 15th, the number returned would be 10.48. September 10th would come back as 9....
user avatar
  • 13
2 votes
2 answers
290 views

Boolean test of whether a time is before or after midnight in Google Sheets?

I'm having a job trying to create a Google sheet which calculates the difference between the time I fell asleep and the time I woke up. Here's what I want to happen: Sleep time Wake time ...
user avatar
  • 215
1 vote
1 answer
44 views

Time not formatting as expected in Google Sheets

I imported a report to Google Sheets and the duration column shows 7 h 37 m or 14 h 5 m a similar format. When I replace h with : it still does not properly format to time duration and so I cannot ...
user avatar
0 votes
1 answer
496 views

Funny alignment in Google spreadsheet

This is driving me crazy. I have searched the web for an answer, without success. All results are simple pointers on how to use the formatting on the sheets. This misalignment seems to be something ...
user avatar
  • 103
5 votes
1 answer
1k views

How do you make a Roman numeral numbered list in Gmail?

I know how to make a bullet list (command + shift + 8) and a numbered list (command + shift + 7) in Gmail. Is it possible to make a numbered list that uses Roman numerals? (preferably by keyboard ...
user avatar
  • 25
0 votes
1 answer
436 views

How to reference a cell while keeping its color formatting?

Is it possible to reference a cell which contains "ABC" where B is blue and C is yellow while keeping the color formatting? Assume A1 contains the colored text, then I want B1 to refer to A1 and ...
user avatar
  • 3
0 votes
2 answers
854 views

Typing in a particular cell and convert it in upper case [closed]

After I typed in a cell a text value (this is in lower case), what do I need to do (after typed it), to become it as the upper case? How do you change the case to upper case for a whole column in ...
user avatar
0 votes
1 answer
25 views

Combine cells retaining formatting within a sheet

I want to combine columns of texts while preserving the formatting (e.g., underline, italics). How can I do that? I know how to use =C1&CHAR(10)&C2 ... but the formatting is lost.
user avatar
1 vote
1 answer
504 views

Google Sheets Custom Number Format - Unchanging #<1000

I am well aware of the excellent Custom Number Formula: [<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B" Which abbreviates #,000 numbers to #K, #,000,000 to #M etc... However, I am looking for ...
user avatar
0 votes
1 answer
1k views

Google Docs copy paste formatting / indent question

So say I am taking a YouTube transcript, and copying the whole thing, and then pasting it into a document. The way the transcript is set up with YouTube it's layered like every 5 seconds so its lines ...
user avatar
5 votes
2 answers
32k views

Edit the Custom Colors for Text Colors in Google Docs

tl;dr the Google Docs color pallete has colors I want and other I do not want. How can I remove some colors? In Google Docs, I cannot change a Custom Text Color. If I select Custom Colors for a Text ...
user avatar
0 votes
1 answer
97 views

Google Doc - applying headers to single line only - after pasting as plain text

The issue: https://youtu.be/OXS3wTR7YJw Make notes in "Notes" (better for offline) Paste into Google Doc Apply a header Sh!t the whole thing is formatted now Related but not the same: Create ...
user avatar
-1 votes
1 answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...
user avatar
  • 11.7k
1 vote
1 answer
3k views

How to change the default font & font size in Google Documents? [duplicate]

I really hate Arial, which happens to be the default for Google Docs. Does anyone know if there is a way to change the default font and font size in Google Docs? Thanks.
user avatar
  • 263
0 votes
2 answers
7k views

Display only last 4 digits in Google Sheets

I have an eight-digit number (20150613), I just want to display the last 4 digits like 0613. I know I can use a formula like =right(20150613,4), but I don't want to do that; I need the number to stay ...
user avatar
  • 966
4 votes
1 answer
5k views

Formatted text, code block in draw.io

I want to add JSON code snippets to my diagram in draw.io. When I use copy/paste to a text box, the indented spaces/tabs get lost. Does anyone know how to copy formatted snippets from notepad++/VS ...
user avatar
  • 49
4 votes
1 answer
5k views

How do you paste without format by default in Google Sheets?

In Google Sheets you can hit Ctrl+Shift+V to paste without the formatting, but, is there a way to change it so that you can use Ctrl+V? Either by changing the Keystroke or forcing the rows or columns ...
user avatar
  • 223
0 votes
3 answers
2k views

Increase font size in Google search results

Can I increase the font size in Google search results? I already searched everywhere, but still didn't get an answer
user avatar
-2 votes
1 answer
102 views

Why does my google calendar look ok on my computer but all the details change to code on my iphone?

I create events on my laptop but when I view them on iPhone all the text in the description section turns to code. I have figured out to not cut and paste, but even if I type in the details it changes ...
user avatar
2 votes
1 answer
28 views

Can you "text to column" 3 specific bits of data from one cell into 3 cells

I am trying to find a way to split the numbers from a cell with the following data in it: 31(3)/22 With this data in a cell, in the adjacent 3 cells, I would like to see the results returned as thus ...
user avatar
7 votes
4 answers
4k views

How to left align dollar symbol but right align number?

I selected format -> number -> more formats -> custom number format: $#,##0_);[Red]($#,##0) How can prepend spaces between the $ symbol and the digits? Pad with spaces. So that the dollar sign is ...
user avatar
  • 664
2 votes
2 answers
3k views

Why did Google Docs suddenly start consolidating all multiple-newline sequences into single newlines?

Up until yesterday, documents looking like this (note the 2, 3, then 4 newlines between letters): a b c d Would be copied and pasted in plain text (e.g. in a plain text area on a web page, or a ...
user avatar
  • 236
4 votes
1 answer
129 views

How can I add status indicators to a section in GitHub?

I'm reading Basic writing and formatting syntax of GitHub but failed to link directly to section in ordered file like this: What is the syntax to do like this?:
user avatar
12 votes
5 answers
27k views

Is there a shortcut key for changing Google Sheets text color to the "last color"?

I often find myself changing text colors to the same color for five minutes at a time which is really unnecessarily mouse-intensive.
user avatar
8 votes
3 answers
20k views

How to change the default link color in Google Slides?

I have a presentation in Google Slides. Every new link is colored cyan by default and all existing links have this default color as well. How could I change this default color that determines the ...
user avatar
  • 183
5 votes
2 answers
2k views

Define special inline styles in Google Docs

I am using Google Docs to write some documents. At certain points, I have to write inline some formulas I would like to have a different font, letter size and color. I like to experiment with ...
user avatar
4 votes
1 answer
3k views

Small letters in superscript in Gmail subject line

Twitter sends email notifications with the subject in small letters raised above the base line: How can we do this in our messages?
user avatar
  • 143
4 votes
1 answer
2k views

How can I stop Messenger bolding from putting * around text?

At some point fairly recently, Facebook Messenger starting making things inside * symbols bold. For example, if I type: *Hello World!* it shows up as: Hello World! How can I stop this happening ...
user avatar
2 votes
1 answer
334 views

Composing a plain text email in Google Groups

Is it possible to compose a plain text email in Google Groups? Clicking on the "New topic" button opens a rich text editor, and I see no option to switch to plain text.
user avatar
2 votes
1 answer
71 views

Copying text into Google Docs

I want to be able to copy text from converted PDF documents into a Google Docs. What I am finding with the current document is that the text only covers the left side of the page. I want it to look ...
user avatar
-1 votes
1 answer
30 views

How to change formula output directly?

I have a formula which produces some text, how do I highlight a part of the text to change the part's color?
user avatar
  • 19
8 votes
2 answers
16k views

How to prevent Gmail from creating map link from address?

When Gmail detects an address within the text of an email, it automatically converts that address into a link to Google Maps. (I think this "feature" must be new because it hadn't happened in the ...
user avatar
  • 582
11 votes
2 answers
6k views

Is it possible to make letters upright (non-italic) in equations in Google Docs?

On this forum answer on Google Docs it is mentioned that commands such as \mathrm{} should be possible. Just like in regular LaTeX (or MathJax). I cannot make this command work on my page, though. ...
user avatar
  • 530
8 votes
2 answers
9k views

How can I display the name of the month in different languages in Google Spreadsheets?

In Microsoft Excel the following formula forces the month name to be displayed in Portuguese, regardless of the default language. =TEXT(A1,"[$-pt-PT] dd mmmm yyyy") Google Spreadsheets ignores the ...
user avatar
  • 81
-5 votes
1 answer
56 views

How do I apply text effects like this in "The Three Evils" [closed]

I know there's an online utility that does it but I can't seem to find it. All my Googling has been in vain. The T̜͓̞̤͎ͦ́ͤ̓̄̚ḣ͖͙̘ͦͯ̾re͗̈́e ̙̥̘̙͉̺̜̐ͧ̍E͍̲̜͈͊v̹͙̝̗ils is the only example I could find of ...
user avatar
8 votes
5 answers
42k views

Making transparent text in Google Slides

I would like to make my text transparent. I've found only how to make transparent background which is not what I want to achieve.
user avatar
  • 223
1 vote
1 answer
3k views

How to paste to text editor from Google Docs without it doubling the line breaks between paragraphs?

About 3 weeks ago I began to have this problem occur whenever I copy text from a Google Docs document in Chrome browser and paste it into a text editor. (Technically it's a plain text field within ...
user avatar
  • 311