Join our network of non-profits, companies and individuals who believe social change can happen through design.

Become A Member

William Thompson

United States

Member since December 18, 2012

This is the unofficial Google Spreadsheets generally asked inquiries web page

Basic Queries

Do I need to have a gmail account to use Google Spreadsheets?

How can I switch off the autosave alternative

How can I have additional than a hundred rows ?

The format I want is not in the menu. What can I do?

How can I create a custom made format ?

I have opened up a spreadsheet and it is fully black.

How does the autofill function function?

How do I disguise the gridlines.

Can I use names for ranges?

How can I make an e mail address online trading reside/clickable?

Time and date related inquiries.

How can I determine doing work times ?

How can I get the neighborhood time/date for my timezone?

How can I format time with out hrs?

How can I format time values devoid of the seconds ?

How can I include days ?

How can I show time values which are about 24 hrs ?

How to exhibit the day of the week ?

Ideas & tricks

I want to do XXX. I can do XXX in Excel/Open up Place of work, but not in Gsheets. What can I do?

Shorter URL for shared spreadsheets. commodity trading

Utilizing intermediate benefits.

Creating graphics without having graphs.

Listing of not (still?) carried out attributes

Ask for a characteristic

Beneficial backlinks

Research Google Spreadsheets

Your Google on-line files

The Google Document discussion board

Introduction to spreadsheets (pdf)

Tech on the web innovative (excel) stuff

Do I need to have to have a gmail account to use Google Spreadsheets?

No, you do not require a account, but you do want a account.

It is really effortless to attain 1. The following is the website link


If you ship an invitation to reveal a spreadsheet to an e mail tackle that is not linked day trading with a Google account, the invitee is immediately invited to make a Google account initial.

Be aware

A account is not the same as a account.

A account can be produced with any electronic mail handle (like )

A account is often routinely a account.

How can I swap off the autosave option

You cannot, since that would damage the most simple element of the application The capacity to share data in actual time. But you can

obtain to your very own computer system as backup ( - Export , decide on .ods or .xls)

make a duplicate exchange of your spreadsheet with a different name like mysheet - in progress ( - Conserve a duplicate)

In situation you require to revert back again to an older edition you can then

- Upload new model to restore from your personal pc

- Rename to consolidate a steady edition

- Delete to delete an out of date model The format I want is not in the menu. What can I do?

You can use the TEXT function to show formats that are not in the menu.

See also Working with intermediate resultsandHow can I produce a custom made format forex news ? How can I make a customized format ?

Custom made formats can be produced working with the TEXT() functionality. Several undocumented formats are offered.

Click on here for a listing of custom 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 very likely set to disable binary and script behaviors under ActiveX controls. Setting this to enable really should correct this and show your spreadsheet.

It could also be crucial to apparent your cache Tools-Internet Options-Delete short-term information How does stock trading software the autofill attribute get the job done?

If you pick a column, row or block, Ctrlr will propagate the method(s) in the most left column to all the selected cells to the appropriate, although Ctrld will propagate the leading row down. You can also copy a single cell/row/column and paste it to a block of cells. How can I have far more than a hundred rows ?

Decide on all cells (by clicking the square previously mentioned row 1 and left of column A)

Click the button. Now you have the choice to include one hundred rows.

Repeat higher than techniques and you after hours trading can insert two hundred rows, then four hundred, and many others. How to disguise gridlines

In excel, choose an area (or all cells) and then decide on FormatCellsBorder.

