Better asked at WebApps.StackExchange.com unless specifically involving your computer setup.

learn more… | top users | synonyms (1)

0
votes
0answers
17 views

Attach Google Docs to a gmail message [migrated]

I can only link and not attach Google Docs. So, if the recipient does not have Google Drive, I have to download a converted document and upload it again. This is very time consuming and inefficient. ...
1
vote
0answers
16 views

Google Docs - Default layout when I create a new document [migrated]

I use Google Drive for work and work only. I have a very particular protocol for pages I print. This is along the lines of: Change the document to Verdana font face. Put placeholder text on the ...
0
votes
0answers
9 views

Creating a contact sheet in Google slides

I have a google slides presentation that I want to insert a contact sheet (a grid of thumbnails) into. I thought about inserting a table and adding the images manually but as I have over 300 to insert ...
0
votes
0answers
10 views

equivalent of Crtl+Apostrophe in google docs [migrated]

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...
0
votes
0answers
8 views

Calling IMPORTRANGE inside of REGEXMATCH function? [migrated]

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function. I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...
1
vote
0answers
16 views

How to bring the Google Doc chat settings icon back? [migrated]

I'm working in a chat window of a Google Docs document someone shared with me. There is however something strange going on with the chat window in that document. It is full height and cannot be ...
0
votes
1answer
19 views

Combine GoogleSheets functions

I'm trying to combine multiple functions into one formula in GoogleSheets spreadsheet. I've tried learning more from Google's Help center and through YouTube but didn't came to satisfactory result. ...
0
votes
0answers
19 views

Google Doc saved as .webarchive

Unfortunately a client has saved a Google Document (Word) by using the Save feature in Safari, resulting in a .webarchive. This was also the only copy. I cannot seem to extract the text contents of ...
2
votes
4answers
194 views

Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this: % of ...
1
vote
1answer
389 views

How do I copy rows based on single cell value in Google Sheets?

I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example Name Number Outcome Colin Smith ...
-4
votes
1answer
36 views

Open a .docx file with Office Online

With Google Drive they have complimentary products like Google Docs that opens the web editor when you double click it on your desktop. Is there a way to set that up with .docx files and Office ...
0
votes
0answers
40 views

Sync with Google Drive and Docs

I have a few friends who run a number of Google accounts and uses Google Drive (v3.2.2) and Google Docs (v1.1.3.5459) for iOS (8.1) with iPads. One of the friends has created a directory under Google ...
0
votes
2answers
53 views

How to assign rows in multiples of a number (Excel/Google Docs)

For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15. How would I go about doing this?
0
votes
0answers
130 views

Redirect a Google Drive folder link

I have shared a Google Drive folder with a link. Now, I find the user experience is not very good, so I would like to use a document or Google Site instead. Can I somehow "redirect" the existing ...
0
votes
0answers
28 views

Google Docs prints blue band at the bottom of the page

Whenever I print something from google docs, the resulting page has an awful blue band that covers the whole page horizontally and about 2 inches from the bottom of the printing margin. For example, ...
0
votes
0answers
38 views

Exporting Google Doc to a code format like LaTeX or Markdown

I would like to export a Google Docs document to a plain-text code format like LaTeX or Markdown (or something else that could be then exported to such format). How should I go about that? I see ...
0
votes
1answer
34 views

Tab corruption in multiple text file formats

In Google Docs, Wordpad, and Writer (for open office), tabs are being "forgotten" or haphazardly "inserted" where other tabs are. I don't think this issue is local to a particular program or file ...
-1
votes
1answer
72 views

Google Docs file association [duplicate]

Can you set a file association in Internet Explorer to open .doc files in Google docs? I use a SaaS application with integrated email that only runs on IE and I would like to open file attachments ...
0
votes
3answers
714 views

Not able to connect to Google docs, error message: The remote device or resource won't accept the connection

I have started facing a strange issue on my home network. I am not able to connect to docs.google.com, it gives the following on firefox: And in chrome: When I troubleshoot the link it gives ...
3
votes
4answers
3k views

Why is Google Docs slow on OSX / Chrome?

I recently noticed Google Docs is very slow on my MacBook (mid 2011 with OS 10.8.5) when using it in Chrome (latest version 35.0.1916.153). Safari seems to be doing OK. Tested it on another MacBook of ...
0
votes
1answer
113 views

Block Google Docs from retrieving file on website - Stop Google DDOS [closed]

I was reading a very interesting article on how someone used Google Docs to preform a DDOS attack on a website. They basically filled a Google Docs Sheet with =image() requests to download a certain ...
2
votes
0answers
36 views

How to add fold-marks to a Google Docs document?

This question is about how to get fold-marks (very similar to this question) to your document in Google Docs. It would be very helpful. If it is not feasible per se are there any workarounds?
0
votes
1answer
37 views

Copy Address of Cell

Is there some way in Excel or Google Docs to copy the address of a cell? I need to copy the address of a cell from another worksheet into a formula on the current worksheet. To do this, I have to ...
0
votes
0answers
57 views

Change the display size of Google presentation on Google sites?

I know how to change the size of Google presentation inside the Google presentation editing page, i.e. by editing its Page setup. But how to change its size (display size) on Google sites? When I try ...
1
vote
1answer
1k views

Migrate Google docs to Office 365, convert from .gdoc to .docx

Our company is switching from Google apps to Office 365. As I am one of the only using .gdocs documents I am tasked to convert them to .docx before we migrate by hand, or else I cannot open them ...
0
votes
0answers
75 views

in gmail i enabled “lab” for search in docs and sites however i get back results only from docs

