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
53k 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 ...
Robert Koritnik's user avatar
289 votes
13 answers
593k 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.
Kirill V. Lyadvinsky's user avatar
447 votes
6 answers
166k views

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
182k 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 ...
Ivan's user avatar
  • 2,067
39 votes
3 answers
176k 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?
Lance Roberts's user avatar
36 votes
5 answers
62k 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: ...
jm3's user avatar
  • 465
14 votes
2 answers
36k 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 ...
kristen maul's user avatar
10 votes
3 answers
16k 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 ...
hairboat's user avatar
  • 1,614
4 votes
1 answer
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 ...
JohanHorak's user avatar
2 votes
1 answer
8k 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 ...
user650654's user avatar
80 votes
15 answers
102k 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?
Jiew Meng's user avatar
  • 1,251
56 votes
2 answers
212k views

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
71k 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 ...
SlowDeep's user avatar
  • 281
18 votes
5 answers
35k 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 + ...
Doug's user avatar
  • 181
48 votes
4 answers
29k 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 ...
Jack's user avatar
  • 626
44 votes
3 answers
72k 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?
Nam G VU's user avatar
  • 3,614
17 votes
5 answers
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 ...
F1234k's user avatar
  • 281
14 votes
2 answers
21k 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....
Shimmy Weitzhandler's user avatar
12 votes
7 answers
98k 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 ...
sam's user avatar
  • 6,979
11 votes
13 answers
108k 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 ...
Steve's user avatar
  • 307
10 votes
4 answers
17k 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 ...
RobG's user avatar
  • 203
7 votes
5 answers
18k 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?
EKK's user avatar
  • 1,052
5 votes
1 answer
2k 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 ...
nin10doe's user avatar
5 votes
2 answers
13k 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 ...
user33085's user avatar
4 votes
5 answers
13k 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-...
Adele halsall's user avatar
3 votes
0 answers
158 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 ...
Erik's user avatar
  • 191
2 votes
2 answers
7k views

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
8k views

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
Antony Hatchkins's user avatar
2 votes
1 answer
232 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" ...
Lup's user avatar
  • 21
1 vote
1 answer
99 views

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

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
4k 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 ...
Michael's user avatar
  • 558
-1 votes
1 answer
2k 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 ...
marikamitsos's user avatar
  • 12.9k