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
166k views

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
593k views

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

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
212k views

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
39k views

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

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
75k views

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
72k views

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
176k views

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
62k views

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
125k views

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

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
226k 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.
Sandeep Kumar M's user avatar
22 votes
6 answers
131k 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 ...
GiH's user avatar
  • 643
21 votes
3 answers
53k views

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
120k views

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
10k 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 (...
bruno's user avatar
  • 789
19 votes
8 answers
29k 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?
Jonik's user avatar
  • 3,788
18 votes
5 answers
35k views

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

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
3k views

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

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

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 https://twitter.com/settings/profile inserts carriage returns ...
nic's user avatar
  • 8,754
13 votes
3 answers
12k 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 ...
user avatar
12 votes
7 answers
98k 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 ...
sam's user avatar
  • 6,979
12 votes
10 answers
60k 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 ...
Joan's user avatar
  • 121
11 votes
3 answers
158k views

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

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
33k views

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
17k 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 ...
RobG's user avatar
  • 203
10 votes
3 answers
16k views

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
14k views

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
17k views

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
26k views

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

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
27k views

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
19k views

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

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

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
47k views

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

1
2 3 4 5