Stack Exchange Network

Stack Exchange network consists of 174 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.

1
vote
1answer
16 views

How export a spreadsheet as XML?

How can I export a simple spreadsheet, consisting of a single column of data, as XML? Exporting as CSV is leading to other problems, so turning to XML as a workaround.
0
votes
1answer
17 views

How to make date automatically display only day number and suffix (1st, 2nd, etc.)?

Title explains it. I need to know how to create a custom number format in which a cell would display only the date and suffix of a full date entered into the cell example:1/05/2019 -> 5th I have ...
1
vote
1answer
15 views

Custom formatting with data returns what the cell shows but not what the cell contains

Basically I have this set up in one of my sheets in which these cells have data validation for "is valid date" so a calendar shows up when you double click them, then it has custom formatting so ...
0
votes
1answer
28 views

Setting minimum row height

In the past, I used to open a new spreadsheet, resize all lines (the default feels way too cramped for me), and then enter data. If at some point I entered data longer than the row height, it would ...
0
votes
0answers
6 views

Is it possible to auto indent in papeeria LaTeX editor?

I am using Papeeria LaTeX web editor and I am highly satisfied with it, but one feature I am missing – I am not able to make Papeeria auto-indent my LaTeX code. Is it possible?  I am a free user, ...
0
votes
1answer
29 views

Google Doc - applying headers to single line only - after pasting as plain text

The issue: https://youtu.be/OXS3wTR7YJw Make notes in "Notes" (better for offline) Paste into Google Doc Apply a header Sh!t the whole thing is formatted now Related but not the same: Create ...
0
votes
0answers
205 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 ...
0
votes
1answer
24 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 ...
0
votes
2answers
28 views

How to format code in Blogger

I am writing one article on Blogger, There I am unable to format code. The code I am writing is looking like simple text. The site name https://www.blogger.com/ I am using <div class="...
0
votes
0answers
13 views

Google Sheets Custom Number Format 'Broken'?

I somehow did this when creating a custom number format. Any idea as to how to fix this?
0
votes
0answers
11 views

Google Sheets Conditional Formatting

I'm trying to finish up a Google Sheet with some conditional formatting that I can't figure out. Here's the best description I can come up with. If Column A matches in any row, then the formula ...
0
votes
0answers
30 views

How to set a single page's properties? [duplicate]

The goal is to selectively configure a single page of a multi-page document to: landscape (hyperlink to similar, yet a subset of this question) and paper size A3. The hope is that the link is ...
0
votes
1answer
119 views

How to change the default font & font size in Google Documents? [duplicate]

I really hate Arial, which happens to be the default for Google Docs. Does anyone know if there is a way to change the default font and font size in Google Docs? Thanks.
2
votes
0answers
28 views

How do you change the default indent and set your own in Google Documents?

I don't like how the default when you open a new Google Doc is no first line indent. Is there a way to customize the default?
0
votes
1answer
43 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
1answer
788 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....
1
vote
1answer
537 views

Weird behavior with “Wrap Text” in tables

I'm trying to add an image at the beginning of cell of a table that Wraps text however, for some bizarre reason it seems also block out space in the cell to the right. Where as, I'd expect something ...
2
votes
1answer
19 views

How to format one cell to match formatting of another (even if “other” changes later)?

How can I do the Style equivalent of setting one cell equal to the style of another cell, even if the "other" cell style changes? use Case: I want all Row #2 of each sheet to look like (same style) ...
0
votes
1answer
739 views

Google Docs date in yyyy/mm/dd format (year first)

My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet? BUT unlike those answers, I'm trying to get the ...
1
vote
1answer
18 views

What's the shortcut key for code block?

How to format a selected piece of text as a code block in slack?
1
vote
0answers
45 views

How can I get a custom outline numbering template in Google Docs?

I've seen a few questions around about what I thought was outline numbering, but instead was about headings. I'm specifically talking outline number formatting. I wish to make an outline in the ...
0
votes
0answers
27 views

Protect the Formatting on a public Google Sheets Spreadsheet [duplicate]

I have a shared spreadsheet that users can edit data in. The only problem is, that whenever someone copy and pastes data, the format changes, and I'm always going in to fix it (somewhat of a pain). I ...
0
votes
0answers
11 views

How can I create a web Form which allows me to display each question on a single line? [duplicate]

I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
1
vote
0answers
135 views

how export a PC build to a spreadsheet

PC part picker has an export to HTML button, which is all fine and dandy. I would be more interested in exporting to an actual spreadsheet, however. Google sheets would be fine, or CVS, anything ...
6
votes
4answers
1k views

How to left align dollar symbol but right align number?

I selected format -> number -> more formats -> custom number format: $#,##0_);[Red]($#,##0) How can prepend spaces between the $ symbol and the digits? Pad with spaces. So that the dollar sign is ...
1
vote
1answer
2k views

How can I format a pivot table with staggered elements to make narrower?

Right now a typical pivot table looks like this: This takes up too much room horizontally. I want to format it so that it is narrower and taller, by moving nested blocks down and left. How can I ...
2
votes
1answer
33 views

Unconditional formatting universally applied in Google Sheets

How do I change the default color for anything which I type into Google Sheets? When it's a URL it seems to go to one color, when not, another. I'm not looking to delve into JavaScript. I just ...
3
votes
1answer
57 views

Make each cell in a column update from the same row of another sheet?

I'm looking for a function I could apply to a column that would make each cell in the column check the value of the first cell in its row and the first cell in its column and then return a value from ...
3
votes
2answers
880 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-...
-1
votes
1answer
23 views

How to change formula output directly?

I have a formula which produces some text, how do I highlight a part of the text to change the part's color?
6
votes
4answers
9k views

How to create a checkbox column, that if selected will create a strike-through across the entire row in Google Sheets?

I have a Google Sheets. I want to set it up so that the first column is checkboxes, and if the checkbox is selected, the entire row gets a strike-through. How can I accomplish this? I followed this ...
3
votes
1answer
464 views

How to change number stored to a plain text format in Google Sheets?

I have numbers stored in a sheet as (xxx) xxx-xxxx. I want to remove all formatting and make it just xxxxxxxxxx. How can I accomplish this?
1
vote
1answer
141 views

Creative Cognito Forms notification email that contains all form details

I would like the email that I receive as a notification from a Cognito Forms entry to have the same formatting as the PDF document I can download. I would want it to look like the form as it is being ...
1
vote
1answer
22 views

Different appearance for different GPS pins in CommCare's map reports

I am developing a map report in CommCare's report builder. I would like the different GPS points on the map to have a different appearance depending on a filter. For example, if the client at the GPS ...
3
votes
1answer
6k 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 ...
1
vote
1answer
221 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 ...
-5
votes
1answer
40 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
409 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 ...
2
votes
1answer
10k 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
130 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 behavior I want in Google Sheets. What I ...
1
vote
0answers
25 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
372 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
184 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
3k views

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
0
votes
1answer
182 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
87 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
835 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
57 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
380 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 ...