Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
2 votes
1 answer
107 views

Google Sheets: how to format currency with numbers right-aligned but +/- and $ left aligned and padded with spaces?

I've already looked at: How to left align currency symbol but right align number? How to left align dollar symbol but right align number? The best number format I have so far is: [$$]* #,##0 which ...
Ryan's user avatar
  • 774
-1 votes
3 answers
107 views

Script to change specify text style within Google Sheet's cells, but I cant seem to style text manually

I have a script in Google Sheets that automatically finds and formats specific text substrings within a cell that I edit. A side effect of using the script is that it will reapply the existing cell ...
Padang's user avatar
  • 1
0 votes
0 answers
21 views

Retain Row Formatting When Sorting

After performing a sort, the row's formatting doesn't retain it's row height and other custom format, and the row the data was in previously will retain the prior height/format instead of becoming the ...
Jinian's user avatar
  • 1
0 votes
0 answers
108 views

How do I change the color of all hyperlinks in draw.io?

How do I change the text color and underline color of all hyperlinks in a draw.io shape's text? I have a diagram with dark colored shapes and white text, however hyperlinks are formatting as the ...
Paul's user avatar
  • 1
0 votes
0 answers
88 views

Google spreadsheets : display all decimals, but no trailing zeroes [duplicate]

I want a number format that achieves both these results in one go : 1.2 3.456789 If change the number of decimals I can either get : 1.2 3.5 OR : 1.200000 3.456789 Neither of which I do want.
Charles's user avatar
  • 123
0 votes
1 answer
816 views

Automatically append text in cell to URL in Google Sheets

Suppose I have a Google spreadsheet with a column of codes which correspond to a URL suffix. In this case, I have papers on arXiv listed as follows: arXiv 1712.03255 2303.14090 2012.02922 How ...
Harry Chittenden's user avatar
2 votes
1 answer
63 views

How do I make the weight column in my medical log sheet get updated with the most recent weigh-in?

I am looking to get the weight column in my medical log sheet to be updated automatically when I key in the new weights on my Weight Log sheet. I take the weights weekly and update the info into a new ...
user307336's user avatar
1 vote
1 answer
871 views

How to Change Percentage Precision on Google Sheets Scatter Chart

I have made a scatter chart on Google Sheets from two columns of data. One column labeled "Pre-EO Remediation Rate" and one column labeled "Length of Pathway (Semesters)". A sample ...
Jetninja's user avatar
1 vote
1 answer
996 views

How to get a very wide code block in Code Blocks Extension for Google Docs with little to no handiwork?

When you copy and paste from the console output, you will often have linebreaks. You can avoid that by shifting the right border of the Code Blocks field by the length of what is left over at the ...
questionto42's user avatar
1 vote
2 answers
54 views

How to set the space between two lines in Asana when pasting code in the description window?

Asana offers rich text, a mode where you can add headers, change style, and if you press Enter without holding Shift, you will get a bigger space between the lines than with Shift. Here, you see how ...
questionto42's user avatar
1 vote
1 answer
161 views

How to put coloured HTML text in the way that it is shown in a browser into Google Docs?

This is taking up How to copy plain text HTML/formatting method into Google Docs. Taken from How to copy the "tree" command output from Linux Terminal without losing the red/blue/white ...
questionto42's user avatar
6 votes
2 answers
9k views

How to replace dumb quotes with smart quotes in Google Docs

I have a very long story in Google Docs that contains dialog. I just realized that all the quotation marks that I entered using my laptop are "smart quotes" (curly). And all the quotations ...
kmote's user avatar
  • 223
0 votes
1 answer
18 views

Highlighting a row that meets multiple requirements in other columns

Just came across this forum while trying really hard to solve a problem. What I need to do is highlight specific rows in this sheet. The ones I want to be highlighted are the ones that fit multiple ...
Alex's user avatar
  • 1
0 votes
1 answer
184 views

Google Sheets formula to format substrings of column concatenation?

If I have a spreadsheet with columns for author, year, title, publication, etc, could I add a column that concatenates and formats those as a citation for a bibliography? It would be something like ...
2540625's user avatar
  • 305
-1 votes
1 answer
417 views

How do I keep exact text formatting when using a data validation dropdown list in Google Sheets?

I have a column that contains a bold number and a non-bold text part. I want to use this information as a drop-down selection list, but it currently isn't letting me keep the bold formatting on only ...
Kiwipai's user avatar
1 vote
1 answer
1k views

How to copy plain text HTML/formatting method into Google Docs

I currently have a script that generates an amount of text. I want this script to be able to output some text with a formatting style into STDIN (preferably MD/HTML) and I can then paste it into ...
WarriorX's user avatar
1 vote
2 answers
140 views

Conditional Formatting in Sequential Order in Sheets

I hope this all comes out clearly, I am in need of some help to save some major time. This is for sports betting tracking systems. I am trying to create a conditional format to where when I enter a ...
user avatar
0 votes
1 answer
1k views

Google Sheets: Re-enable default horizontal alignment -- numbers to right, text to left

