For questions specifically about the web interface of the file synchronization and cloud storage service from Google.

learn more… | top users | synonyms (1)

1
vote
3answers
4k views

Is there a way to generate number of days in a month in Google Docs Spreadsheet?

The title kind of says it all but just to give you the use case, I have a spreadsheet where I track monthly ad revenue and want to end up with a daily revenue column. Here's a simplified example of ...
2
votes
1answer
5k views

Change the background color of selected text in Google Docs to increase readability

How can I override or change the background color of text selected in Google Docs? It is difficult for me to see the difference and I would like to increase the contrast or difference. After Google ...
21
votes
4answers
51k views

How to hide page number on first page?

I have setup a document with page numbers within the footnote. Now I want to hide the number for the first page as it is the document's cover sheet.
0
votes
1answer
416 views

How to make sharing in Google Docs actually work?

We're using a Google Apps domain where I work, and I have a strong suspection that it's not possible to share anything with other people unless I send them a link. What I do: I create a document I ...
2
votes
1answer
698 views

How to put the name of a cell into another cell in Google Spreadsheet

In Google Docs Spreadsheet, is there a simpler way to put the name of a cell reference into another cell than this? =concatenate(char(code("A")+COLUMN(D3)-1),row(D3))
1
vote
2answers
2k views

Why is there an extra new line at the end of my Google Docs table of contents?

I am trying to get rid of the extra new line at the end of my table of contents of my Google Doc. https://docs.google.com/document/d/1CW9UV5EbbH1JlW_mxZryCiLZ-NCf8vaqh5BE2Xyl1FU/edit When I delete ...
3
votes
1answer
573 views

How do I use Google Web Fonts for Google Documents?

A number of 2010 blog posts from Google seems to imply this is possible, but I can't seem to move fonts from Web Fonts to Google Documents. Is it even doable?
1
vote
1answer
2k views

How to query for count of dates in Google Docs?

I have a Google Spreadsheet of line items. One of the columns is a Date field. How can I query (or use a formula) to, for example, get the count of records where the Date field is within February of ...
4
votes
2answers
23k views

How to create custom Google Docs Form with a custom theme?

Google Docs Form offer a bunch of themes but I need to create custom one. I need my banner at the top of form- questionnaire. How can I do that?
3
votes
1answer
809 views

Google Apps Scripts API for Google Docs Table

If we take a look at Google Apps Script we can see API related to just about everything except Google Docs Fusion Tables that are supposed to be some sort of lightweight database tables. Can anybody ...
4
votes
1answer
4k views

Is it possible to see the owner of a public Google Doc?

If I create a public Google Doc that anyone can edit who has the URL, will my google id or name or anything else be publicly viewable? I tried it and I didn't see anything about the owner in another ...
9
votes
4answers
9k views

Replacing a file in Google Docs

Is there any way to replace the uploaded (unconverted) PDF file? For example, I have a PDF file and I realized that there were some typos in it, so I wish to upload the revised file in place of the ...
1
vote
1answer
939 views

How do I customize font styles in Google Docs?

Google Docs provides several styles such as header 1, header 2, normal text, etc. How do I customize these styles? I don't like the default color of light grey for header 4. I want it to be black.
3
votes
1answer
449 views

Storing photos and videos privately with Google

I am interested in purchasing extra Google storage to use in storing mainly photos and videos. Is it possible to keep everything I store private with Picasa or Google Docs?
4
votes
1answer
82 views

Request for somebody to comment on a section of a Google Docs document?

How can I request for one of the people with access to a Google Docs document to comment on a specific section of it? Can a section be tagged as "request for comments" towards a specific user of that ...
3
votes
2answers
669 views

Forcing Google Docs to display the desktop version

I have to change my user agent to "iPhone" so that I can get connected to the internet through my smartphone. The problem is that I can get the desktop versions of many sites even the Google Docs ...
2
votes
1answer
6k views

Filter rows in Google spreadsheets

I have a Google spreadsheet. There is a colour column. Every row has a colour, Red, Yellow, Green etc. I want to be able to filter out say all rows that are Red, all rows that are yellow, all rows ...
5
votes
2answers
869 views

Format credit card numbers as four digit blocks in Google Spreadsheets

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

Change default view (home) in Google Docs?

I hate Google Docs Home view. It contains a lot of documents that were shared with me and are marginally relevant to me. I want to choose what shows when I open Docs. In essence, I want "starred" ...
3
votes
1answer
207 views

Why in Google products like Docs or Talk, my username listed instead of the full name?

For example in Google Docs others see me like this: Same in Gmail Chat, my friends see my username in the list, instead of my name. I've checked my account settings, and the profile, all seems to ...
1
vote
2answers
5k views

Is Google Docs free for business use?

Google Apps for business use costs, but as far as I can tell Google Docs is free for business use. In the Google documentation on the topic, it just seems to state that it's free, full stop (I can't ...
1
vote
1answer
314 views

Google Docs page number to be 2 digits

At the moment I cannot format the page number to be 2 digits in Microsoft Word 2010. Now I need it to be also feasible in Google Docs. Please help if you know how to.
0
votes
2answers
2k views

Sum of the values of the 10 cells above me?

I'd like a formula for Google Docs spreadsheets that will return the sum of the values of the 10 cells above the current cell. That is, if I'm on C31, I want the equivalent of =SUM(C20:C30). However, ...
8
votes
2answers
2k views

Finding the changes within a Google Doc's revision

I can use the revision history within a Google Doc to see who made what changes, but I have to search through the entire document to see which sections were touched by each change. Is there any way to ...
0
votes
1answer
1k views

