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.

0
votes
0answers
7 views

sSheet DateTime format

I am using AppSheet to create a Timesheet App and on the App, I have to use the DateTime format to be able to calculate overtime and regular hours correctly. My gSheet DateTime format returns a start ...
1
vote
1answer
19 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 ...
0
votes
1answer
13 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
34 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
26 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
2answers
34 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 ...
0
votes
1answer
40 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
2answers
348 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
540 views

How do I have one page in portrait and the rest in landscape in Google Docs?

I am working on a school project and I need one page in portrait and the rest in the landscape. I would rather not have multiple documents though. Any suggestions?
0
votes
1answer
26 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.
1
vote
1answer
227 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"). ...
0
votes
1answer
19 views

Prevent the stretching from changing cells border in Google spreadsheet

Is it possible to prevent the stretching from changing cells border in Google spreadsheet? I mean that if I stretch a cell which has a border above it, then the same border will be added to the cells ...
1
vote
1answer
35 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
117 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 ...
2
votes
1answer
20 views

What's the difference in using the internal formatting and using TEXT to format cells?

What's the difference in using the Formatting drop-down and using =text() to format cells? Which one overrides the other or take priority? It seems I'm having some formatting conflict that is breaking ...
1
vote
1answer
433 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
405 views

How export a spreadsheet as XML?

How can I export a simple spreadsheet, consisting of a single column of data, as XML? Exporting as CSV is leading to other problems, so turning to XML as a workaround.
0
votes
1answer
100 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 ...
1
vote
1answer
17 views

Custom formatting with data returns what the cell shows but not what the cell contains

Basically I have this set up in one of my sheets in which these cells have data validation for "is valid date" so a calendar shows up when you double click them, then it has custom formatting so ...
0
votes
1answer
361 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
0answers
13 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
1answer
36 views

Google Doc - applying headers to single line only - after pasting as plain text

The issue: https://youtu.be/OXS3wTR7YJw Make notes in "Notes" (better for offline) Paste into Google Doc Apply a header Sh!t the whole thing is formatted now Related but not the same: Create ...
0
votes
0answers
624 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
1answer
416 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 ...
0
votes
2answers
35 views

How to format code in Blogger

I am writing one article on Blogger, There I am unable to format code. The code I am writing is looking like simple text. The site name https://www.blogger.com/ I am using <div class="...
0
votes
0answers
30 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 ...
0
votes
0answers
41 views

How to set a single page's properties? [duplicate]

The goal is to selectively configure a single page of a multi-page document to: landscape (hyperlink to similar, yet a subset of this question) and paper size A3. The hope is that the link is ...
0
votes
1answer
415 views

How to change the default font & font size in Google Documents? [duplicate]

I really hate Arial, which happens to be the default for Google Docs. Does anyone know if there is a way to change the default font and font size in Google Docs? Thanks.
4
votes
1answer
343 views

How do you change the default indent and set your own in Google Documents?

I don't like how the default when you open a new Google Doc is no first line indent. Is there a way to customize the default?
0
votes
1answer
141 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
2k views

How to remove insignificant decimal point in Google Spreadsheets?

I'm trying to format a number in Google Spreadsheets. I want it to show the thousands comma, then a period ., followed by mostly 3 digits, only when necessary. For example: 1,234.56789 => 1,234....
1
vote
1answer
1k views

Weird behavior with “Wrap Text” in tables

I'm trying to add an image at the beginning of cell of a table that Wraps text however, for some bizarre reason it seems also block out space in the cell to the right. Where as, I'd expect something ...
2
votes
1answer
23 views

How to format one cell to match formatting of another (even if “other” changes later)?

How can I do the Style equivalent of setting one cell equal to the style of another cell, even if the "other" cell style changes? use Case: I want all Row #2 of each sheet to look like (same style) ...
0
votes
1answer
1k views

Google Docs date in yyyy/mm/dd format (year first)

My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet? BUT unlike those answers, I'm trying to get the ...
1
vote
1answer
20 views

What's the shortcut key for code block?

How to format a selected piece of text as a code block in slack?
1
vote
0answers
106 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 ...
0
votes
0answers
33 views

Protect the Formatting on a public Google Sheets Spreadsheet [duplicate]

I have a shared spreadsheet that users can edit data in. The only problem is, that whenever someone copy and pastes data, the format changes, and I'm always going in to fix it (somewhat of a pain). I ...
1
vote
0answers
209 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 ...
2
votes
2answers
451 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
7
votes
4answers
2k views

How to left align dollar symbol but right align number?

I selected format -> number -> more formats -> custom number format: $#,##0_);[Red]($#,##0) How can prepend spaces between the $ symbol and the digits? Pad with spaces. So that the dollar sign is ...
1
vote
1answer
2k views

How can I format a pivot table with staggered elements to make narrower?

Right now a typical pivot table looks like this: This takes up too much room horizontally. I want to format it so that it is narrower and taller, by moving nested blocks down and left. How can I ...
2
votes
1answer
43 views

Unconditional formatting universally applied in Google Sheets

How do I change the default color for anything which I type into Google Sheets? When it's a URL it seems to go to one color, when not, another. I'm not looking to delve into JavaScript. I just ...
3
votes
1answer
66 views

Make each cell in a column update from the same row of another sheet?

I'm looking for a function I could apply to a column that would make each cell in the column check the value of the first cell in its row and the first cell in its column and then return a value from ...
4
votes
3answers
1k views

Auto-fill date function changes the YEAR and not the day

I'm trying to get Google Sheets to auto-fill dates in the beneath cells after I have manually filled one myself. The strange issue is that when I hold Command key and drag down, the cells auto-...
-1
votes
1answer
24 views

How to change formula output directly?

I have a formula which produces some text, how do I highlight a part of the text to change the part's color?
8
votes
4answers
18k 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 ...
3
votes
1answer
531 views

How to change number stored to a plain text format in Google Sheets?

I have numbers stored in a sheet as (xxx) xxx-xxxx. I want to remove all formatting and make it just xxxxxxxxxx. How can I accomplish this?
1
vote
1answer
151 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
22 views

Different appearance for different GPS pins in CommCare's map reports

I am developing a map report in CommCare's report builder. I would like the different GPS points on the map to have a different appearance depending on a filter. For example, if the client at the GPS ...