Default horizontal alignment (in excel/Google Sheets) is great. Numbers go to right, text goes to left (even if it looks like number with accidental spaces in it). It is easy to spot visually the ...
Attila Mester's user avatar
0 votes
1 answer
916 views

When I input a number value in cell, can it auto format to show all numbers I input after decimal point

So 132.468 & -186.0152 & 167.03... I don't want to have click format button every time to adjust it to see the whole number.
XCATHADOR's user avatar
0 votes
1 answer
189 views

How to ask sub questions in google docs

I have already searched the internet for this but I'm getting solutions for only google forms and not google docs. I'm trying to create a simple MCQ paper that looks like this... Question one a. opt-...
Rithish K R's user avatar
1 vote
1 answer
5k 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, ...
Shoq's user avatar
  • 11
4 votes
1 answer
213 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 ...
John Hadish's user avatar
1 vote
1 answer
3k 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 ...
JoeMjr2's user avatar
  • 509
1 vote
1 answer
344 views

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 ...
user-j's user avatar
  • 111
0 votes
1 answer
565 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 # ???...
Anthony's user avatar
1 vote
0 answers
165 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 ...
Domi's user avatar
  • 111
1 vote
2 answers
2k 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 ...
Gennaro Arguzzi's user avatar
1 vote
1 answer
1k views

A faster way to access strikethrough than Alt+Shift+5

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 ...
Jason C's user avatar
  • 367
-1 votes
1 answer
486 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 ...
Simon's user avatar
  • 1
0 votes
1 answer
725 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.
Gennaro Arguzzi's user avatar
1 vote
0 answers
86 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?
JoeMjr2's user avatar
  • 509
1 vote
0 answers
111 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. ...
Ooker's user avatar
  • 864
13 votes
2 answers
18k 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 ...
xfbs's user avatar
  • 131
1 vote
1 answer
96 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 ...
duff18's user avatar
  • 113
1 vote
1 answer
1k views

A Google Sheets format that returns time durations in days, hours, and minutes

I have a formula in a cell that returns the duration of a certain task in days. I'd like to express it in terms of days, hours, and minutes. (For instance, 3.25 might be written like 3 6:00.) I ...
Matthew Daly's user avatar
1 vote
0 answers
14 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 ...
CADperson's user avatar
3 votes
1 answer
6k views

How do I make double-line horizontal table borders in Google Docs?

I want to get a double-lined horizontal border for my table in Docs, like Word has. How do I do it?
Raymo111's user avatar
  • 321
0 votes
2 answers
6k views

Why can't these strings be formatted as numbers in Google Sheets?

In this sheet, the numbers are actually text. I tried Format->Number then Number, Percent and Scientific, and they still appear as text. As experiments: I cannot add 1 to these, and I cannot pass ...
Joshua Fox's user avatar
-1 votes
1 answer
522 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 ...
averageUsername123's user avatar
0 votes
1 answer
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 ...
frandude's user avatar
1 vote
2 answers
6k views

Does GitHub have an escape character for their markup?

Background I realize that markup is implementation without a specification but it basically is just a tiny little node stemming from SGML and the like. On GitHub I always use the ` symbol with a ...
Chris Maggiulli's user avatar
3 votes
1 answer
1k views

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 ...
Joel Pearson's user avatar
1 vote
1 answer
3k views

Finding merged cells in Google Sheets

I'm often trying to freeze columns in a Google Sheets and I get the error as below The way I get around this is to manually hunt for the merged cells and unfreeze them, but this can be difficult on ...
sam's user avatar
  • 6,949
6 votes
5 answers
40k 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 ...
Pikamander2's user avatar
6 votes
4 answers
5k 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 ...
Declan Geoffrion Scannell's user avatar
0 votes
1 answer
397 views

Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS

When I copy numbers using either "Edit/Copy" or "Crtl+C" in Google Sheets on PC and then use "Edit/Paste/Special/Paste Values" or (Crtl+shift+V), the numbers are indeed pasted. They appear normal and ...
Benjamin Wade's user avatar
3 votes
1 answer
2k views

How to format clipboard text as data row in Google Sheets?

I've noticed copying text with a link preserves the link when pasted in Google Sheets. I've also tried copying an inline list from an HTML page and noticed it gets copied as two rows. Is it possible ...
George Profenza's user avatar
10 votes
3 answers
14k views

Force Google Docs/Sheets to ALWAYS paste values only (merge formatting)

I do a LOT of copying from external sources and pasting into Google Docs/Sheets. Is this at all possible? I know the keyboard shortcut but can't seem to get used to it. Would save me so much time!
actuallyMarc's user avatar
1 vote
1 answer
5k views

Adding date picker to Google Sheets cells while data validation is customized

I have a column with customized data validation (custom formula) that accepts only dates, provided that a few other conditions are met. How can I add a date picker to the cells of this column? ...
Aria's user avatar
  • 123
2 votes
1 answer
8k views

Partial cell formatting with CONCATENATE in Google Sheets

Is there a way to format partially using CONCATENATE in Google Sheets? For example, =CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the * bolded or blue in color or something else. I ...
user650654's user avatar

1
2 3 4 5