Site hosted by Build your free website today!

This is the unofficial Google Spreadsheets usually asked questions website Normal Concerns Do I will need to have a gmail account to use Google Spreadsheets? How can I change off the autosave selection How can I have a lot more than 100 rows ? The format I want is not in the menu. What can I do? How can I create a customized format ? I have opened up a spreadsheet and it is completely black. How does the autofill function perform? How do I hide the gridlines. Can I use names for ranges? How can I make an email tackle live/clickable? Time and date associated concerns. How can I calculate working occasions ? How can I get the local time/date for my timezone? How can I format time without hrs? How can I format time values devoid of the seconds ? How can I include occasions ? How can I show time values which are above 24 hrs ? How to show the day of the week ? Suggestions & tips I want to do XXX. I can do XXX in Excel/Open Office, but not in Gsheets. What can I do? Shorter URL for shared spreadsheets. forex charts Working with intermediate results. Generating graphics with out graphs. Checklist of not (yet?) applied features Request a characteristic Helpful back links Lookup Google Spreadsheets Your Google on-line files The Google Document forum Introduction to spreadsheets (pdf) Tech on the net innovative (excel) products Do I need to have to have a gmail account to use Google Spreadsheets? No, you don't want a account, but you do will need a account. It is extremely effortless to receive one particular. Right here is the url https// If you send out an invitation to share a spreadsheet to an email tackle that is not linked commodity prices with a Google account, the invitee is instantly invited to develop a Google account 1st. Notice A account is not the identical as a account. A account can be produced with any email deal with (like ) A account is constantly immediately a account. How can I change off the autosave choice You can't, since that would demolish the most standard characteristic of the software The capability to reveal info in actual time. But you can obtain to your own computer system as backup ( - Export , select .ods or .xls) make a copy best stocks of your spreadsheet with an additional name like mysheet - in progress ( - Save a duplicate) In case you will need to revert back again to an mature edition you can then - Add new model to restore from your private computer - Rename to consolidate a steady edition - Delete to delete an out of date edition The format I want is not in the menu. What can I do? You can use the TEXT operate to screen formats that are not in the menu. See also Employing intermediate resultsandHow can I produce a customized format cedar finance ? How can I make a customized format ? Custom formats can be produced making use of the TEXT() operate. Numerous undocumented formats are obtainable. Click on right here for a listing of customized format directives I have opened up a spreadsheet and it is entirely black. One of the protection configurations for IE on your desktop is most most likely set to disable binary and script behaviors under ActiveX controls. Environment this to allow should correct this and display your spreadsheet. It may possibly also be necessary to apparent your cache Tools-World wide web Alternatives-Delete short term information How does the autofill characteristic work? If you decide on a column, row or block, Ctrlr will propagate the components(s) in the most left column to all the selected cells to the appropriate, while Ctrld will propagate the top row down. You can also duplicate a person cell/row/column and paste it to a block of cells. How can I have more than 100 rows ? Pick all cells (by clicking the sq. over row 1 and left of column A) Click on the button. Now you have the choice to include 100 rows. Repeat previously mentioned steps and you stock trading software can insert two hundred rows, then 400, etc. How to conceal gridlines In excel, pick out an spot (or all cells) and then decide on FormatCellsBorder. In this dialog box, pick out Coloring White (or what ever is your default cell qualifications color), and then choose the Define and Within buttons below Presets. Then validate Ok. Now you have a entirely white area (or sheet), i.e. because the grid is white and the cells are also white, you have "hidden" the gridlines. Now import this to Gsheets. Can I use names for ranges? Gsheets supports named ranges but does not offer a mechanism to define them. The only way to create them is in Excel or Open Workplace. How? How can I make an email handle reside/clickable? http// and ftp// are recognised by Gsheets and make clickable hyperlinks, nevertheless mailto is not implemented. The workaround is to use the HYPERLINK() perform in combination with a small javascript as follows HYPERLINK("http//","Ship mail to Unofficial Q & A") - or - Email handle in A1 HYPERLINK("http//"& A1, A1) Time and date relevant inquiries. How can I determine doing work instances ? Starttime in A1, stop time in B1 use the components MOD(B1-A1,one) This formula is accurate also for night shifts. (when A1 B1) How can I get the community time/date for my timezone? NOW() and Nowadays() return values in PDT/PST (Pacific Daylight keeping Time/Pacific Regular Time). This can be compensated by subtracting the offset to UTC (Coordinated Universal Time) of PDT/PST and including the offset of your own timezone. E.g. PST has an offset of -7 hours to UTC and CEDT (Central European Daylight Time) has an offset of 2 hrs to UTC. So 'now' in penny stocks CEDT (NOW() -(-seven/24)(2/24)). Click the following for a table of timezones How can I format time values with out the seconds ? Use the TEXT() purpose TEXT(A1, "HHmm") Or for instance TEXT(Scratch!$D$five, "HHmm") if you use a scratch sheet to conceal your uncooked information. How can I format time with out the hrs? Right(TEXT(A1, "mm"),2) - only minutes Proper(TEXT(A1, "mmss"),five)- minutes and seconds Appropriate(TEXT(A1, "mmss.SSS"),nine) - shows also fractions of a second (upto milliseconds) How can I add times ? Occasions can be additional just as figures, after hours trading the question is how to exhibit them. See up coming problem. How can I exhibit time values greater than 24 hrs ? Use the method INT(A1)*24 HOUR(A1) & TEXT(A1,"mm") The formulation INT(A1*24) & TEXT(A1,"mm") functions also, but is not usually specific to the 2nd.(due to problems with the HOUR operate and rounding mistakes respectively) How to display the day of the week ? There are two techniques. The small way is MID(TEXT(A1,"ddEEEE"),3,nine) The other way is Choose(WEEKDAY(A1),"Sun","Mon","Tues","Wednes","Thurs","Fri","Satur","Sunshine") & "day" - or - Opt for(WEEKDAY(A1), "Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday") The gain of the latter is that it can be tailored to other languages and is less cryptic. Miscellaneous guidelines & tricks I want to do XXX. I can do XXX in Excel/Open Place of work, but not in Gsheets. What can I do? Get the file to Excel with -export-.xls -OR- Download the file to Open up Workplace with -export-.ods Open the downloaded file in Excel or Open up Office Do no matter what you require to do and could not do in Gsheets and conserve the changes. Go back again to the Google Spreadsheet in you browser and decide on -Add new model If you are online trading the only editor of the file, you can skip stage 1. Shorter URL for shared spreadsheets. You can get a straightforward/limited model of the URL for a granted spreadsheet from the "Sharing Possibilities" pane. Working with intermediate benefits. A lot of formulas and formats readily available in Excel can be emulated in Gsheets with the use of intermediate outcomes. Also formulas can be held straightforward and a lot more concise utilizing intermediate results. This needs additional cells which you in all probability never want to see in your presentation. It is thus recommendable to use cells in a dedicated worksheet. Let's get in touch with this sheet "Scratch". Illustration You want a date exhibited as 24-3-06, a format not accessible in the format menu. Put this date someplace on sheet Scratch, say D5, and in the cell wherever you want to exhibit it place the system TEXT('Scratch'!$D$five,"dd-m-yy") How do I generate a graph of my data? Even though graphics are not carried out in Gsheets, there is a straightforward and classy workaround working with the REPT functionality and the "" character. Suppose the information to be displayed in a graph is in column A, then propagate the forex news up coming components in the column the place you want the graph REPT("",(A1 - MIN(AA)) * 99 / (MAX(AA) - MIN(AA))) Exchange the variety 99 by the greatest variety of characters you want shown and A by the column the knowledge is in. Source At the higher than link you will uncover far more subtle ideas to emulate graphics. Not applied (however?) API (Software Programmers Interface) Autofilter Remarks Conditional formatting Customized formats Drop down lists Discover / Exchange Freeze columns Graphics Pivot tables Macro assistance Merge vertically Referring ranges in other spreadsheet information Validation 3D referencing like SUM('sheet1sheet9'!C6) Editors Aaron,Ahab&Lexcel Very last modified by Lexcel 2006-10-20 1323 UTC Recommendations for this web page are welcome.