Questions tagged [formatting]

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

37 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
5answers
11k views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". In other words, I want to highlight them so that they can be copied, formatted, etc. How ...
3
votes
0answers
242 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
132 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
644 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
409 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
9 views

Showing Inline Section Headers in Document Outline

I am attempting to follow the APA style guideline for section headers. Under their guidelines, there are 5 different styles of section headers. The first three levels are on their own line, but the ...
2
votes
1answer
144 views

Google Docs: changing formatting of normal text without affecting automatically affecting headings

Applying a change to the indentation of normal formatting (e.g. first line indent) in google docs results in an automatic change to the indentation settings of all the other styles. It seems they have ...
2
votes
0answers
230 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 ...
2
votes
0answers
635 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 ...
2
votes
1answer
2k 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
319 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
156 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: &...
2
votes
0answers
76 views

Repeat table column headings in MediaWiki

Is it possible in MediaWiki markup to repeat table column headings automatically?
1
vote
0answers
15 views

Google Docs paste, using formatting of destination document

I want to copy/paste a bunch of content from one Google Doc to another. The two documents have different formatting (particularly fonts for Headings). If I do a regular paste (ctrl-v), the headings ...
1
vote
0answers
9 views

Google Slides Default Paragraph Line Spacing

Google Slides has seemingly changed default paragraph styles in a recent update. Now, after pressing Enter (i.e. inserting a new paragraph), the last line on the previous paragraph gets extra line ...
1
vote
0answers
11 views

Insert section break odd/even page

In Microsoft Word, when I insert a section break, I can tell it to start the next page on an odd page or even page: Is there a way to do this in Google Docs?
1
vote
0answers
76 views

How to use unofficial features in Facebook group post editor?

Recently formatted text cannot be pasted into Facebook group post editor. It will be converted to plain text. This is inconvenient if you have a well formatted text, and now have to reformat it again. ...
1
vote
0answers
11 views

Is it possible to format row fill colour by a cell in an expandable way? if new job number, new row colour

I keep a to do list. Each row has a job number. There are several entries for each job number. I'd like to ask google sheets to look at the job number in column. Give the row a colour. Every time a ...
1
vote
1answer
588 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
1answer
225 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
0answers
734 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
694 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
0answers
12 views

How do I change the colors of most draw.io icons?

All I can find is documentation for changing "SVG" file colors on this page: https://www.diagrams.net/doc/faq/svg-edit-colours But most of the icons in the shapes library are not svg files, ...
0
votes
1answer
21 views

draw.io: How to remove the tiny white space between two lines

If you were to align two straight lines, one on top of the other, such as this: A tiny white space exists between them. Is there any good way to remove such an artifact? Obviously in this case above ...
0
votes
1answer
100 views

System of equations in draw.io

I'm looking for a way to write a system of equations in draw.io. I know how to do it in latex, but it seems that the syntax is different in draw.io. Could you tell me how to do it please? In latex I ...
0
votes
1answer
103 views

A *faster* faster way to access Strikethrough on Google Docs

The keyboard shortcut for strike-through in the Google Docs web UI is AltShift5 (yes that is a five), and the toolbar doesn't have a strike-through button. It's very awkward (I actually have to swivel ...
0
votes
0answers
9 views

Preserving text formatting including pictures from Google Slides when copying into Google Docs or other apps used in eBook publishing

How can formatting be preserved when exporting from Google Slides into other apps that are used in eBook publishing such as Docs? The ms was constructed with the usual text and picture boxes in Slides....
0
votes
1answer
40 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
0
votes
1answer
32 views

Specifying the position of an element (e.g. line) in draw.io

I'm wondering if it's posssible to specify the exact position of a line in draw.io. It seems that the only way to do that is the reduce the size of the grid.
0
votes
0answers
13 views

How to conditional-format text of a cell using a colour scale in MS Excel?

I know how to do this conveniently with the background colour of a cell, but when it comes to the font colour itself there seems to be such no automated method. I have searched throughout this site ...
0
votes
1answer
46 views

Cannot get rid of some space/margins

I'm working on my resume in Google Docs (Word processing) and I'm trying to add my name + personal information at the top, but I'm seeing a line of space above it. As you can see, I'm trying to get ...
0
votes
1answer
42 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
2k 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
508 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
320 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 ...
-1
votes
1answer
1k 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 ...
-1
votes
2answers
2k 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 ...