Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [formatting]

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

0
votes
1answer
23 views

Highlight cell border in Google Docs

I'm trying to create a table in Google Docs. I need a header row at the top and a similar column on the left side. To distinguish these from the rest of the table I am trying to embolden the line ...
12
votes
2answers
5k views

Formula for smart, scale-aware number-formatting in Google Sheets? (e.g. 1,024 → 1k, 1,816,724 → 1.8M)

Any recipes out there for a "smart" number formatting formula for Google Sheets that's "scale-aware," a la Rails ActionView's distance_of_time_in_words method? I would expect to enter a number like: ...
0
votes
1answer
26 views

How to make date automatically display only day number and suffix (1st, 2nd, etc.)?

Title explains it. I need to know how to create a custom number format in which a cell would display only the date and suffix of a full date entered into the cell example:1/05/2019 -> 5th I have ...
1
vote
1answer
25 views

IF statement not working in Google Sheets?

So I'm using Google Sheets and I'm trying to determine whether or not cells in a certain column AO have a higher value then cells in another column O. My formula is =IF(AO6 > O6,"UNDER","OVER"). ...
0
votes
1answer
15 views

Prevent the stretching from changing cells border in Google spreadsheet

Is it possible to prevent the stretching from changing cells border in Google spreadsheet? I mean that if I stretch a cell which has a border above it, then the same border will be added to the cells ...
1
vote
1answer
21 views

Google Sheets function returns an incorrect value

I have a very simple function for every cell in column D, for example: D24 =C24-(B24*N$2) Example with values: D24 =10-(1*6,5) This works; however, not all the time. For cell D24 this returns a ...
12
votes
4answers
32k views

Is it possible to format small-caps in Google Documents?

I have found the need to format text in small caps (with minuscule letters looking like capitals, but still maintaining their size) in Google Docs. I have looked over, under, and in the Docs option ...
0
votes
1answer
13 views

How can sub-lists at the same level be given mixed list styles?

It seems if you change the list style (e.g. Roman numbered, or square bullets) in Google Docs for a list at a certain level, other sub-lists at the same level are also changed. For example, you can't ...
0
votes
1answer
81 views

Setting minimum row height

In the past, I used to open a new spreadsheet, resize all lines (the default feels way too cramped for me), and then enter data. If at some point I entered data longer than the row height, it would ...
4
votes
3answers
1k views

Auto-fill date function changes the YEAR and not the day

I'm trying to get Google Sheets to auto-fill dates in the beneath cells after I have manually filled one myself. The strange issue is that when I hold Command key and drag down, the cells auto-...
5
votes
3answers
6k views

How to change the text line height in one cell?

I could not find an option in the recent version of Google Sheets to change the text line height (the spacing between lines in a single cell). You realize the problem even more when exporting the ...
1
vote
1answer
149 views

How to color an adjacent cell based on a 6-digit hex number without adding the “#”

I've looked at a few things (this link, WA's Colorize a cell in Google Spreadsheets based on cell data, and this link), but haven't been able to quite get the behaviour I want in Google Sheets. What I ...
2
votes
1answer
20 views

What's the difference in using the internal formatting and using TEXT to format cells?

What's the difference in using the Formatting drop-down and using =text() to format cells? Which one overrides the other or take priority? It seems I'm having some formatting conflict that is breaking ...
2
votes
2answers
314 views

How to make a list like 1.1, 1.2 with Google Docs?

I tried everything and this just doesn't seem to be possible anymore? It can do 1.1 Text 2.1 Text but not 1.1 Text 1.2 Text
2
votes
11answers
37k views

Some incoming Gmail messages do not word wrap

I've noticed that in Gmail some incoming emails do not word wrap. This is quite annoying as I have to navigate the cursor horizontally to read the message. Some people think that the sender's email ...
0
votes
1answer
423 views

Google Docs Markup When Posting into WordPress?

I write in Google Docs, then paste the content into WordPress. When I look at the HTML in WordPress, it has some extra markup added: < h2 >< b >Testing< /b ></h2> < span ...
2
votes
1answer
22 views

How to format one cell to match formatting of another (even if “other” changes later)?

How can I do the Style equivalent of setting one cell equal to the style of another cell, even if the "other" cell style changes? use Case: I want all Row #2 of each sheet to look like (same style) ...
3
votes
1answer
6k views

Entering mm:ss: milliseconds into Google Sheets for time duration (arithmetic)

I would like to enter times mm, seconds, milliseconds into Google Sheets and subtract times to determine duration. I use format> numbers > More formats > more dates and times > and apply mm:ss: ms. I ...
6
votes
4answers
11k views

How to create a checkbox column, that if selected will create a strike-through across the entire row in Google Sheets?

I have a Google Sheets. I want to set it up so that the first column is checkboxes, and if the checkbox is selected, the entire row gets a strike-through. How can I accomplish this? I followed this ...
1
vote
1answer
16 views

Custom formatting with data returns what the cell shows but not what the cell contains

Basically I have this set up in one of my sheets in which these cells have data validation for "is valid date" so a calendar shows up when you double click them, then it has custom formatting so ...
1
vote
1answer
28 views