Google docs not sending notification

Does anyone know why I do not get a notification when someone changes the shared document? My Notification settings are set as below (* means it's set): Don't send me any email notifications for ...
1
vote
0answers
70 views

How can I get a Google Document to link to the editing of itself?

Consider this document. On the bottom I manually created the "Edit this document" link. Is it possible to do this automatically, somehow? Maybe with a macro or similar?
7
votes
2answers
17k views

Adding one Google Spreadsheet column to a string to dynamically create a URL in the next column

I have a spreadsheet of product id codes that I'd like to turn into links, and from everything I've read, the concat or concatenate functions in Google Docs should work for that, but so far everything ...
7
votes
2answers
2k views

Is there any way to make Google Docs document view default to compact controls?

Whenever I open a document in Google Docs for editing, I push Shift + Ctrl + F to set the mode to Compact Controls. I find this view simply superior, to the standard view, so I would like to make it ...
2
votes
1answer
66 views

How to share many documents at once in Google Docs

I want to share an entire collection or many docs at once instead of manually adding a user at a time for every document now that my manager switched to a new Google account. Can it be done? If yes, ...
2
votes
2answers
4k views

Hyperlinks in Google spreadsheet docs

In Google spreadsheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com";"search the web") This will show the text search the web which will hyperlink to Google. ...
5
votes
1answer
130 views

Is there a way to create a doc directly inside a collection?

For the life of me, I wasn't able to figure out how to create a doc inside a Collection. When I click the Create button, the document is always created at the root level, and I have to find the ...
7
votes
5answers
2k views

Google Apps for Business Local Backup

Is there a way to backup the entire organisations documents locally? We aren't so much worried about data loss as we are access: what happens if our internet connection goes down? (and it has in the ...
4
votes
1answer
336 views

Normal scrollbars in Google Docs?

I have problems working with the new small (HTML scripted) scrollbars in Google Docs. Is there some way to get normal (operating system provided) scrollbars back? Maybe some jQuery in a Chrome ...
11
votes
7answers
16k views

Google Spreadsheet: How to prevent cut and paste data changing references in formulas?

Google Docs has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
5
votes
4answers
1k views

How to connect a Google Docs document to a Trello list?

Documents are kept on Google Docs but we would like to attach them to a list in Trello for reference or to work on the document. How does this work?
5
votes
4answers
11k views

How can I convert a table in a Google Docs document to a spreadsheet?

I've tried selecting the table in the document, copying it, and pasting into a new spreadsheet, but this results in a one-column spreadsheet with all of the columns flattened into one. I don't see a ...
2
votes
1answer
2k views

Ctrl + F not working for browser page search when using Google Docs

When I do Ctrl+F in Google Docs, it shows the "document find view". What I would like is the "browser find view" when in Google Chrome. What keys do I need to press to do a browser Ctrl+F in Google ...
1
vote
0answers
450 views

Can I precisely position charts in a Google Docs spreadsheet?

I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet I ...
4
votes
1answer
264 views

Are there differences between Google Docs as a standalone vs. when it's included in Google Apps?

I started using Google Docs and I like it a lot for simple documents and spreadsheets I collaborate on. I still use Word/PowerPoint/Excel for the heavy lifting. I'm using Outlook with Exchange Online ...
1
vote
1answer
2k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
1
vote
1answer
2k views

Collecting identifying information about users filling in a Google Docs forms

How can I get Google Docs to register IDs of people taking a survey generated from by the form? I have a database of users and I'd like them to take a survey and also have the form link with their id ...
10
votes
1answer
24k views

How do I change my nickname or display name on Google Docs?

How do I set a different display name to show on in the revision history of a Google Docs document? When I look at the revision history of a shared document that I've edited, all my edits are showing ...
6
votes
1answer
1k views

Can I have an RSS for Google Docs?

Is there a way to get an RSS feed for all documents created in Google Docs which are visible to me? EDIT: I found someone here suggesting that a URL like ...
7
votes
1answer
773 views

Imported from Google Notebook?

Today I login to my Google Docs and saw a mysterious looking file named "Imported from Google Notebook - My Notebook". I have no idea what is Google Notebook or how it got there. The content of the ...
3
votes
1answer
149 views

How to ensure that the owner of a Google Doc does not remove the document?

I often use Google Docs for collaboration with a range of parties. My question is therefore regarding information safety. In the cases where I am not the owner of a document, how can I ensure that the ...
3
votes
1answer
2k views

How do we set refresh-rate of Google Docs published document?

Hi all when I publish a Google Docs text file onto the web, it is set to update automatically every 5 minutes. I would like it to refresh itself more frequently. I was wondering is there anyway to ...
4
votes
0answers
232 views

How to embed pictures from Google Docs in new interface?

Previously it was possible to get rendered bitmap URL from Google doc picture. But now they created a new degraded interface where I can't find such an option. I can only "share" image, but I want to ...
21
votes
4answers
25k views

Adding bibliographic references to a Google Docs document?

How can I add my bibliographic references to a Google Docs document? I've googled around for an answer and found WizCiteWeb from WizFolio, but they say it only works with the older version of Google ...
43
votes
2answers
43k views

Putting page numbers in a table of contents in Google Docs

I want to create a table of contents in a Google Docs document where the page numbers are automatically referenced. Is it possible to put page numbers in a table of contents like this?
2
votes
1answer
151 views

Is it possible to view by type in Google Docs?

I know I used to be able to view my docs by type (document, spreadsheet, presentation, et) but cannot figure out how to do that with the new look. Did google get rid of it?