Questions tagged [formatting]
Styling information beyond the minimum of semantic elements: colours, styles (boldface, italic), sizes and special features.
199
questions
0
votes
1
answer
139
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 ...
2
votes
1
answer
58
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 ...
- 23
1
vote
1
answer
118
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 ...
- 13
0
votes
1
answer
481
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 ...
- 295
1
vote
2
answers
42
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 ...
- 295
0
votes
0
answers
20
views
Date time format problem
I have uploaded a CSV file to google sheets.I have a column with a start date and time and a second column with an end date and time. I have used a formula(=C2-B2) to work out the time difference ...
1
vote
1
answer
84
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 ...
- 295
4
votes
2
answers
3k
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 ...
- 193
0
votes
1
answer
16
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 ...
- 1
0
votes
1
answer
102
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 ...
- 275
-1
votes
1
answer
210
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 ...
- 1
1
vote
1
answer
650
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 ...
- 11
1
vote
2
answers
102
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 ...
Obi1
0
votes
1
answer
891
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 ...
0
votes
1
answer
252
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.
- 99
0
votes
1
answer
82
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-...
1
vote
1
answer
3k
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, ...
- 11
4
votes
1
answer
119
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 ...
- 41
1
vote
0
answers
1k
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 ...
- 509
1
vote
1
answer
269
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 ...
- 111
0
votes
1
answer
421
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 # ???...
- 3
1
vote
0
answers
111
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 ...
- 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 ...
- 200
1
vote
1
answer
639
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 ...
- 327
-1
votes
1
answer
323
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 ...
- 1
0
votes
1
answer
444
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.
- 200
1
vote
0
answers
64
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?
- 509
1
vote
0
answers
106
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. ...
- 824
12
votes
2
answers
15k
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 ...
- 121
1
vote
1
answer
69
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 ...
- 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 ...
- 113
1
vote
0
answers
13
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 ...
- 11
3
votes
1
answer
4k
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?
- 321
0
votes
2
answers
5k
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 ...
- 173
-1
votes
1
answer
229
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
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 ...
- 3
1
vote
2
answers
4k
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 ...
- 113
3
votes
1
answer
841
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 ...
- 31
1
vote
1
answer
2k
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 ...
- 6,785
6
votes
5
answers
30k
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 ...
- 343
6
votes
4
answers
4k
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
1
answer
336
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 ...
- 101
3
votes
1
answer
1k
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 ...
- 231
8
votes
3
answers
12k
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!
- 83
1
vote
1
answer
4k
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? ...
- 123
2
votes
1
answer
6k
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 ...
- 121
1
vote
1
answer
4k
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 ...
- 11
1
vote
1
answer
5k
views
How to add an outline border to a table in Google Docs?
I am trying to add only a border outline to a table in Google Docs however when trying to make all lines except the border lines another colour, this happens:
As you can see, white spots where the ...
- 113
6
votes
1
answer
6k
views
Why does Google Docs make some H1 headings bold in the Table of Contents and some not bold?
In my Google docs document I have added a Table of Contents. It's the kind with page numbers. In the Table of Contents, some of the Heading 1 (top-level) headings are bold, and some are not bold. Why? ...
- 251
1
vote
1
answer
129
views
How to prevent sub-lists numbering restart under each bullet?
Google doc's numbered list functionality restarts sub-list "numbering" or "sequential lettering" like this:
1) First thing
a)
b)
2) Second thing
a) <- Sub-list numbering / sequential ...
- 13