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.

0
votes
1answer
13 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 ...
19
votes
8answers
26k views

Can you add basic text formatting (bold, italic) in Yammer posts?

When writing a post (or a comment on a post) in Yammer, is there any way to add basic text formatting such as bold or italic text?
0
votes
1answer
100 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 ...
0
votes
0answers
7 views

sSheet DateTime format

I am using AppSheet to create a Timesheet App and on the App, I have to use the DateTime format to be able to calculate overtime and regular hours correctly. My gSheet DateTime format returns a start ...
4
votes
3answers
63k views

Google Docs is altering my formatting, how can I avoid this?

I don't have a printer and I need a document printed. Thus, I've shared a very basic Google Docs document with someone who does have a printer. Over here the formatting looks fine. Tabs are correct, ...
7
votes
3answers
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 ...
8
votes
7answers
49k 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 ...
1
vote
1answer
21 views

How to prevent sub-lists numbering restart under each bullet?

Google doc's numbered list functionality restarts sub-list "numbering" or "sequential lettering" like this: 1) First thing a) b) 2) Second thing a) <- Sub-list numbering / sequential ...
0
votes
2answers
37 views

Google Sheets auto move to next cell

I have an ID format checker that has a row of cells that can only have one specific kind of character in each cell, and then all characters are compiled in order into another cell to create the ...
0
votes
1answer
34 views

Formatting script applicable to a range, not an entire sheet

I have the following script, which applies formatting in row 1 to an entire spreadsheet. How can I limit the formatting application to a range (ex. A7:AN135), so that the header rows are excluded from ...
1
vote
1answer
151 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 ...
0
votes
1answer
40 views

How do I switch Gmail from top-posting by default to bottom-posting by default?

I can't seem to find any option for switching Gmail from top-posting by default to bottom-posting by default. I can do it by manually expanding quoted stuff and moving the cursor, but I'd rather be ...
0
votes
1answer
143 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 -...
17
votes
5answers
21k 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 ...
0
votes
0answers
26 views

One script for multiple tabs in one Google sheet

Can you please help me with this script? I've tried to edit it to apply to multiple tabs the same as the original question. But I think something's amiss. :( Here's the original code and I want this ...
1
vote
1answer
573 views

How do I have one page in portrait and the rest in landscape in Google Docs?

I am working on a school project and I need one page in portrait and the rest in the landscape. I would rather not have multiple documents though. Any suggestions?
0
votes
1answer
26 views

Why is alignment off in cells?

When the cell alignment is set to center it's actually more to the right. I've tried several reformating options including reset. The cells have no formulas, just text.
3
votes
11answers
45k 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 ...
2
votes
1answer
628 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 "...
6
votes
4answers
20k 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 ...
4
votes
1answer
366 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
2answers
386 views

Row height would not auto-adjust to fit content anymore

I selected the whole sheet and re-sized the height of all rows at once to a certain height by clicking "Resize rows 1-1000" in the context menu. Then I entered some text in a cell and the text did ...
283
votes
5answers
102k 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.
1
vote
1answer
235 views

IF statement not working in Google Sheets?

So I'm using Google Sheets and I'm trying to determine whether or not cells in a certain column AO have a higher value then cells in another column O. My formula is =IF(AO6 > O6,"UNDER","OVER"). ...
1
vote
1answer
35 views

Google Sheets function returns an incorrect value

I have a very simple function for every cell in column D, for example: D24 =C24-(B24*N$2) Example with values: D24 =10-(1*6,5) This works; however, not all the time. For cell D24 this returns a ...
0
votes
1answer
374 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 ...
2
votes
2answers
463 views

How to make a list like 1.1, 1.2 with Google Docs?

I tried everything and this just doesn't seem to be possible anymore? It can do 1.1 Text 2.1 Text but not 1.1 Text 1.2 Text
1
vote
1answer
461 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 ...
13
votes
2answers
6k 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: ...
0
votes
1answer
20 views

Prevent the stretching from changing cells border in Google spreadsheet

Is it possible to prevent the stretching from changing cells border in Google spreadsheet? I mean that if I stretch a cell which has a border above it, then the same border will be added to the cells ...
12
votes
4answers
35k 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 ...
0
votes
1answer
125 views

How can sub-lists at the same level be given mixed list styles?

It seems if you change the list style (e.g. Roman numbered, or square bullets) in Google Docs for a list at a certain level, other sub-lists at the same level are also changed. For example, you can't ...
4
votes
3answers
1k 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-...
5
votes
3answers
8k 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 ...
1
vote
1answer
180 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 ...
2
votes
1answer
20 views

What's the difference in using the internal formatting and using TEXT to format cells?

What's the difference in using the Formatting drop-down and using =text() to format cells? Which one overrides the other or take priority? It seems I'm having some formatting conflict that is breaking ...
0
votes
1answer
517 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 ...
2
votes
1answer
23 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) ...
3
votes
1answer
8k 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 ...
8
votes
4answers
18k 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 ...
1
vote
1answer
17 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 ...
1
vote
1answer
428 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.
-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 ...
34
votes
10answers
34k 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?
0
votes
1answer
36 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
14 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, ...
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 ...
47
votes
4answers
26k 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 ...
0
votes
0answers
631 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
426 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 ...