Questions tagged [text-formatting]

Use this tag for questions about 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
1
vote
0answers
18 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 ...
1
vote
1answer
20 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 ...
1
vote
1answer
16 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 ...
1
vote
1answer
19 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 ...
1
vote
1answer
13 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 ...
1
vote
1answer
16 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....
1
vote
1answer
24 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 ...
1
vote
1answer
30 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 ...
0
votes
1answer
19 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 ...
4
votes
1answer
114 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 ...
1
vote
0answers
411 views

Google Sheets text wrap no longer expands cell

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells. Mac OS: 10.13.6 (17G65) Chrome: Version 73.0.3683.103 (Official Build)...
0
votes
1answer
26 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 ...
0
votes
0answers
12 views

How do I type one character over another in Google Docs or in any other web application document editor

As said in the question, I want to type one character over another. Like for example: In the above sample, I would like to have the characters raised above one over another so that i can easily edit ...
0
votes
2answers
48 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 ...
0
votes
1answer
22 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.
0
votes
1answer
53 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 ...
0
votes
1answer
215 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 ...
2
votes
2answers
4k 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 ...
0
votes
1answer
36 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 ...
0
votes
1answer
805 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 ...
0
votes
0answers
30 views

Auto format specific words

I'd like Google Docs to automatically apply a format, given the specific words and expressions. Example: if I write the word "spell", then the text goes pink and bold, and if I write "outstanding ...
0
votes
1answer
585 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.
0
votes
2answers
817 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 ...
1
vote
0answers
432 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 ...
1
vote
0answers
1k 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 ...
0
votes
3answers
1k 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
-2
votes
1answer
59 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 ...
2
votes
1answer
21 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 ...
7
votes
4answers
2k 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 ...
2
votes
2answers
2k 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 ...
4
votes
1answer
73 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?:
5
votes
4answers
5k 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.
2
votes
2answers
1k 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 ...
4
votes
2answers
751 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 ...
2
votes
1answer
1k 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?
3
votes
1answer
540 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 ...
1
vote
1answer
170 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.
2
votes
1answer
54 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 ...
-1
votes
1answer
28 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?
7
votes
2answers
14k 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 ...
1
vote
1answer
2k views

Fix font size of Gmail signature

The font size of my Gmail signature looks weird — it sometimes changes even in mid-sentence, and this is only visible outside Gmail, e.g. in the Inbox app on my iPhone. How to fix?
3
votes
0answers
2k 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. ...
2
votes
2answers
2k 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 ...
-5
votes
1answer
52 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 ...
4
votes
3answers
13k 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.
0
votes
1answer
982 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 ...
4
votes
2answers
18k views

How can I make multiple non-contiguous text selections in Google Docs?

Is there a keyboard shortcut or other method for Google Docs that is equivalent to Ctrl+click in MS Word which allows you to select several parts of the text that are not adjacent to each other? I ...
3
votes
0answers
600 views

How to format Table of contents automatically in Google Docs?

I know I can create Table of contents (TOC) based on the Header titles in the body of the page. This is great as every time I add a new header, I just click on the refresh button on the TOC and the ...
8
votes
1answer
1k views

How can I set default color in Google Slides?

Every time I enter text into a new text box, or draw a new line, or a new shape, etc. The color is black (on a dark background) and I need to manually change it to white. This is getting tedious. Is ...
87
votes
10answers
63k views

How do I escape formatting characters in Slack?

Slack uses various characters for its own markdown formatting. How can I enter a message with those reserved characters escaped? e.g. Is it possible to send a message exactly like this: *I don't ...