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.
73
questions
1
vote
0
answers
13
views
How to justify (not center) text in Gmail? [duplicate]
Currently I'm presented with 3 text alignment options in the dropdown of my desktop Chrome Gmail editor: left, center, right but not justify. Yet justify is the preferred way for many publishers, and ...
- 11
2
votes
2
answers
2k
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 ...
- 143
7
votes
2
answers
15k
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 ...
- 73
1
vote
0
answers
808
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 ...
- 11
6
votes
2
answers
6k
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 ...
- 193
1
vote
1
answer
49
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!
- 11
0
votes
2
answers
252
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 ...
- 101
2
votes
2
answers
3k
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 ...
- 129
1
vote
0
answers
1k
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
1
answer
156
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 ...
- 117
3
votes
1
answer
6k
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 ...
- 133
1
vote
1
answer
97
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 ...
- 13
2
votes
1
answer
35
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
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....
- 13
2
votes
2
answers
598
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 ...
- 225
1
vote
1
answer
52
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
1
answer
828
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 ...
- 103
5
votes
1
answer
2k
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 ...
- 99
0
votes
1
answer
915
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 ...
- 3
0
votes
2
answers
1k
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 ...
- 23
0
votes
1
answer
29
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.
- 131
1
vote
1
answer
615
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 ...
- 772
0
votes
1
answer
2k
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 ...
8
votes
2
answers
38k
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 ...
- 274
0
votes
1
answer
166
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 ...
- 183
-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 ...
- 12.5k
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.
- 273
0
votes
2
answers
10k
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,004
4
votes
2
answers
9k
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 ...
- 49
4
votes
1
answer
7k
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 ...
- 243
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
-2
votes
1
answer
176
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
1
answer
30
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
...
- 21
7
votes
4
answers
5k
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 ...
- 696
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 ...
- 246
4
votes
1
answer
192
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?:
15
votes
5
answers
36k
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.
- 271
11
votes
3
answers
24k
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 ...
- 215
9
votes
2
answers
3k
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 ...
- 192
4
votes
1
answer
4k
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?
- 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 ...
- 143
2
votes
1
answer
379
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.
- 123
2
votes
1
answer
81
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 ...
- 21
-1
votes
1
answer
40
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?
- 19
8
votes
2
answers
17k
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 ...
- 704
12
votes
2
answers
9k
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. ...
- 560
9
votes
2
answers
11k
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 ...
- 91
-5
votes
1
answer
59
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 ...
- 101
9
votes
5
answers
54k
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.
- 243
1
vote
1
answer
4k
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 ...
- 311