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.

2
votes
2answers
390 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
21 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 ...
1
vote
1answer
143 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
26 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
212 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 ...
1
vote
1answer
150 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
163 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
9 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
33 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
20 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
53 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
243 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
1answer
123 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
106 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
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 ...
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 ...
3
votes
0answers
325 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
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 ...
2
votes
0answers
71 views

Repeat table column headings in MediaWiki

Is it possible in MediaWiki markup to repeat table column headings automatically?
1
vote
0answers
91 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
193 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
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
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
422 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
143 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
20 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 ...
0
votes
0answers
17 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
10 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
578 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
0answers
29 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
14 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 ...