Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [formatting]

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

-5
votes
1answer
45 views

How do I apply text effects like this in “The Three Evils” [closed]

I know there's an online utility that does it but I can't seem to find it. All my Googling has been in vain. The T̜͓̞̤͎ͦ́ͤ̓̄̚ḣ͖͙̘ͦͯ̾re͗̈́e ̙̥̘̙͉̺̜̐ͧ̍E͍̲̜͈͊v̹͙̝̗ils is the only example I could find of ...
1
vote
0answers
456 views

How do I format links in Google's My Maps location descriptions?

Google's My Maps supports the placement and customization of locations in its map edition, including the ability to add a "description" to added locations. However I don't see how to format links ...
1
vote
1answer
1k views

Can Google Docs auto-correct capitalization?

In Microsoft Word, you can change capitalization in a document using the Change Case button. It includes options for Sentence case, lowercase, UPPERCASE, Capitalize Each Word, and tOGGLE cASE. Does ...
3
votes
1answer
13k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
1
vote
1answer
164 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 ...
1
vote
0answers
26 views

G. Classroom Format Off

I have 14 students working in Google Classroom. One student is having this issue. When he "Creates" a document through the Google Classroom assignment stream, the document formatting is tiny and ...
3
votes
1answer
428 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 ...
2
votes
1answer
233 views

in Gmail COMPOSE EMAIL, how can I alphabetize a list as part of an email?

In MS Word and MS Outlook, I can alphabetize a list inside an email (using the AtoZ macro) - but I can't find how to achieve this in Gmail web browser client. Is it possible to do such advance edits ...
2
votes
1answer
5k views

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
0
votes
1answer
224 views

I cannot make text white in Google Sheets

I am trying to make text white in a Google Sheets. I select the text, changed its color to white: ... and when I click in another cell or press Enter to validate, it goes back to the base color: ...
0
votes
1answer
92 views

Excel spreadsheet into body of Gmail message without losing formatting

I am trying to copy and paste an Excel spreadsheet into the body of a Gmail message. I know I can attach it but the recipient can't receive attachments. The formatting stays but not the borders/...
1
vote
1answer
995 views

How to use strike-through style in the Flowdock chat?

Is there any possible way to use the strike-through style in the Flowdock chat, like * for italic, ** for bold. In the help page for formatting, I didn't see any way to use the strike-through style.
1
vote
2answers
64 views

How can I enter a date in the format I choose?

I am trying to create a spreadsheet with 5 sheets, there is going to be a date entered on sheet1, which will have a date+1 for the sequential days, i.e enter Monday's date and the following dates will ...
0
votes
1answer
496 views

Google Docs Markup When Posting into WordPress?

I write in Google Docs, then paste the content into WordPress. When I look at the HTML in WordPress, it has some extra markup added: < h2 >< b >Testing< /b ></h2> < span ...
5
votes
3answers
7k views

How to change the text line height in one cell?

I could not find an option in the recent version of Google Sheets to change the text line height (the spacing between lines in a single cell). You realize the problem even more when exporting the ...
2
votes
1answer
116 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" ...
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 ...
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 ...
3
votes
0answers
107 views

For Google Docs tables, how can we make an incomplete row have no bottom or top border (to show that it is incomplete on screen and on paper)?

When we use Google Docs and create a table, sometimes a cell can span across two pages. So for example, I can write a few lines (with Enter (line breaks)), and then, either on screen or on paper, the ...
4
votes
1answer
629 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
0answers
1k 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 ...
3
votes
0answers
102 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 ...
6
votes
1answer
6k 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 ...
1
vote
1answer
934 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 ...
13
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: ...
1
vote
1answer
109 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?
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 (...
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 ...
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 ...
3
votes
2answers
2k 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 how ...
2
votes
1answer
1k 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 ...
1
vote
3answers
12k views

Conversion from object to string in Google Apps Script

I'm trying to take information from Google Sheets and use it to send an email with the information given in sheets. I have the email part down, but when I try to editAsText to delete unwanted ...
2
votes
1answer
4k views

How do I transpose data in a Google Sheets and keep the formatting?

If we select a empty line and we type: =TRANSPOSE(A1:C27) We will invert everything from A1 to C27. However, formatting will be lost. Is there any way to keep the format too?
3
votes
1answer
308 views

Google Docs date capitalisation script

I'm using a script that was posted here on Web Applications: Is there a way to insert today’s date into a Google Docs?. I changed the way the date is formatted to: ddMMMyyyy but want 01JAN2015 - the ...
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 ...
11
votes
3answers
5k 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
2answers
6k views

Formatting Duration values

I have a Google Spreadsheets in which I have: Date | Start | End | Duration -------------+-------------+-------------+------------------------- 11/24/2014 | 8:36 AM | ...
1
vote
2answers
4k 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 1,...
3
votes
0answers
450 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 will ...
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
0answers
423 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 cut-and-...
1
vote
1answer
6k 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 ...
0
votes
1answer
3k 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?
0
votes
1answer
90 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 ...
2
votes
1answer
105 views

Gmail action buttons

Recently Gmail started showing "action" buttons next to emails that have links to trigger actions on certain third-party sites. For instance: At first, I only noticed it with emails from Amazon, but ...
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 ...
2
votes
0answers
308 views

Making Zimbra web mail format replies for not top posting?

My company uses Zimbra web mail. I participate in a lot of traditional mailing lists, where top-posting is frowned upon. When I hit reply, I want the message set up for interleaved reply, but instead ...
1
vote
1answer
55 views

Wiki markup with templates

I have a template where I would like to include a variable {{{1}}}, but I also want the text that will be placed there to be in <code>{{{1}}}</code> tags. But in that case wiki just ...
2
votes
1answer
689 views

Mathematics cases in Google Documents

How can I write mathematics equations with multiple cases in Google Documents? I can't get the code below to work. This is how I would create it in LaTeX: \begin{cases} 0 & n = ...
2
votes
1answer
581 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 "...