Skip to main content

Questions tagged [formatting]

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

Filter by
Sorted by
Tagged with
447 votes
6 answers

How do I add new styles to Google docs?

Google docs has a nice set of styles such as "Normal text" and "Heading 1". How do I add my own? I want to add a style called "code" for text that is programming code.
David Faux's user avatar
  • 8,069
289 votes
13 answers

How can I get code syntax highlighting in Google Docs?

Is there way to switch on syntax highlighting in Google Docs? Personally I use it for editing and collaborating on C++ files, but PHP or SQL syntax highlighting also would be interesting.
Kirill V. Lyadvinsky's user avatar
80 votes
15 answers

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?
Jiew Meng's user avatar
  • 1,251
71 votes
14 answers

How to set a Google Docs Spreadsheet cell format to bare text?

I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
Ivan's user avatar
  • 2,067
56 votes
2 answers

How to insert source code in Google Docs? [duplicate]

Is there a easy way to insert source code with highlight in Google Docs?
Jichao's user avatar
  • 699
53 votes
2 answers

How do you manually block-quote in Gmail's new compose interface?

Gmail recently released a new UI for compose. How do you manually quote a paragraph? The block-quote button seems to have disappeared from the formatting toolbar in the rich text compose editor.
Jonathan Tran's user avatar
48 votes
4 answers

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 ...
Jack's user avatar
  • 626
46 votes
6 answers

How to center a table in Google Docs?

Centering data within a table cell or cells in Google Docs is straightforward and easy (i.e., highlight and center). How would I center an entire table?
samthebrand's user avatar
  • 5,459
45 votes
9 answers

How NOT to bold text in WhatsApp & still use ** around text?

Now as WhatsApp offers options for bold, Italic & strike-through text, how not to make the text bold while still enclosing it in *. Any kind of escape character? For example: *test* will result ...
DavChana's user avatar
  • 742
44 votes
3 answers

How to change the default style of text links in Google Docs

I want to format the default style for text links—currently the color is blue & are underlined. Is this possible? And if yes, how can I do it?
Nam G VU's user avatar
  • 3,614
39 votes
3 answers

How do you format Facebook Wall posts?

There doesn't appear to be any formatting links when I do a Facebook Wall post. Is there any way to do formatting like HTML, markup, etc?
Lance Roberts's user avatar
36 votes
5 answers

Short number format in Google Sheets; 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: ...
jm3's user avatar
  • 465
36 votes
15 answers

Insert a table in Gmail

How can I create a table in a Gmail message? I've currently got the data in a Google Docs spreadsheet, but copying and pasting that into the Gmail editor just pastes tab-delimited columns, not a table....
Don Kirkby's user avatar
  • 2,009
27 votes
6 answers

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 ...
Conor O'Brien's user avatar
26 votes
3 answers

How do I change date and time formats in Trello?

How do I change the formatting of time and dates in Trello? I'm looking to change the following: time presentation to 24 hour clock instead of 12 date format to DD/MM/YY instead of MM/DD/YY?
Vermu's user avatar
  • 269
23 votes
6 answers

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.
Sandeep Kumar M's user avatar
22 votes
6 answers

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 ...
GiH's user avatar
  • 643
21 votes
3 answers

Cell reference with colour formatting

Is it possible to reference a cell in Google Sheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference cell's value. But if ...
Robert Koritnik's user avatar
20 votes
7 answers

IMPORTRANGE with preserved formatting

