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
20
votes
3answers
42k 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 ...
239
votes
14answers
467k 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.
399
votes
6answers
147k 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.
55
votes
13answers
146k 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 ...
39
votes
3answers
173k 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
39k 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: ...
10
votes
3answers
15k 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 ...
9
votes
2answers
20k 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 ...
4
votes
1answer
2k 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 ...
2
votes
1answer
3k views

Partial cell formatting with CONCATENATE in Google Sheets

Is there a way to format partially using CONCATENATE in Google Sheets? For example, =CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the * bolded or blue in color or something else. I ...
56
votes
2answers
200k views

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

Is there a easy way to insert source code with highlight in Google Docs?
62
votes
13answers
67k 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?
12
votes
4answers
31k 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 + ...
48
votes
4answers
28k 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
3answers
50k 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?
52
votes
2answers
35k 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.
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 ...
6
votes
1answer
14k 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....
12
votes
5answers
54k 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 ...
11
votes
7answers
93k 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
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?
4
votes
2answers
10k views

In draw.io, is there a way to automatically position a swimlane or process diagram?

I've drawn a workflow/process diagram in draw.io, but each time I make small changes I have to move everything else around. Is there anything that automatically re-positions the diagram when I make ...
1
vote
1answer
1k views

Custom number format for large dollar amounts (positive and negative)

I'm trying to create a custom number format that will display big dollar amounts with the typical k/M suffixes. Examples: $1 $12 $123 $1.2k $12.3k $123k $1.2M $12.3M And, actually, I partially ...
-1
votes
1answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...
6
votes
3answers
9k 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 ...
4
votes
1answer
1k views

Custom Number Format for scale-aware number formatting in Google Sheets (e.g. 1,200→ 1.2k; 1,200,000 → 1.2M; 1,200,000,000 → 1.2B)

Does anyone know a generalized Custom Number Format I can apply in Google Sheets such that numbers appear with it's scale operator and rounded to one decimal place? Example: I looked up a good ...
4
votes
5answers
6k views

Auto-fill date function changes the YEAR and not the day

I'm trying to get Google Sheets to auto-fill dates in the beneath cells after I have manually filled one myself. The strange issue is that when I hold Command key and drag down, the cells auto-...
3
votes
0answers
132 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 ...
2
votes
1answer
7k views

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
2
votes
2answers
7k views

Formatting Duration values

I have a Google Spreadsheets in which I have: Date | Start | End | Duration -------------+-------------+-------------+------------------------- 11/24/2014 | 8:36 AM | ...
2
votes
1answer
203 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...
1
vote
1answer
3k views

Highlight cell border in Google Docs

I'm trying to create a table in Google Docs. I need a header row at the top and a similar column on the left side. To distinguish these from the rest of the table I am trying to embolden the line ...
1
vote
1answer
2k views

How to add an outline border to a table in Google Docs?

I am trying to add only a border outline to a table in Google Docs however when trying to make all lines except the border lines another colour, this happens: As you can see, white spots where the ...
1
vote
1answer
689 views

How to color an adjacent cell based on a 6-digit hex number without adding the "#"

I've looked at a few things (this link, WA's Colorize a cell in Google Spreadsheets based on cell data, and this link), but haven't been able to quite get the behaviour I want in Google Sheets. What I ...
0
votes
1answer
42 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...