Site logo

        Tips

        Tips

        1. Tips
        Tips
        • Drive
        • Gmail
        • Docs
        • Overdrive
        • Calendar
        • Sheets
        • Sites
        • Chrome
          • How to remove the Reading list button from Chrome
        • Contacts
        • Slides
        • Chat
        • Meet
        • Forms
        • Keep
        • More...
          • Admin
          • Android
          • Images
          • iOS
          • Migration
          • Scripts
          • Security
        Sign in with Google

        Or

        We won't share your email address with any third-parties.
        Please see our Privacy Policy for further information.

        About Us

        G Suite Tips is provided by the team at Overdrive. We’re passionate about Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

        Latest Tips

        • How to Download Images from Google Docs

          Have you ever tried downloading or saving an image from a Google Doc? Here’s an easy way to save images from any document, with just a few clicks. Trying to save an image from a Google Doc can be frustrating because there’s no download button that allows you to save it straight away. Fortunately, we found a couple of workarounds. Method one: Download all images To get started, open the Google Doc and from the menu bar go to File > Download > Web page. Google Docs will compile all the images (and other elements from the document) in a single folder. From there, you can extract the images you need. Method two: Save a single image For some, this method might be easier since you won’t need to download all the images from a document. However, this method is not recommended if you’re working with a sensitive document, since it will require you to make it public for a brief period of time. To get started, open the document and go to File > Share > Publish to web. Once published, open the public link to the document and right-click the image you want to save. Choose “Save image as” to download it. You can then go back to File > Share > Publish to web and unshare the document. If you’re looking for a way to save or download images from any Google Drive files, including Slides, check out our tip about how to edit and extract images from Google Drive files. If you have any Google Docs tips that would help others, feel free to share them with our Workspace Community .

        • How to count characters in Google Sheets

          When you’re using Google Sheets for work or school, you may have to deal with text data. Unlike Google Docs, the spreadsheet app from Google doesn’t have a built-in character counter. However, there’s a dedicated Google Sheets function to count characters. Counting characters in Google Sheets is easier than you may think. The LEN function can be used in many situations to count characters in a spreadsheet. Count all characters in a cell Type in the LEN function and make a reference to the cell you want to count. This method is used to count all characters, including letters, numbers, spaces, punctuation marks, etc. Example: =LEN(A2) Count characters and ignore spaces The LEN function counts all characters, including spaces. If you want the count to ignore spaces and punctuation marks, you can add the SUBSTITUTE function to the syntax; the main purpose of this function is to replace one character with another, so we’re using it in order to replace spaces and other punctuation marks with nothing. Example: =LEN(SUBSTITUTE(A3, " ", "")) Count all characters in a column The LEN function doesn’t work with a range of cells, but you can add the SUMPRODUCT function to sum up the characters in a range. Example: =SUMPRODUCT(LEN(A2:A9)) Remember that the LEN function counts all characters, including spaces. If you want removed spaces and punctuation marks, simply use the SUMPRODUCT function to add up the results from the counting column. Example: =SUMPRODUCT(B2:B9) If you still have questions about counting characters in Google Sheets, ask our community of Google Workspace power users!

        • How to Avoid Getting Removed from Google Meet Calls

          Google Meet is used by many organizations on a daily basis for quick calls or virtual meetings. Google Calendar meetings automatically receive a Meet link which guests can use to join the virtual meeting room. Google is working to make the app more efficient and constantly introduce new features. The “leave empty calls” feature can remove you from a meeting when you're the only person in it. Let's say you enter a team meeting and no one arrives within five minutes: a pop-up message will appear, asking if you're still there and if you'd prefer to wait or hang up. You will be instantly thrown out if you do not answer within two minutes. Although this feature can prevent people from leaving meeting tabs open and accidentally broadcasting their video and audio feeds, some of us find it irritating. With this feature enabled, you will be kicked out of the meeting if your colleagues are a few minutes late. This option is enabled by default, but you can switch it off via Google Meet settings. Disable the “Leave empty calls” feature to prevent Google Meet from kicking you out of meetings and keep a regular meeting pinned as tabs. Open any Google Meet room and click on the three dots from the right corner of your camera feed. 2. Click on Settings. 3. Navigate to the General settings tab and switch off the “Leave empty calls” toggle. Your new settings are automatically saved, so you can just close the settings window. On mobile devices, open the Google Meet apps and select the account you want to switch off the feature for. Go to Settings and tap on the “Leave Empty Calls” option. What do you think about this feature? Visit our Google Workspace community forum and share your thoughts with other Google Meet users.

        © 2016-2021 Refractiv Limited. All Rights Reserved
        Powered by Overdrive
        • Tips
          • Drive
          • Gmail
          • Docs
          • Overdrive
          • Calendar
          • Sheets
          • Sites
          • Chrome
          • Contacts
          • Slides
          • Chat
          • Meet
          • Forms
          • Keep
          • More...
        • Community
          • Member lounge
          • Devops & Admin
          • Power User
          • Workspace Tools
          • User Productivity
        • Tools
          • Change Owner
          • Copy Folder
          • Filename Editor
        • Services
          • Development
          • Training
        • Add-on Apps
          • Website Builders
          • CRM Solutions
          • Backup Solutions
          • Admin and Security
          • HR Software
          • Productivity
        • Blog