I am importing a certain range of data from a master sheet and would like to maintain the formatting for those cells. It seems as though this only works within a sheet: Cell reference with colour ...
Lucas Crossley's user avatar
19 votes
5 answers

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 (...
bruno's user avatar
  • 789
19 votes
8 answers

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?
Jonik's user avatar
  • 3,788
18 votes
5 answers

How do I Insert a carriage return on a card in Trello?

I have added a card to a board in Trello, and now need to edit the text on that card. How do I insert a carriage return? I have tried the following: Shift + Return Ctrl + Return Shift + Ctrl + ...
Doug's user avatar
  • 181
18 votes
6 answers

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 ...
SlowDeep's user avatar
  • 281
17 votes
5 answers

Write code with indentation in Google+'s stream

I am trying to paste a piece of code in my Google+ stream but it removes the white space from the start of the lines making the code less appealing, aesthetically speaking. Basically, the ...
F1234k's user avatar
  • 281
17 votes
1 answer

Shortcut key for monospaced character format in Confluence

I know the {{...}} markup but it's rather cumbersome. Is there a shortcut key to set the selected text to monospace in Confluence or is it possible to set up one somehow?
palacsint's user avatar
  • 271
14 votes
2 answers

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 ...
kristen maul's user avatar
14 votes
2 answers

How do I create a checklist in a slack message?

I'm trying to create a task list for myself in a private chat with my supervisor on Slack. I'm pretty familiar with markdown, and I thought that Slack supported it too. On GitHub, you can create tasks ...
xfbs's user avatar
  • 141
14 votes
2 answers

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....
Shimmy Weitzhandler's user avatar
13 votes
6 answers

Can I add a line break in my Twitter bio?

My Twitter bio looks bad because the line is split at unfortunate places. Can I force a line break at a particular place? The form at inserts carriage returns ...
nic's user avatar
  • 8,754
13 votes
3 answers

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 ...
user avatar
12 votes
7 answers

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 ...
sam's user avatar
  • 6,979
12 votes
10 answers

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 ...
Joan's user avatar
  • 121
11 votes
3 answers

Google Docs is altering my formatting, how can I avoid this?

I don't have a printer and I need a document printed. Thus, I've shared a very basic Google Docs document with someone who does have a printer. Over here the formatting looks fine. Tabs are correct, ...
boehj's user avatar
  • 355
11 votes
13 answers

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 ...
Steve's user avatar
  • 307
11 votes
3 answers

Using the Google Documents equation editor, how can I enter the binomial coefficient?

It does not appear that you can enter the binomial coefficient or the choose-function of combinatorics. I'm trying to use the parenthesis in the third drop-down menu in the equation editor, but they ...
Thomas Owens's user avatar
  • 1,031
11 votes
2 answers

Why is Gmail rich-text formatting so inconsistent when replied to via Outlook?

I use the Gmail web client with rich-text and often find that my emails look to be formatted consistently when I send them, however when Outlook users reply, the text in my original email often has ...
Josh Newman's user avatar
  • 1,929
10 votes
4 answers

Stop Google Sheets formatting text as URL

When I type "" or "" 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 ...
RobG's user avatar
  • 203
10 votes
3 answers

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms with a question that contains a drop-down box with the following values: - Fewer than 10 - 11-25 - 26-50 - More than 50 If the user selects 11-25, Google Sheets renders the ...
hairboat's user avatar
  • 1,614
10 votes
3 answers

Force Google Docs/Sheets to ALWAYS paste values only (merge formatting)

I do a LOT of copying from external sources and pasting into Google Docs/Sheets. Is this at all possible? I know the keyboard shortcut but can't seem to get used to it. Would save me so much time!
actuallyMarc's user avatar
10 votes
2 answers

How to insert code in Google Drive documents [duplicate]

I use Google Drive Docs as my note taking tool and it is awesome since I can use it when I am offline, but I have a problem: I can't add source code in documents there. I know this question is ...
daNullSet's user avatar
  • 209
10 votes
2 answers

How can I put an equation into a Google Slides and maintain the formatting?

I read a similar question on the Google Docs Help forums, but if I copy an equation that contains a symbol without using an image (such as the ∈ symbol), the symbol goes away in the presentation. Is ...
Thomas Owens's user avatar
  • 1,031
10 votes
6 answers

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 ...
Avatar's user avatar
  • 1,737
10 votes
9 answers

How can I format time as 12-hour but without the period indicator?

I am trying to display times in Google Sheets without an AM/PM indicator, but with 12-hour time (not 24-hour "military-style" time). I do not need the AM/PM indicator as it is redundant in my ...
Laurence Gonsalves's user avatar
9 votes
2 answers

Google Docs keeps reverting to Arial 11pt

I use Google Docs for typing up a lot of work, and I like to type it up in Garamond. However when I add line-breaks sometimes Google Docs decides to revert to Arial 11pt (the default style for a new ...
fredley's user avatar
  • 527
8 votes
3 answers

How do I mix formats in one cell?

I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
patrickgamer's user avatar
8 votes
4 answers

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 ...
Thufir's user avatar
  • 706
8 votes
1 answer

Why does Google Docs make some H1 headings bold in the Table of Contents and some not bold?

In my Google docs document I have added a Table of Contents. It's the kind with page numbers. In the Table of Contents, some of the Heading 1 (top-level) headings are bold, and some are not bold. Why? ...
joelittlejohn's user avatar
8 votes
3 answers

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
Freedo's user avatar
  • 181
8 votes
1 answer

How can I share common formatting between Google Documents?

I have a folder of about 20 Lesson Plans in Google Documents. Although I used an initial template with a bunch of custom formatting for Heading 1, Heading 2, etc. I now want to tweak the styles. Is ...
JJ Rohrer's user avatar
  • 183
7 votes
2 answers

Adding a New Line on Facebook Comment

When I am commenting on Facebook, how do I insert a new line. Let us say, that I post a status. Friend A comments on it, followed by Friend B, followed by Friend C. I am now posting a reply and I ...
Kanini's user avatar
  • 595

2 3 4 5