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

learn more… | top users | synonyms

9
votes
13answers
26k 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 ...
2
votes
0answers
13 views

Formatting Google Sheet Dates Inconsistent

I have a sheet where various data is entered through a form. Dates are picked on the form using the standard date picker provided by Google Forms. Some dates in a column I can change the date format ...
19
votes
12answers
59k 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 ...
5
votes
6answers
75k 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 a carriage returns ...
2
votes
0answers
18 views

How can I insert a text item (question) with multiple response fields (and descriptions) in Google Forms?

I'm trying to create a survey/Google Form specifically to export data into an Excel sheet. This isn't very important because I can tweak the arrangement after the fact, but naturally I have a lot of ...
21
votes
1answer
2k 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?
5
votes
3answers
2k views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
1
vote
7answers
6k 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 ...
3
votes
0answers
34 views

What's the full range of supported Google Docs LaTeX macros?

Google Docs has an equation editor that has a fair number of options for symbols and functions available from the dropdown menu. All of these are also available through LaTeX macros that are ...
15
votes
6answers
16k views

How to center a table in Google Docs?

Centering data within a table cell or cells in Google Docs is straightforward and easy (highlight and center). But how to center an entire table? This should be easy, but it isn't. I can't for the ...
2
votes
1answer
113 views

Italicize one word and not others in draw.io

I am using draw.io to make diagrams related to genetics. It is convention in my field to italicize gene names. I would like to have a box that says "genename::cDNA" where "genename" is italic and ...
9
votes
4answers
3k views

Always a line above where I insert a table?

In google docs, when I insert a table, there seem to be always a line above the table as shown in the screenshot below
3
votes
3answers
3k 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 ...
3
votes
2answers
6k 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 ...
2
votes
1answer
18 views

How to convert all numbers regardless of decimal separator into valid number of current locale in google sheet

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 ...
3
votes
3answers
5k 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 + ...
1
vote
1answer
79 views

Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example font size to 12, for the whole sheet, newly copied data uses a smaller font size. This only started being an ...
8
votes
2answers
3k 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?
4
votes
1answer
100 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: ...
1
vote
1answer
23 views

Blogger: How can I add a “Code” paragraph type?

Blogger paragraph types are Normal, Heading, Subheading, and Minor Heading. How can I add a Code type that will set a small, bold, fixed-width font?
1
vote
1answer
146 views

How to make bullet sizes match in web app vs printed in Google Docs when using a non Arial font?

I've come to realize that seemingly only Arial font will print my Google Doc bullets in the correct size. If I use a different font, this happens: In browser: Printed/downloaded to PDF: Notice ...
11
votes
4answers
7k 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?
5
votes
2answers
949 views

Format credit card numbers as four digit blocks in Google Spreadsheets

I have this credit card number in a Google Docs spreadsheet 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 ...
2
votes
2answers
11k 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, ...
2
votes
0answers
86 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 ...
5
votes
3answers
4k views

Cell reference with colour formatting

Is it possible to reference a cell in Google Spreadsheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference dell's value. ...
2
votes
1answer
44 views

google cell format: only 3 digits

Is there any way to do this: I have cell and most of the numbers have 2 significant digits like 3.45. But once in a while I have a number like 143 big number, the rest are under 10. Currently for 143 ...
5
votes
4answers
10k 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?
6
votes
2answers
9k 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 ...
4
votes
2answers
13k 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 ...
0
votes
1answer
24 views

Format link to Wikipedia page about an essay or chapter title

For books and movies it's easy: surround the link in pairs of single-quotes to italicize it. For example, Lord of the Rings. ''[[Lord of the Rings]]'' But according to "Which Titles Are Italicized ...
8
votes
2answers
599 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 ...
2
votes
1answer
1k views

How to make a protected range appear normal in Google spreadsheets

I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. ...
1
vote
2answers
681 views

Issue with Custom number format in Google Spreadsheet

I have a number cell formatted in this way: #,#" days";. Nevertheless, if I write 1.5the output is 1 days even if the content is still 1.5. Otherwise, if I write 1,5 the output will be as it is ...
0
votes
1answer
128 views

What's the best format for multi-word hashtags in tweets?

What's the best format for multi-word hashtags in tweets? Some candidates for consideration are, supposing a phrase's normal writing is "foo Bar baz": #FooBarBaz (camel-cased) #foo_Bar_baz ...
3
votes
0answers
142 views

Permanently enable plain text mode in Yahoo! Mail

The last button (icon) in the image below is Switch to Plain Text mode. It fits perfectly with my needs. How can I permanently switch to plain text mode? (If there is no such feature, I guess I ...
38
votes
3answers
18k 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 ...
6
votes
2answers
3k 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 ...
2
votes
3answers
6k views

How do you post a Facebook Note in a group or on a page?

To make formatted posts on Facebook you have to use Notes. This is fine for posting on your wall, but how do I post a Note to a group or page, or is it impossible to post a formatted post using those ...
39
votes
2answers
16k 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.
1
vote
1answer
299 views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...
2
votes
0answers
64 views

Can't unmerge cells

I have a lot of data in a Google spreadsheet that depends on charts I spent ages trying to make look pretty. There is a stupid block of merged cells that won't unmerge, and when I try to ...
6
votes
2answers
3k 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 ...
3
votes
2answers
3k views

Using code in Trello Cards

In Markdown, you should be able to specify a block of code that will not trim whitespace by using four spaces in front of every line of code. Why doesn't it work?
11
votes
5answers
51k views

Change background color of single page in Google Document

I would like to know how to change the background color of single a page in a Google Document. I want to make the Cover Page attractive.
5
votes
1answer
2k 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 ...
0
votes
1answer
142 views

How to highlight selected text

Did Google for some reason remove the feature to highlight selected text in a document? How can it be done now?
3
votes
1answer
7k views

How can I highlight selected text in a cell and not the whole cell? [duplicate]

In my Google Spreadsheet, I have a lot of text in a cell and want to highlight a small portion of this text with a particular colour. But, whenever I try to do this, the formatting gets applied to ...
21
votes
3answers
74k 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?
5
votes
2answers
898 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 ...