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)

3
votes
1answer
209 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 ...
0
votes
1answer
840 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 ...
1
vote
0answers
789 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 ...
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 ...
11
votes
4answers
11k 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 ...
6
votes
2answers
18k 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. ...
4
votes
3answers
3k 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 ...
1
vote
3answers
684 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 ...
4
votes
2answers
4k 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 ...
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 ...
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. ...
0
votes
1answer
2k views

Embedding an excel like spreadsheet with formula calculations?

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 ...
4
votes
5answers
340 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 ...
27
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?