Questions with this tag should only be about Microsoft Excel and how it interacts with a specific Web application. Questions about Microsoft Excel are otherwise off-topic here.

learn more… | top users | synonyms (1)

-1
votes
0answers
2 views

Google Spreadsheet/Excel formula for calculating shipping expenses of my orders

I have Website form that is entering data in Google Spreadsheet and I need to calculate automatically by Google Spreadsheet formula Shipping Cost for all orders. Data consists of: Name Email Online ...
0
votes
0answers
27 views

Is it possible to link an Excel document to a Google Sheet?

I have an Excel file that needs to be updated weekly, but I also have a clone on Google Sheets that needs to have identical changes done each week as well. I currently am trying to use the =...
3
votes
1answer
391 views

Is it possible to link a Google Form to a desktop Excel sheet so that when someone fills in the form the data goes into the Excel sheet?

I work for a sporting organisation and track all sorts of monitoring variables using Excel spreadsheets. Up until now I have used macros in Excel to do this, but this requires players taking it in ...
4
votes
3answers
4k views

How do you insert an Excel sheet as part of a new mail message?

How do you insert an Excel sheet as part of a new mail message? I tried inserting a MS Excel document directly / via a Microsoft document. But when I copied into a new Gmail message, the formatting ...
11
votes
4answers
12k views

How do I Export Data to Excel

I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts. We are using Google Chrome but have data security concerns, so exporting to Excel is ...
5
votes
2answers
5k views

What is the equivalent key in Google Spreadsheet to Excel's F2 for editing a cell?

In Excel When you want to edit the highlighted cell, and you don't want to move back to the previous cell when pressing the <- key, you press F2. Pressing F2 ensures that when you're editing the ...
2
votes
2answers
4k views

Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
6
votes
2answers
19k views

How to easily select multiple cells in Google Spreadsheets?

How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. ...
6
votes
4answers
2k views

Google Spreadsheets equivalent of Excel CLEAN() formula

I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns. I then have formulas concatenate across those rows and columns and add some HTML ...
0
votes
1answer
913 views

Excel to Google Spreadsheet problem

I emailed an Excel spreadsheet as an attachment to my Gmail account. I then chose open as a Google Spreadsheet. When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
28
votes
8answers
16k views

What limitations does Google Spreadsheets have in relation to Microsoft Excel [closed]

Office licenses are expensive. What features of Microsoft Office are missing from Google Spreadsheets that would be of value in ordinary personal or business use?
1
vote
0answers
840 views

Google Docs capabilities

We've created a commission calculator to help our resellers work out what commissions they will receive on a deal. We built it in Excel 2010 but want to move it to a web based platform that will ...
4
votes
5answers
348 views

Replacement for Excel [closed]

We have a small team of 20 people who use basic spreadsheet functions to share daily reports between us for our clients. We'd like to switch to a web-based product vs using Excel. What do you ...
1
vote
3answers
695 views

formatting excel sheet to organize data properly

I have an excel sheet which has approximately 2000 Rows. The columns are First Name ,Second Name, email 1, email 2 I want to be able to use all these contacts in one go in gmail in following format ...
6
votes
0answers
775 views

How do I get my data out of Trello? [duplicate]

Possible Duplicate: Is it possible to export my data from Trello, to back it up? Is there a way (or is it planned) to export Boards, Lists or specific cards to an external downloadable file of ...
0
votes
1answer
2k views

Embedding an excel like spreadsheet with formula calculations? [closed]

I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say 3 cells with the input of a number), where then a fourth cell will calculate the sum of the square of the three ...