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

learn more… | top users | synonyms

0
votes
1answer
2k views

Change all values of a column at once in Google Docs

How can I change all values of column A (currently empty) to be 5? In Excel, I could do Paste Special > Multiply. Is it possible in Google Docs?
6
votes
2answers
1k views

Which versions of the PDF standard does Google Docs support?

What the title says. I know PDFs exported from Google Docs are version 1.4, but which versions does it support when viewing PDFs? I'm asking because I'm having problems with PDFs generated with the ...
7
votes
2answers
2k views

Import Google Docs document revision history into a Git repository?

I'd like to view the revision history of a Google Docs document using more flexible tools like Git, and possibly migrate some content from Google Docs into a Git project. Google Docs has an API with ...
5
votes
3answers
18k views

How to Fill a Column with Sequential Dates in Google Sheets

In Excel you can right-click drag a date downwards to fill a column with the next dates in the sequence. For example if you enter 9/1/2014, select that cell, then right-click drag down over the cells ...
4
votes
7answers
37k views

How to print a Google form?

I made a neat questionnaire Form in Google Docs. I want to print it for hand outs to my testers IRL. But I cannot find a way to print it to paper, or even export it to PDF. There are not many buttons ...
2
votes
1answer
648 views

Is there a way to tell google docs to ignore uploaded files that have already been uploaded?

If I upload a file that already exists up on google docs (because I didn't realize I already uploaded it, or because I'm doing a bulk upload), I get a second copy of the file. Is there any way to get ...
2
votes
1answer
206 views

How does one keep a folder expanded in Google Docs?

I have a folder in Google docs with many subfolders. I want this parent folder to be expanded by default every time I log in to Google docs because I depend a lot on the subfolders. How do I enable ...
2
votes
1answer
65 views

How does one create a Google doc directly in a folder?

I clicked on a Google doc folder and created a new Google doc. However, the Google doc is not automatically placed in the folder. How do I create a document and have it automatically belong to a ...
3
votes
4answers
5k 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 ...
3
votes
1answer
6k 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 ...
23
votes
5answers
58k 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
461 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
938 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
3k 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
581 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
3k 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
3answers
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
903 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 ...
5
votes
1answer
8k 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
11k 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
1k 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
454 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
91 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 ...
4
votes
2answers
5k 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
8k 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
1k 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
587 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
211 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
7k 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 ...
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, ...
10
votes
2answers
3k 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 ...
8
votes
2answers
19k 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
80 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
162 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
3k 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
384 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 ...
18
votes
8answers
27k views

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
2k 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?
7
votes
4answers
17k 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
615 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
266 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 ...
15
votes
2answers
40k 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
781 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 ...