Questions tagged [formatting]
Styling information beyond the minimum of semantic elements: colours, styles (boldface, italic), sizes and special features.
278
votes
5answers
100k 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.
163
votes
12answers
255k 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
163k 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
31k 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 ...
36
votes
13answers
91k 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
6answers
72k 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?
33
votes
10answers
32k 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?
31
votes
3answers
141k 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
28k 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
93k 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
6answers
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?
18
votes
7answers
169k 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.
17
votes
5answers
20k 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
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
196k 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
3answers
26k 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 ...
12
votes
4answers
34k 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 ...
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: ...
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 ...
10
votes
3answers
9k 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
12k 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
4answers
21k 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 + ...
9
votes
7answers
38k 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 ...
9
votes
2answers
26k 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 ...
8
votes
6answers
46k 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 ...
7
votes
3answers
16k 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
704 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
2answers
8k 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
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
16k 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
9k 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
12k 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
4answers
16k 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 ...
7
votes
1answer
1k 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
4answers
19k 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 ...
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
5k 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
3k 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?
