0
votes
1answer
61 views

Why is data suddenly being pasted in Excel as a single cell when copying from Google Docs?

I have been using Google Docs for some time now and have been able to copy certain sections of columns of the spreadsheet and paste it into an Excel sheet and up until now it has transferred exactly ...
1
vote
1answer
30 views

Problems with Excel spreadsheet pasted into Google Spreadsheets

I exported an Excel spreadsheet into a Google Spreadsheet. The cells aren't showing. How can I get them to show, and how can I create new cells, columns, and rows?
3
votes
0answers
91 views

In Google Spreadsheet, how to left align currency symbol but right align number?

How to left align dollar sign and right align the number, like Excel currency format? For example: $ 3,546 $ 44,345 Also, is there a way to create a custom format?
0
votes
0answers
81 views

Can any Excel spreadsheet function enact a certain $ transfer between $ accounts?

I can't yet find an Excel spreadsheet function to enact a certain transfer of money (between e.g. two Paypal or bank accounts) ; does anyone know of one? (Usage example: Of course, this function ...
2
votes
0answers
180 views

Microsoft Excel 2010 is password protected but opens in Google Spreadsheet showing all locked and hidden formulas

This is a huge problem. When we email a password protected Excel file with hidden and locked cells to protect formulas, they open on a Droid showing and allowing manipulation of all protected ...
0
votes
1answer
327 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 ...
0
votes
2answers
888 views

embed google / microsoft excel spreadsheet

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsof Excel Webapp and Google spreadsheets but none of them allow ...
0
votes
0answers
263 views

Converting and Excel to Google Spreadsheet

I am trying to convert an Excel Spreadsheet to a Google Spreadsheet, but after it is converted, the document is smaller in size. How can it get it to be the exact size that I uploaded?
1
vote
0answers
416 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 ...
5
votes
4answers
928 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 ...
6
votes
2answers
14k 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. ...
1
vote
1answer
2k views

Copying email addresses from Excel to Gmail into the BCC line

I used to be able to copy a column of email addresses (with a comma at the end of each) from Excel into the BCC line of a Gmail message. Now when I try to copy the column of emails, only the first ...
1
vote
1answer
3k 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. ...
3
votes
3answers
5k views

Are Excel formulas and Google Spreadsheet formulas the same?

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
2
votes
3answers
924 views

How exactly does sharing work in Google Docs?

I have an Excel spreadsheet I made to track my own scores for an XBox game I play (TrialsHD, if you are curious). I've made it available to other players so they can track their own scores, but it ...
0
votes
1answer
1k 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 ...
2
votes
1answer
631 views

Graphs with Google Spreadsheets - collapse data into one 'category'

I have a set of data which is similar to the following: Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00 I'd like to be able to use this data to ...
26
votes
8answers
11k 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?