Is it possible to reference a cell in Google Spreadsheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference dell's value. ...
I'm in the process of changing to Google Drive from MS Office for all aspects of my work. Pretty much everything I need is there, but the one thing we can't work out how to do is how to get a header ...
As the title says, I would like to protect the formatting of a cell (or a range of cells) in a google spreadsheet, but still allow changing the data in that (or those) cell(s). For example, I want to ...
In Excel you can change the format (e.g bold or change the color) of a single word or part of a text field within a single cell. Can this be done in Google Spreadsheets?
I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
In Google Spreadsheets, how can I highlight selected text in a cell and not the whole cell? [duplicate]
In my Google Spreadsheet, I have a lot of text in a cell and want to highlight a small portion of this text with a particular colour. But, whenever I try to do this, the formatting gets applied to ...
I have this credit card number in a Google Docs spreadsheet 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 ...