In this dialog box, decide on Color White (or whatever is your default cell background color), and then pick the Outline and Inside of buttons beneath Presets. Then validate Okay. Now you have a absolutely white portion (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 forex market does not offer a mechanism to outline them. The only way to develop them is in Excel or Open up Office. How? How can I make an electronic mail handle live/clickable?

http// and ftp// are recognised by Gsheets and produce clickable hyperlinks, nonetheless mailto is not carried out.

The workaround is to use the HYPERLINK() perform in combo with a short javascript as follows

HYPERLINK("http//","Send mail to Unofficial Q & A") - or -

Email deal with in A1

HYPERLINK("http//"& A1, A1)

Time and date connected issues. How can I determine doing work times ? forex trading

Starttime in A1, end time in B1 use the formula MOD(B1-A1,one)

This components is accurate also for evening shifts. (when A1 B1) How can I get the nearby time/date for my timezone?

NOW() and Currently() return values in PDT/PST (Pacific Daylight preserving 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 private timezone. E.g. PST has an offset of -7 hrs to UTC and CEDT (Central European Daylight Time) has an offset of 2 hours to UTC. So 'now' in options trading CEDT (NOW() -(-7/24)(two/24)). Click the following for a table of timezones How can I format time values with no the seconds ?

Use the TEXT() perform TEXT(A1, "HHmm")

Or for instance TEXT(Scratch!$D$5, "HHmm") if you use a scratch sheet to conceal your raw data. How can I format time devoid of the hrs?

Proper(TEXT(A1, "mm"),two) - only minutes

Right(TEXT(A1, "mmss"),5)- minutes and seconds

Appropriate(TEXT(A1, "mmss.SSS"),9) - displays also fractions of a 2nd (upto milliseconds) How can I add moments ?

Times can be added just as numbers, commodity trading the issue is how to screen them. See upcoming problem. How can I display time values increased than 24 hours ?

Use the system

INT(A1)*24 HOUR(A1) & TEXT(A1,"mm")

The system INT(A1*24) & TEXT(A1,"mm") will work too, but is not often specific to the 2nd.(because of to issues with the HOUR functionality and rounding glitches respectively) How to screen the day of the week ?

There are two methods. The short way is


The other way is Decide on(WEEKDAY(A1),"Sunshine","Mon","Tues","Wednes","Thurs","Fri","Satur","Sunshine") & "day"

- or -

Pick(WEEKDAY(A1), "Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")

The advantage of the latter is that it can be tailored to other languages and is much less cryptic.

Miscellaneous ideas & methods 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


Obtain the file to Open up Workplace with -export-.ods

Open up the downloaded file in Excel or Open up Place of work

Do whatever you require to do and couldn't do in Gsheets and help you save the adjustments.

Go back again to the Google Spreadsheet in you browser and select -Add new version

If you are the only editor of the file, you can skip action 1. Shorter URL for shared spreadsheets.

You can get a uncomplicated/short model of the URL for a offered spreadsheet from the "Sharing Selections" pane. Working with intermediate results.

Quite a few formulas and formats obtainable in Excel can be emulated in Gsheets with the use of intermediate effects. Also formulas can be kept basic and additional concise employing intermediate benefits. This calls for additional cells which you probably never want to see in your presentation. It is therefore recommendable to use cells in a dedicated worksheet. Let us get in touch with this sheet "Scratch".

Case in point You want a date exhibited as 24-3-06, a format not offered in the format menu. Put this date somewhere on sheet Scratch, say D5, and in the cell where you want to show it place the components TEXT('Scratch'!$D$five,"dd-m-yy") How do I develop a graph of my info?

Although graphics are not applied in Gsheets, there is a easy and stylish workaround utilizing the REPT operate and the "" character.

Suppose the information to be exhibited in a graph is in column A, then propagate the forex news next components in the column wherever you want the graph

REPT("",(A1 - MIN(AA)) * 99 / (MAX(AA) - MIN(AA)))

Substitute the range ninety nine by the utmost quantity of characters you want shown and A by the column the knowledge is in.


At the previously mentioned website link you will find additional sophisticated concepts to emulate graphics. Not carried out (still?)

API (App Programmers Interface)



Conditional formatting

Custom formats

Drop down lists

Find / Exchange

Freeze columns


Pivot tables

Macro support

Merge vertically

Referring ranges in other spreadsheet files


3D referencing like SUM('sheet1sheet9'!C6)



Last modified by Lexcel 2006-ten-20 1323 UTC

Recommendations for this webpage are welcome.

about GarethMcbride2002

Contact William Thompson

My Interests

  • Industrial Design
  • Environmental Design
  • Communication Design
  • Fashion Design
  • Audio/Visual Design