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
21 votes
3 answers

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
289 votes
13 answers

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
447 votes
6 answers

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
71 votes
14 answers

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
39 votes
3 answers

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

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
14 votes
2 answers

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
10 votes
3 answers

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
4 votes
1 answer

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 ...
JohanHorak's user avatar
2 votes
1 answer

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 ...
user650654's user avatar
80 votes
15 answers

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
56 votes
2 answers

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
18 votes
6 answers

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
18 votes
5 answers

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
48 votes
4 answers

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
44 votes
3 answers

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
17 votes
5 answers

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
14 votes
2 answers

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
12 votes
7 answers

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
11 votes
13 answers

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
10 votes
4 answers

Stop Google Sheets formatting text as URL

When I type "" or "" 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
7 votes
5 answers

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?
EKK's user avatar
  • 1,052
5 votes
1 answer

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 ...
nin10doe's user avatar
5 votes
2 answers

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

I've drawn a workflow/process diagram in, 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 ...
user33085's user avatar
4 votes
5 answers

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-...
Adele halsall's user avatar
3 votes
0 answers

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 ...
Erik's user avatar
  • 191
2 votes
2 answers

Formatting Duration values

I have a Google Spreadsheets in which I have: Date | Start | End | Duration -------------+-------------+-------------+------------------------- 11/24/2014 | 8:36 AM | ...
JQuery Mobile's user avatar
2 votes
1 answer

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
Antony Hatchkins's user avatar
2 votes
1 answer

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" ...
Lup's user avatar
  • 21
1 vote
1 answer

Formatting options in Gmail

I used to be able to see the formatting options (bold, italic, strike-through, etc) next to the "Send" button, but since some months I can't see it anymore (as in image). How can I bring it ...
duff18's user avatar
  • 113
1 vote
1 answer

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 ...
Tom's user avatar
  • 113
1 vote
1 answer

How to copy plain text HTML/formatting method into Google Docs

I currently have a script that generates an amount of text. I want this script to be able to output some text with a formatting style into STDIN (preferably MD/HTML) and I can then paste it into ...
WarriorX's user avatar
1 vote
1 answer

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 ...
Michael's user avatar
  • 558
-1 votes
1 answer

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 ...
marikamitsos's user avatar
  • 12.9k