How export a spreadsheet as XML?

How can I export a simple spreadsheet, consisting of a single column of data, as XML? Exporting as CSV is leading to other problems, so turning to XML as a workaround.
6
votes
6answers
41k views

Adding a header and footer to a Google Spreadsheet

I'm in the process of changing to Google Drive from MS Office for all aspects of my work. Pretty much everything I need is there, but the one thing we can't work out how to do is how to get a header ...
-5
votes
1answer
41 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 ...
31
votes
10answers
29k views

Always a blank line above where I insert a table?

In Google Docs, when I insert a table, there seem to be always a blank line above the table. See the screenshot below. How do I prevent that?
1
vote
1answer
147 views

Creative Cognito Forms notification email that contains all form details

I would like the email that I receive as a notification from a Cognito Forms entry to have the same formatting as the PDF document I can download. I would want it to look like the form as it is being ...
0
votes
1answer
64 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
1answer
34 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
0answers
7 views

Is it possible to auto indent in papeeria LaTeX editor?

I am using Papeeria LaTeX web editor and I am highly satisfied with it, but one feature I am missing – I am not able to make Papeeria auto-indent my LaTeX code. Is it possible?  I am a free user, ...
11
votes
3answers
4k views

How can I format text as code in Inbox by Gmail?

I sent an email today (or wanted to) from Inbox by Gmail and was disappointed at the apparent lack of ability to format text as code when compiling an email: How can I format text as code (or ...
47
votes
4answers
26k views

What are all the formatting options for a Google+ post?

What is the markup language for creating posts (and responding to posts)? I know of the following ones: To make text bold, use stars around the text: *bold text* To make text italics, use ...
0
votes
0answers
434 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
1answer
74 views

Stop Google Sheets formatting text as URL

When I type "product.name" or "product.id" into a cell, it's auto–formatted as a URL (different colour, underlined, hover shows it as an external link). But it's not a URL, it's plain text. Similar ...
0
votes
2answers
29 views

How to format code in Blogger

I am writing one article on Blogger, There I am unable to format code. The code I am writing is looking like simple text. The site name https://www.blogger.com/ I am using <div class="...
0
votes
1answer
864 views

Google Docs date in yyyy/mm/dd format (year first)

My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet? BUT unlike those answers, I'm trying to get the ...
0
votes
0answers
19 views

Google Sheets Custom Number Format 'Broken'?

I somehow did this when creating a custom number format. Any idea as to how to fix this?
0
votes
0answers
12 views

Google Sheets Conditional Formatting

I'm trying to finish up a Google Sheet with some conditional formatting that I can't figure out. Here's the best description I can come up with. If Column A matches in any row, then the formula ...
0
votes
0answers
34 views

How to set a single page's properties? [duplicate]

The goal is to selectively configure a single page of a multi-page document to: landscape (hyperlink to similar, yet a subset of this question) and paper size A3. The hope is that the link is ...
6
votes
2answers
2k views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields (...
0
votes
1answer
195 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.
3
votes
0answers
76 views

How do you change the default indent and set your own in Google Documents?

I don't like how the default when you open a new Google Doc is no first line indent. Is there a way to customize the default?
271
votes
5answers
97k views

How do I add new styles to Google docs?

Google docs has a nice set of styles such as "Normal text" and "Header 1". How do I add my own? I want to add a style called "code" for text that is programming code.
5
votes
3answers
8k views

Formatting bullet lists in Trello

The cards description field in Trello says they are supposed to accept markdown. However, I can't seem to be able to use stars to format a bullet list. All my text is put on a single line, with ...
3
votes
1answer
11k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
18
votes
7answers
166k views

Change background color of single page in Google Document

I would like to know how to change the background color of the cover page of a multi-page Google Document.
0
votes
1answer
1k views

How to remove insignificant decimal point in Google Spreadsheets?

I'm trying to format a number in Google Spreadsheets. I want it to show the thousands comma, then a period ., followed by mostly 3 digits, only when necessary. For example: 1,234.56789 => 1,234....
5
votes
4answers
3k views

Bullets are missing when exporting PDF from Google Docs

When I export a file to PDF from Google Documents, the bullets are missing. Is this a bug? Is there anyway to fix it?
1
vote
1answer
757 views

Weird behavior with “Wrap Text” in tables

I'm trying to add an image at the beginning of cell of a table that Wraps text however, for some bizarre reason it seems also block out space in the cell to the right. Where as, I'd expect something ...
4
votes
6answers
24k views

Keep formatting when pasting to Gmail

I liked formatting my e-mails in MS Word and then copy and paste them into Gmail. I did it, among other things, because I could control line spacing and text alignment (I prefer it justified). Gmail ...
1
vote
1answer
18 views

What's the shortcut key for code block?

How to format a selected piece of text as a code block in slack?
6
votes
4answers
16k views

How can I align a table so that text floats around it in Google Docs?

I have some text in a Google Document, and I want to have a small table beside this text. The problem is that the table takes the whole row, so I can't have any text left of the table. Is it even ...