I search for text my plugin is enabled, i do see results from docs but no results from google sites. I do see this at bottom "Show only Docs and Sites results ›" can anyone help? is it working at ...
1
vote
0answers
17 views

Going to print multiple cards in fixed size

I need to print out about 80 "cards" for an invitation and to fit the envelope I need to print them in a very exact size. Each "card" has to be 5cm in width and 7.5cm in height. Instead of just ...
1
vote
2answers
31 views

How focus on the document after find?

I'm filling a column after finding a row via a search on the name column. So I do CTRL + F, type the name, and click the the cell with mouse to fill it. Is there a way to do this without using the ...
0
votes
1answer
4k views

How to calculate percentage in Google Docs

I have this google-doc: https://docs.google.com/spreadsheet/ccc?key=0Avl3X68NxHC-dFY2YWgzTnRVZm1xaWlBTFl6TU9NTkE&usp=sharing Now I am trying to calculate the average (=average()) of the ...
0
votes
1answer
60 views

How can I auto-share anything sent to one Drive account with another?

People sometimes share Docs with my rarely used Google account. So I have to email them and ask them to use my main Google account instead. It's a hassle for them and for me, plus it slows down our ...
0
votes
1answer
89 views

Are spreadsheet programs inherently unsuitable for “one row=one case” data?

Often when I'm working with large data sets, I structure the data in a way where every row equals one specific case. For example, in a psychological experiment, I input the data so that all data ...
8
votes
2answers
3k views

How do I get Google Drive to open text files with arbitrary extensions as text files?

I have text files on Google Drive that do not end with the .txt suffix (such as: .r, .bas, .awk...). I want to view them using the Drive Notepad app, but it does not recognize the files as text. Is ...
3
votes
3answers
8k views

Opening .pdf's on Google Drive using Adobe Acrobat

Note: this is a question about Google Drive, not Firefox options. I've been using Google Drive and Docs a lot, so I tend to keep .PDFs on Drive as well just for convenient storage. But I don't like ...
0
votes
1answer
880 views

Why 'google docs' document cannot be opened using firefox?

I uploaded a document on google docs. The document has been shared in the public domain. I can see the document from chrome,opera but not through firefox . Is it that, google docs files cannot be ...
0
votes
1answer
157 views

Best way for bidirectional referenced table rows for double-entry booking

I want to move to a Google Spreadsheets setup to handle my private booking. Currently I have four tables: Overview Accounts Income Outcome Except of "Overview" all share following columns: Date ...
0
votes
1answer
2k views

Auto-Open PPT, DOCX, Etc in chrome?

I like how in chrome you can open .PDF files with the built in PDF reader (I believe it uses the adobe reader framework). Is there a way to have chrome open MS office files in google drive by ...
0
votes
1answer
598 views

Copy distinct values in excel from one range to another

Suppose I have a table like this: A B food 12 cars 30 cars 40 food 10 food 14 living 100 fun 30 food 40 I'd like to copy all distinct values from column A to some other ...
-1
votes
0answers
872 views

Google Spreadsheets Error: All series on a given axis must be of the same data type [closed]

I am trying to use embed interactive column charts from Google Spreadsheets for a website. However, when I enter the HTML code into the website I get the following error: "All series on a given axis ...
1
vote
4answers
3k views

How to Unhide column A in Excel and Google Doc?

Let's say I hide column A in excel or in google doc, how can I unhide it (show column A again). Column A is the most left column. I have column B,C and D etc...
4
votes
1answer
363 views

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking ...
1
vote
2answers
7k views

How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1 Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value. I don't want the C-column. ...
1
vote
2answers
314 views

Do Google Drive and Ubuntu One have the same concept?

Do Google Drive and Ubuntu One have the same concept? I just have an Ubuntu cloud account and Google Docs.
0
votes
0answers
86 views

Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar: Jan Fev Mar ... 1 5 7 1 2 3 4 9 3 8 3 1 4 2 9 0 5 2 1 2 ... And so on... I need to make a chart ...
0
votes
1answer
567 views

Google spreadsheets drop down not compatible with MS Excel

I've created a drop down list on a google docs spreadsheet but when I download the spreadsheet and open it up under excel, the drop down functionality is lost and only the first item is shown. I have ...
3
votes
1answer
467 views

Google Docs Document Private Comment

I have access to a collaborative Google Docs document on which I would like to make notes in preparation for a meeting (I am not the document owner). I would like to avoid wasting paper, so I would ...
-1
votes
2answers
651 views

Google Drive and sync?

Two questions please: Where are Google Drive offline docs stored in my computer? which folder ? (*when accessing docs.google.com/offline) I have a text file in my Google Drive. When I click on it, ...
1
vote
2answers
234 views

Print > Save as PDF - Saved to Google Docs, not local drive

Recently I gave the Print > Save to Google Drive option in Chome, and it works well. All my web-pages I use goes to my Google Drive account as PDF files. My problem is, whenever I use the Save as PDF ...
4
votes
1answer
3k views

Can I link to another page in Google Docs? [closed]

I'm creating a large document (text, not presentation) in Google Docs, and I want to be able to link to other pages in the same document (like a pdf or # in the url). So far all I've found is how to ...
1
vote
0answers
57 views

Shared online document editing that automatically identifies who wrote what

I'm just wondering if there's a shared online document editing tool out there that identifies who wrote what. You'd think Google Docs would be the perfect tool but annoyingly, there's no automatic ...
0
votes
1answer
690 views

Reference whole sheet in another sheet - reference dynamically NOT copy + paste

I have multiple sheets relating to each room in a house, I also have a master sheet showing the overview of the whole house, what id like to do is pull all the data from the room sheets into the ...