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
292
votes
5answers
107k 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.
178
votes
12answers
283k 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.
51
votes
2answers
169k views

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

Is there a easy way to insert source code with highlight in Google Docs?
48
votes
2answers
32k 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.
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 ...
38
votes
6answers
79k 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?
37
votes
13answers
98k 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 ...
35
votes
11answers
37k 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?
33
votes
3answers
144k 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?
31
votes
3answers
31k 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?
28
votes
15answers
95k 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....
24
votes
2answers
3k 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?
19
votes
8answers
26k 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?
19
votes
7answers
174k 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.
18
votes
5answers
23k 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 ...
17
votes
5answers
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 ...
14
votes
3answers
28k 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 ...
14
votes
1answer
2k 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?
13
votes
6answers
207k 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 ...
13
votes
4answers
37k 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 ...
13
votes
2answers
6k 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: ...
11
votes
3answers
5k 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 ...
11
votes
2answers
27k 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 ...
10
votes
4answers
23k 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 + ...
10
votes
7answers
44k 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 ...
10
votes
3answers
10k 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 ...
10
votes
2answers
13k 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 ...
10
votes
2answers
16k views

How can I put an equation into a Google Docs Presentation 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 ...
9
votes
5answers
25k 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 ...
8
votes
7answers
55k 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 ...
8
votes
3answers
17k 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 ...
7
votes
4answers
2k 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 ...
7
votes
1answer
710 views

Formatting addresses in Trello with single line spacing

How do I use Markdown in Trello to format a simple address where address items are not all on the same line?. Here's an example address I want to format: George Smith 27 Smith Street Smithsville ...
7
votes
2answers
41k 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 ...
7
votes
4answers
23k 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 ...
7
votes
3answers
4k views

Date and time format

I have lots of dates in the first column in the format output by IFTTT: August 23, 2010 at 11:01PM Is there a way to get them formatted in a way that I can then use for date and time calculations? ...
7
votes
5answers
17k views

Inserting page numbers in a Google Docs document

How do I add or insert a page number in the footer or header of a Google Docs document?
7
votes
2answers
10k 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 ...
7
votes
3answers
13k 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 ...
7
votes
3answers
10k views

In Google Sheets, how does one get a 12-hour time of day *without* an AM/PM 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 ...
7
votes
1answer
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 ...
7
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 (...
6
votes
3answers
2k views

Format credit card numbers as four digit blocks in Google Sheets

I have this credit card number in a Google Sheets of the following format: XXXXXXXXXXXXXXXX How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in four digit ...
6
votes
2answers
3k views

Using multi-line formatted text in wiki syntax

Using multi-line formatted text (using the <pre> tags) inside of a list in Mediawiki is giving me problems. What I would love to do is something like this: # Text in a numbered entry #:<pre&...
6
votes
1answer
7k views

How to convert all numbers regardless of decimal separator into valid number of current locale?

I have a column with text looking like this: 123,123 123.123 123,123 123.123 I would like another column to parse this into decimal numbers, disregarding the different decimal separators (dot . and ...
6
votes
2answers
4k views

Formatting text in checklists in Trello, or embedding comments

How do I format text in a checklist, or embed comments, within a single checklist item in Trello? I would like to provide additional notes and a hyperlink for several items in a checklist, but I ...
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 ...
5
votes
1answer
8k views

How do I change date format at top of day in Google Calendar?

I can change the date format for most dates displayed by my calendar to Irish format, however I can’t find how to change this one. The dates at the top of each day are shown as 5/17 or Month/Day—as a ...
5
votes
5answers
165 views

What are some good Web Tools to help me format my code for blogs? [closed]

What are some good Web Tools to help me format my code for blogs? I'd like to be able to copy & paste my code into textbox/textarea and have the web tool format it nicely for various popular ...
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?