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

learn more… | top users | synonyms (1)

0
votes
0answers
9 views

How to use dot as splitter in currency format with Russian locale [migrated]

I want to write currency in the format: ₽ 3 812.23 But if I select Russia as region in the table settings and format the string ₽ 0.00 result formatted number like ₽ 3 812,23 with a comma, ...
0
votes
0answers
28 views

Is there a way to force chrome to open google docs in a docs chrome app window instead of a new tab

I want the documents from the google drive chrome app to open a new google docs chrome app window when I try to open them. Is this possible?
0
votes
1answer
11 views

Google Slides Translations

I'm using Google Slides on my tablet, and I don't know how to add transitions and animations to slides. Is there any solution or app doesn't have option for that.
1
vote
1answer
57 views

Where are offline-editable Google Docs stored?

When you choose to save a Google Docs file for editing offline it creates a file in your Google Drive folder. However, that file is just a URL to the online Drive. Do you know where actual file is ...
0
votes
0answers
29 views

Folder view in Google Drive cripples GIF animations?

I have a public/shared folder with lots of documents (Docs type) using GIF animated images. https://drive.google.com/folderview?id=0B1C7VchoNCmseUo5RnpMa1hIbFk#list From folder view documents are ...
0
votes
0answers
25 views

Google Docs Spreadsheet text orientation

How do we do text orientation in Google Docs Spreadsheet? I've looked in the toolbar and I cannot see it. Is there an option to rotate text? Thank you.
0
votes
0answers
43 views

Opening Google docs document in FireFox causes an error

Every time I open a Google document from Google Drive via Windows 10 File Manager (Google docs or spreadsheet) I get the following (even after reloading): Opening the document in Chrome works but I ...
0
votes
0answers
11 views

Google Docs place footnote on other site

At Google Docs I want to insert a footnote on page one, but it should appear at the bottom of page two. But when I set the cursor behind the word and go to Insert -> Footnote it always inserts the ...
1
vote
1answer
104 views

How does one share OneDrive (Office 365) documents without requiring authentication?

You might have seen online that when people share a Google Docs document, they can just post a link and anyone can open it, right? Well, it turns out that when you do this with Office 365, making a ...
1
vote
0answers
27 views

followup on mass converting google docs

This question from apr '14 gives a way to download google docs as word, pdf or other files: Migrate Google docs to Office 365, convert from .gdoc to .docx select the files, click "more", then ...
0
votes
0answers
13 views

Depending Data Validation

I want to create a table with select boxes(dropdowns) where the content of the second select is dependend on the first select Producer | Product | ... I would like to avoid heavy if/else clauses ...
0
votes
0answers
26 views

auto filter from sheet1 to sheet 2/3

ok so i have a sheet set as a auto sheet from a google form all the data is entered onto the master sheet, what id like to do is have sheet2 search column P on sheet1 and if it equals name1 move the ...
0
votes
2answers
49 views

Alternating text in word documents

I often want to alter my CV for different purposes, like only mention my German skills when it is relevant. Is there a way I can have such alternate versions in one Word Document? OR Alternatively ...
-1
votes
1answer
25 views

Multi-document view for Google Docs [closed]

I started to use Google Docs for my notes, because I was not satisfied with Onenote and Evernote. This works great so far, their apps and browser support is wonderful. However, the only thing that's ...
0
votes
1answer
18 views

Multiple row calculation with one fixed value

I have a calculation like this =B8+((B2-1)*C8) I want to multiple these calculation by just dragging it down. So I don't need to type the calculation for each row. The values B8 and C8 shall ...
0
votes
1answer
114 views

Microsoft Excel: Merge two sheets and dedup

I have a pretty simple question and google can't seem to return what I'm looking for. Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
1
vote
3answers
289 views

How do I create a desktop shortcut to create a new Google Doc?

It is tiresome to open Google Drive in a browser and from there clicking "New document ...". So how do I find and store the URL for creating a new document so that I can put a shortcut on my desktop?
1
vote
2answers
278 views

Can I access Google docs on an offline public PC?

I want to make the switch to using Google docs so that I can stick to one family of editable file formats that can be opened on (almost) any device. However, I work in an environment where I have to ...
0
votes
1answer
205 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. ...
2
votes
4answers
3k 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
5k 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
199 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
51 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
160 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
1answer
45 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
150 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
1k 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
10k 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 ...
3
votes
0answers
153 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
229 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 ...
1
vote
2answers
4k views

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

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 ...
1
vote
0answers
34 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 ...
1
vote
1answer
6k views

How to calculate percentage in Google Docs [closed]

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
187 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
103 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 ...
11
votes
2answers
7k 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 ...
4
votes
3answers
18k 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
2k 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
286 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
4k 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
850 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
1k 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 ...
2
votes
4answers
8k 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...
5
votes
2answers
713 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
25k 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
902 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
1k 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 ...