Tag Info

Hot answers tagged

2

This will do: =SUM(INDIRECT(ADDRESS(ROW()-11;COLUMN();4) &":"& ADDRESS(ROW()-1;COLUMN();4))) Just paste it any cell you like and it will sum 10 cells above it, with no changes to the value. The ADDRESS function returns a string with the name reference of a cell. We join two references with a ":" between them, giving us a string like "B5:B15". We ...


2

https://drive.google.com/uc?export=download&id=YOUR_FILE_ID Replace "YOUR_FILE_ID" for the ID of your file


2

There is now. Inside any document click Add-ons → Get add-ons... and search for draw.io. Afterwards you will be able to add drawings through Add-ons → Draw.io Diagrams


2

It is a Labs feature: I don't know why it was turned off...


2

You can highlight multiple docs at once using "command" + left click on Mac. I believe that correspond to "control" on PC. This will highlight multiple docs at once, and then you can click the trashcan which will delete all the selected files.


2

For new documents you can use ready-made templates. Google Docs has a template system for new documents. You can submit your own template and use it every time you want to create a document. Your own templates are here (and are public). You can create a bookmark to your "Preview template"-link so it's easy to reach. You only need to click Use this ...


1

If you just want them for auto awesome, maybe you don't need to upload them in full resolution. (Since the resolution of most auto awesomes is downgraded at creation anyways). Then the photos won't count towards your Google Drive Space at all (free storage). So go to Google+ settings, and pick the option to upload photos in "standard" size (rather than full ...


1

I hope there's a more elegant way to do this but - The only way I found around it was to go to google photos and search #AutoAwesome click for larger Then, I clicked the check-mark on the top-left corner of the first photo, scrolled to the end and shift-clicked the check-mark on the last photo. I then went to more- download click for larger Now, I ...


1

Have you tried setting up a file for download with a different file extension, something innocuous like .txt? Google may be trying to prevent people from hosting viruses/malware by disallowing anonymous downloads of .zip, .exe, etc. files.


1

Mac actually does have an insert equivalent if you press Fn (function) and Enter\return together, this is the equivalent of insert on a mac and should enable overtype mode.


1

You can host a website, of sorts, on Google Drive. There are caveats: It can only be simple HTML, JavaScript, and CSS. No scripting (e.g., PHP). The only way to have a custom domain is to have such a domain hosted elsewhere and either redirect to your Google Drive "site" or otherwise consume it via an iFrame or some other method. Per Google Support this ...


1

so can I host my own website which having my own domain No. Also can I install WordPress to my website if that can be hosted with google drive? No, that's not possible


1

Share the spreadsheet which holds form responses in view mode. They can make a copy of the spreadsheet which will also copy the form for them.


1

Click on the Present button top right corner, this will start the presentation mode. Right click on the image, use option Save as to save the image.


1

I faced the same problem. In the new web interface you can click the button with folder name and select the Add star item. However, for me this does not have any effect in web interface (the star is lost after page refresh) nor in Android Google Drive app, though it miraculously works in Google Drive app on iPad. Apparently Google needs some more time to ...


1

Just had the same problem, except it was a shared folder sent to me that didn't even show the download all button or have the ability to save more than one file (in this case images) at once. Just found Download Master, a plugin for Chrome, worked a charm—it scans the page for links and lets you filter by file type, it doesn't compress for downloads, so it ...


1

Subscribers to Google Apps Unlimited have access to an audit log which shows the following when users visit a document: User—The user who performed the activity. Date—The date the event occurred (displayed in your domain's default timezone). Event Name—The action the user performed, such as View, Create, or Edit. IP Address—The IP address from where the ...


1

Try these settings: Just once for all docs: View: Print layout: unchecked For each doc: File: Page setup: Orientation: Landscape Paper size: Tabloid (11" x 17") Zoom: Fit or 100%, etc. If the pragmatic goal is to maximize the usable width, the noted settings together contribute to this effect. If you're not sufficiently satisfied, you can decrease ...


1

I had a similar problem and found a good solution. Copy the table to some simple text editor that supports regex. I used notepad++. Then insert the decimal separator before the numbers. Then you can copy the table to the spreadsheet. E.g. if you have 3 digits without a decimal separator in front, you search replace using (\d\d\d) and .\1.


1

You can reduce the gap at the top of a table by placing the cursor above the table, and reducing the font size. I can't seem to reduce it below 6 points, and even this required me to type the number into the "Font size" box. However, it does at least move the table up a bit. I had to do the same thing at the bottom of my table. If anybody wants to log this ...


1

I recommend using Google Chrome as a browser for this (I do not know if it'll work with IE, Firefox, or any other). To create a shortcut for any file in your Drive to your desktop is to simply open the file, then click on the button at the top right of the page (1), and scroll down to "More Tools" (2). You'll see the option "Create Application Shortcuts" ...



Only top voted, non community-wiki answers of a minimum length are eligible