Questions tagged [formatting]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
11 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, ...
2
votes
1answer
143 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
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 ...
5
votes
4answers
2k views

How do I keep borders when dragging down to fill cells?

I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill ...
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
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
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 ...
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 ...
6
votes
2answers
10k 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 ...
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 ...
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 -...
36
votes
3answers
50k views

How to change the default style of text links in Google Docs

I want to format the default style for text links—currently the color is blue & are underlined. Is this possible? And if yes, how can I do it?
0
votes
1answer
44 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 ...
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 ...
0
votes
1answer
97 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
51 views

Google Sheets: How to format decimal as fraction in drop down list (data validation)

I have a cell with data validation. The source of the validation is a long range of decimals in 0.0078125 (1/128) increments. The cell containing the validation is formatted to display fractions # ???...
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 ...
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 ...
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
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 ...
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 ...
0
votes
1answer
98 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 ...
62
votes
13answers
67k 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?
2
votes
1answer
2k views

How do I create a checklist in a slack message?

I'm trying to create a task list for myself in a private chat with my supervisor on Slack. I'm pretty familiar with markdown, and I thought that Slack supported it too. On GitHub, you can create tasks ...
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....
10
votes
2answers
22k views

How can I put an equation into a Google Slides and maintain the formatting?

I read a similar question on the Google Docs Help forums, but if I copy an equation that contains a symbol without using an image (such as the ∈ symbol), the symbol goes away in the presentation. Is ...
9
votes
2answers
21k 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 ...
6
votes
3answers
9k 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 ...
10
votes
3answers
15k views

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms with a question that contains a drop-down box with the following values: - Fewer than 10 - 11-25 - 26-50 - More than 50 If the user selects 11-25, Google Sheets renders the ...
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 ...
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?
5
votes
5answers
12k views

Paste numbers as string

I have one spreadsheet in Google Sheets with data like: 0012 0234 0065 I want to paste this in another Google Sheets but when I use ctrl+c ctrl+v the data is formatted like numbers: 12 234 65 I ...
242
votes
14answers
469k views

How can I get code syntax highlighting in Google Docs?

Is there way to switch on syntax highlighting in Google Docs? Personally I use it for editing and collaborating on C++ files, but PHP or SQL syntax highlighting also would be interesting.
19
votes
6answers
91k 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 ...
39
votes
3answers
173k views

How do you format Facebook Wall posts?

There doesn't appear to be any formatting links when I do a Facebook Wall post. Is there any way to do formatting like HTML, markup, etc?
1
vote
0answers
75 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. ...
21
votes
4answers
69k 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 ...
8
votes
3answers
18k views

Google Docs keeps reverting to Arial 11pt

I use Google Docs for typing up a lot of work, and I like to type it up in Garamond. However when I add line-breaks sometimes Google Docs decides to revert to Arial 11pt (the default style for a new ...
0
votes
1answer
2k views

Google Sheets: Fill out dates and replace blank cells with zeroes

I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable: I think there are two reasons for this: Not all dates have values associated with them, and ...
31
votes
3answers
39k views

Short number format in Google Sheets; 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: ...
9
votes
8answers
23k 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 ...
7
votes
8answers
46k views

Keep formatting when pasting to Gmail

I liked formatting my e-mails in MS Word and then copy and paste them into Gmail. I did it, among other things, because I could control line spacing and text alignment (I prefer it justified). Gmail ...
1
vote
2answers
2k 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 ...
3
votes
3answers
3k 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 "...
1
vote
1answer
2k 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 ...
1
vote
1answer
32 views

Formatting options in Gmail

I used to be able to see the formatting options (bold, italic, strike-through, etc) next to the "Send" button, but since some months I can't see it anymore (as in image). How can I bring it ...
12
votes
3answers
6k views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields (...
1
vote
4answers
4k 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 ...
6
votes
3answers
2k views

Format credit card numbers as four digit blocks in Google Sheets

I have this credit card number in a Google Sheets of the following format: XXXXXXXXXXXXXXXX How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in four digit ...
35
votes
9answers
49k 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 ...