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
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 ...
96
votes
11answers
71k 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 ...
6
votes
4answers
8k 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
8k 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 ...
17
votes
3answers
13k views

Show text part of a multipart email in Gmail

An email sent with Content-Type of 'multipart/alternative' (often) contains two copies of the email: one HTML, one plaintext. Gmail displays the HTML version of the email by default, but how do I ...
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 ...
2
votes
2answers
101 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 ...
1
vote
1answer
1k views

Google Docs — Start numbering pages on first page, but start at ONE

I feel incredibly stupid, but I just can't seem to figure this out ... I want google docs to number my pages 1/n, 2/n, ..., n/n, starting with the very first. So I add page numbers to my header. They ...
5
votes
4answers
16k 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.
1
vote
0answers
12 views

How do I create a custom keyboard shortcut in Google Docs to implement custom formatting? [duplicate]

When I take notes for CS classes, I find myself constantly changing the font choice and weight to differentiate lines of code from regular notes. For example: To improve productivity, I would like to ...
0
votes
0answers
17 views

Force Gmail to always paste text without rich format [duplicate]

As in question, is it possible to force Gmail to always paste unformatted text? It gets me a little bit crazy that I always have to go with copied text through some middle app (like Notepad, Windows' ...
0
votes
1answer
917 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 ...
1
vote
1answer
23 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!
0
votes
2answers
30 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 ...
19
votes
8answers
27k views

Can you add basic text formatting (bold, italic) in Yammer posts?

When writing a post (or a comment on a post) in Yammer, is there any way to add basic text formatting such as bold or italic text?
0
votes
2answers
1k 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
80 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
25 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
61 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 ...
2
votes
1answer
30 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
25 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 ...
6
votes
2answers
21k 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 ...
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
32 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
26 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 ...
3
votes
2answers
3k 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 ...
2
votes
1answer
18k views

Start new line automatically when otherwise content would overflow cell [duplicate]

I don't know when Google changed the version of Spreadsheets. Right now when the cell's text is longer than the cell width the display of this line is no longer what it used to be. I want the display ...
244
votes
11answers
427k views

How do I strikethrough text in Gmail?

Basically I want to strike through some text; how can I do this?
4
votes
2answers
924 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 ...
4
votes
1answer
267 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 ...
0
votes
1answer
43 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
15 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
107 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
23 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
113 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
334 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 ...
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
5
votes
3answers
7k views

Pastebin formatted text

Pastebin means that you paste your text online. Yet, quite often, my text is nicely formatted whereas all Pastebins that I have seen so far leaves only plain text or applies language-specific ...
-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 ...
0
votes
1answer
37 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 ...
8
votes
1answer
2k 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 ...
0
votes
1answer
826 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.
1
vote
0answers
595 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 ...
25
votes
3answers
11k views

How do I format text, specifically text links, in Google+?

Does anyone know how I would go about putting formatted text in a stream update in Google+? Specifically I'm trying to put text links in a post, without having to show the URL or have the page ...
1
vote
0answers
2k 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 ...
-2
votes
1answer
72 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
23 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
3k 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
1answer
55 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
vote
2answers
1k views

How do I open/edit/convert Markdown documents in Office OneDrive?

We have a bunch of text files in Markdown format and we want to share them with the relevant members of the team using Office OneDrive. As far as text file formats, OneDrive only seems to understand ...