Questions tagged [formatting]

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

2
votes
3answers
530 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
0
votes
2answers
59 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
2answers
525 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 ...
1
vote
1answer
351 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
46 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 ...
1
vote
1answer
153 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
215 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 ...
0
votes
1answer
13 views

How do I remove custom currencies in Google Sheets?

In Google Sheets, you can add custom currency things under the formatting tab and google sheets with keep them saved. I was playing around with this function and added a few ones to test it out but ...
0
votes
1answer
14 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 ...
0
votes
1answer
63 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
29 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.
0
votes
1answer
131 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
1answer
714 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
165 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 -...
3
votes
0answers
124 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 ...
3
votes
0answers
107 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 ...
3
votes
0answers
461 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 ...
3
votes
0answers
330 views

Is there a setting/extension to disable HTML formatting in received Gmail messages?

I want all INBOX messages in gmail to appear in plain text. When I read the messages I receive, I just want everything appearing in a consistent font and size of my choice. No html formatting ...
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 ...
2
votes
0answers
309 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 ...
2
votes
0answers
72 views

Repeat table column headings in MediaWiki

Is it possible in MediaWiki markup to repeat table column headings automatically?
1
vote
0answers
119 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 ...
1
vote
0answers
226 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 ...
1
vote
0answers
494 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
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 ...
1
vote
0answers
475 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
0answers
145 views

How can I properly format text quotes such that Gmail will render them graphically?

To see what I have in mind see following screenshots from my Gmail. Whole thread is publicly accessible in gmane. His quoting format (raw source): On 9/21/2013 11:43 AM, Marcin Wi=C5=9Bnicki wrote: &...
0
votes
0answers
8 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 ...
0
votes
0answers
27 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 ...
0
votes
0answers
16 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
0answers
32 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
15 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 ...