BrockC2000's Profile

Membership information

Username BrockC2000
Email Hidden
User type Member
Title None
Posts 0
Date Registered October 18th, 2012
Last Active October 20th, 2012

Personal information

Website penny stocks penny stocks
Real name Kim
Location Fort Myers
Gender Female
MSN Messenger
AOL Instant Messenger
Yahoo Messenger
Bio This is the unofficial Google Spreadsheets regularly asked inquiries internet site Common Inquiries Do I need to have a gmail account to use Google Spreadsheets? How can I swap off the autosave alternative How can I have more than one hundred 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 absolutely black. How does the autofill function perform? How do I disguise the gridlines. Can I use names for ranges? How can I make an email deal with are living/clickable? Time and date associated questions. How can I determine working occasions ? How can I get the local time/date for my timezone? How can I format time devoid of hours? How can I format time values without having the seconds ? How can I add instances ? How can I screen time values which are above 24 hours ? How to display the day of the week ? Guidelines & tricks I want to do XXX. I can do XXX in Excel/Open up Workplace, but not in Gsheets. What can I do? Shorter URL for shared spreadsheets. Employing intermediate benefits. Generating graphics devoid of graphs. Record of not (however?) carried out functions Ask for a feature Beneficial inbound links Research Google Spreadsheets Your Google on-line documents The Google Document forum Introduction to spreadsheets (pdf) Tech on the internet sophisticated (excel) products Do I require to have a gmail account to use Google Spreadsheets? No, you will not will need a account, but you do want a account. It is extremely uncomplicated to get one. Here is the url https// If you deliver an invitation to reveal a spreadsheet to an electronic mail handle that is not connected with a Google account, the invitee is immediately invited to develop a Google account 1st. Note A account is not the same as a account. A account can be created with any electronic mail deal with (like ) A account is usually instantly a account. How can I switch off the autosave choice You can't, because that would ruin the most standard function of the application The capacity to reveal info in authentic time. But you can down load to your possess pc as backup ( - Export , pick .ods or .xls) make a duplicate of your spreadsheet with one more identify like mysheet - in progress ( - Save a duplicate) In situation you want to revert back again to an mature model you can then - Add new model to restore from your personal personal computer - Rename to consolidate a stable edition - Delete to delete an obsolete model The format I want is not in the menu. What can I do? You can use the TEXT perform to show formats that are not in the menu. See also Working with intermediate resultsandHow can I produce a custom format ? How can I make a customized format ? Custom formats can be made utilizing the TEXT() perform. A lot of undocumented formats are available. Click on right here for a listing of custom made format directives I have opened up a spreadsheet and it is completely black. 1 of the protection configurations for IE on your desktop is most very likely set to disable binary and script behaviors underneath ActiveX controls. Environment this to enable must deal with this and exhibit your spreadsheet. It may well also be required to clear your cache Equipment-Internet Options-Delete temporary files How does the autofill function get the job done? If you choose a column, row or block, Ctrlr will propagate the method(s) in the most left column to all the chosen cells to the appropriate, while Ctrld will propagate the best row down. You can also copy one particular cell/row/column and paste it to a block of cells. How can I have additional than 100 rows ? Decide on all cells (by clicking the sq. above row one and left of column A) Click the button. Now you have the alternative to add a hundred rows. Repeat over measures and you can insert 200 rows, then four hundred, etc. How to hide gridlines In excel, decide on an place (or all cells) and then select FormatCellsBorder. In this dialog box, select Coloring White (or what ever is your default cell track record color), and then pick out the Define and Inside buttons below Presets. Then validate Okay. Now you have a fully white area (or sheet), i.e. due to the fact the grid is white and the cells are also white, you have "concealed" 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 make them is in Excel or Open up Business office. How? How can I make an electronic mail address live/clickable? http// and ftp// are recognised by Gsheets and develop clickable hyperlinks, even so mailto is not carried out. The workaround is to use the HYPERLINK() purpose in blend with a brief javascript as follows HYPERLINK("http//","Send mail to Unofficial Q & A") - or - Electronic mail address in A1 HYPERLINK("http//"& A1, A1) Time and date relevant questions. How can I calculate working times ? Starttime in A1, conclude time in B1 use the formulation MOD(B1-A1,1) This method is right also for evening shifts. (when A1 B1) How can I get the community time/date for my timezone? NOW() and Today() return values in PDT/PST (Pacific Daylight conserving Time/Pacific Regular Time). This can be compensated by subtracting the offset to UTC (Coordinated Universal Time) of PDT/PST and incorporating the offset of your possess timezone. E.g. PST has an offset of -seven hrs to UTC and CEDT (Central European Daylight Time) has an offset of 2 hours to UTC. So 'now' in CEDT (NOW() -(-7/24)(two/24)). Click on right here for a table of timezones How can I format time values without the seconds ? Use the TEXT() purpose TEXT(A1, "HHmm") Or for case in point TEXT(Scratch!$D$five, "HHmm") if you use a scratch sheet to conceal your raw information. How can I format time devoid of the hrs? Right(TEXT(A1, "mm"),2) - only minutes Right(TEXT(A1, "mmss"),five)- minutes and seconds Right(TEXT(A1, "mmss.SSS"),nine) - shows also fractions of a second (upto milliseconds) How can I include instances ? Occasions can be extra just as numbers, the concern is how to display them. See following issue. How can I show time values better than 24 hrs ? Use the system INT(A1)*24 HOUR(A1) & TEXT(A1,"mm") The components INT(A1*24) & TEXT(A1,"mm") will work also, but is not usually exact to the 2nd.(because of to complications with the HOUR functionality and rounding glitches respectively) How to screen the day of the week ? There are two techniques. The quick way is MID(TEXT(A1,"ddEEEE"),three,9) The other way is Opt for(WEEKDAY(A1),"Sunlight","Mon","Tues","Wednes","Thurs","Fri","Satur","Sunlight") & "day" - or - Opt for(WEEKDAY(A1), "Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday") The advantage of the latter is that it can be adapted to other languages and is much less cryptic. Miscellaneous recommendations & tricks I want to do XXX. I can do XXX in Excel/Open up Office, but not in Gsheets. What can I do? Get the file to Excel with -export-.xls -OR- Get the file to Open Office with -export-.ods Open the downloaded file in Excel or Open Workplace Do what ever you will need to do and couldn't do in Gsheets and preserve the changes. Go back again to the Google Spreadsheet in you browser and opt for -Upload new edition If you are the only editor of the file, you can skip step 1. Shorter URL for shared spreadsheets. You can get a straightforward/brief version of the URL for a granted spreadsheet from the "Sharing Possibilities" pane. Utilizing intermediate outcomes. A lot of formulas and formats accessible in Excel can be emulated in Gsheets with the use of intermediate effects. Also formulas can be stored easy and a lot more concise making use of intermediate benefits. This involves more cells which you in all probability never want to see in your presentation. It is therefore recommendable to use cells in a dedicated worksheet. Let's simply call this sheet "Scratch". Illustration You want a date exhibited as 24-3-06, a format not readily available in the format menu. Put this date somewhere on sheet Scratch, say D5, and in the cell the place you want to display it put the system TEXT('Scratch'!$D$5,"dd-m-yy") How do I develop a graph of my information? Although graphics are not implemented in Gsheets, there is a straightforward and tasteful workaround making use of the REPT perform and the "" character. Suppose the knowledge to be shown in a graph is in column A, then propagate the up coming components in the column exactly where you want the graph REPT("",(A1 - MIN(AA)) * ninety nine / (MAX(AA) - MIN(AA))) Substitute the variety ninety nine by the utmost number of characters you want shown and A by the column the data is in. Supply At the above url you will uncover much more subtle ideas to emulate graphics. Not implemented (yet?) API (Application Programmers Interface) Autofilter Comments Conditional formatting Custom made formats Drop down lists Find / Replace Freeze columns Graphics Pivot tables Macro help Merge vertically Referring ranges in other spreadsheet files Validation 3D referencing like SUM('sheet1sheet9'!C6) Editors Aaron,Ahab&Lexcel Previous modified by Lexcel 2006-10-20 1323 UTC Tips for this page are welcome.

Site information

Message Board signature

Copyright 2005
Questions? Comments? Bug reports? Contact us!