Google Software/Tips – Online Tech Tips https://www.online-tech-tips.com Computer Tips from a Computer Guy Thu, 14 Sep 2023 20:05:36 +0000 en-US hourly 1 https://wordpress.org/?v=6.3.1 How to Unsubscribe From a YouTube Channel https://www.online-tech-tips.com/google-softwaretips/how-to-unsubscribe-from-a-youtube-channel/ https://www.online-tech-tips.com/google-softwaretips/how-to-unsubscribe-from-a-youtube-channel/#disqus_thread Ben Stockton]]> Thu, 14 Sep 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=98087

YouTube is a great platform to watch videos on various topics, from entertainment to education. If a channel you’ve loved in the past has lost its charm, however, it might […]]]>
YouTube is a great platform to watch videos on various topics, from entertainment to education. If a channel you’ve loved in the past has lost its charm, however, it might be time to unsubscribe.

You may want to unsubscribe from a YouTube channel that you no longer find useful, subscribed to by mistake, or that you’ve simply lost interest in. Unsubscribing from a YouTube channel will stop you from being notified when new videos are released and can help to clean up your YouTube recommendations.

Whatever the reason, you can easily unsubscribe from a YouTube channel using your web browser or by using the YouTube mobile app using the steps below.

How to Unsubscribe from a YouTube Channel on a Web Browser

The easiest way to remove a YouTube subscription from your account is to use your web browser. You can control your account preferences (such as your current channel subscriptions) from the YouTube website on your PC, Mac, or Chromebook.

  1. From your web browser, open YouTube, sign in with your Google account, and select the Subscriptions tab from the sidebar on the left.
  1. You’ll see a list of channels that you’re subscribed to and their latest videos. Select the Manage button in the top-right.
  1. To unsubscribe from a channel, click the Subscribed button next to it, then choose Unsubscribe from the drop-down menu.
  1. Alternatively, open a channel’s home page via your Subscriptions tab or YouTube’s search tool and press the Subscribed button in the top-right, then choose Unsubscribe from the drop-down menu.
  1. When prompted, press Unsubscribe in the pop-up to confirm your choice.
  1. Once you’ve unsubscribed from the channel, the button will change to Subscribe—this will confirm that you’re no longer subscribed to the channel.

You can also unsubscribe from a channel while watching one of its videos—just click on the Subscribed button below the video and confirm your action to remove the subscription.

How to Unsubscribe From a YouTube Channel on the YouTube Mobile App

If you prefer to use YouTube on your mobile device, you can control your subscriptions using the app. To remove a YouTube subscription on mobile, follow these steps.

  1. Open the YouTube app on your mobile device and sign in with your Google account.
  2. Tap the Subscriptions icon from the menu at the bottom of the screen. You’ll see a list of channels that you’re subscribed to at the top and their latest videos.
  1. Tap on a channel name, channel icon, or search for it manually using the YouTube search tool to go to its homepage.
  2. On the channel’s homepage, tap the Subscribed button below the channel’s name.
  1. A pop-up window will ask you to confirm your action—tap Unsubscribe to confirm.
  1. Once you’ve confirmed the removal of the subscription, the button below the channel’s name will change to Subscribe again. This is confirmation that you’re no longer subscribed to the channel.

Like PC users, you can also unsubscribe from a channel while you’re watching one of its videos. Below the playing video (outside of fullscreen mode), tap the Subscribed button to remove the subscription—you’ll need to confirm that you want to unsubscribe when you do this.

Managing Your YouTube Account

Thanks to the steps above, unsubscribing from YouTube channels is a quick and easy process that you can complete from a PC, Mac, or mobile device. Removing channels you don’t watch anymore from your subscription list will limit the notification spam, but you can always disable your YouTube notifications to help this further.

Struggling with the amount of ads you’re seeing while a video is playing? You can always look at different ways to block YouTube ads, from a YouTube Premium subscription to other methods, such as using a VPN.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-unsubscribe-from-a-youtube-channel/feed/ 0
YouTube Not Working On Android? 6 Ways to Fix https://www.online-tech-tips.com/google-softwaretips/youtube-not-working-on-android-6-ways-to-fix/ https://www.online-tech-tips.com/google-softwaretips/youtube-not-working-on-android-6-ways-to-fix/#disqus_thread Ben Stockton]]> Mon, 11 Sep 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=98006

In an age where we rely heavily on streaming platforms for entertainment and information, a smooth user experience is the bare minimum you should expect. Unfortunately, even apps like YouTube […]]]>
In an age where we rely heavily on streaming platforms for entertainment and information, a smooth user experience is the bare minimum you should expect. Unfortunately, even apps like YouTube aren’t immune from crashes or functionality issues.

If YouTube isn’t working on your Android device, it can be frustrating to resolve. To help you, here are six different fixes you can try to resolve YouTube if it isn’t working on your Android device.

Restart Your Android Device

One of the simplest ways to fix an issue with YouTube not working on your Android device is by restarting it. Restarting your Android device can help clear any temporary glitches and allow the app to function properly.

To restart your Android device, follow these steps.

  1. Press and hold the power button on your device until the power options menu appears.
  2. Tap the Restart or Power Off option, depending on your device’s menu.
  1. If you choose Power Off, wait for a few seconds and press the power button again to turn it back on.
  2. Once your device has restarted, try opening the YouTube app to check if the issue has been resolved.

With a freshly restarted Android device, your YouTube app should start to work again. If it isn’t, however, you’ll need to try one of the further fixes below.

Check Your Time Is Synced Properly

It might seem odd, but if your Android device has the wrong time, YouTube might stop working. This is because the time between your device and YouTube’s servers need to be synced properly for certain (hidden) services behind-the-scenes to work properly.

To ensure your device’s date and time are synced correctly, follow these steps.

  1. Open the Settings app.
  2. Look for Date & time settings—this may be listed under General, System, or similar, depending on your version of Android.
  1. Enable the toggle for Automatic date & time. Your device will default to using your network-provided date and time settings.
  1. The changes should be applied immediately, but you can restart your device to be sure the changes have taken effect.

If enabling the automatic date and time feature doesn’t work, you can manually set the correct date and time for your device.

  1. To do this, open the Settings app on your Android.
  2. Open your Date & time settings (under General, System, or similar).
  1. Disable the toggle for Automatic date & time.
  2. Tap Set date and choose the correct date, then tap OK.
  3. Tap Set time and choose the correct time before tapping OK.

After adjusting your device’s date and time settings, open the YouTube app and check if the issue has been resolved.

Check Your Data or Wi-Fi Connection

One of the most common reasons that YouTube might not work properly on your Android device is a poor internet connection. Issues like YouTube videos pausing or choppy video playback can often be resolved by checking that your mobile data or Wi-Fi connection is active and working properly.

To check your data connection, follow these steps.

  1. Open your Android device’s Settings app.
  2. Open your Network & Internet or Connections menu. The name of this menu will vary, depending on the device you’re using and the version of Android it runs.
  1. First, open your Data usage menu and make sure that the Mobile data or Cellular data setting is enabled. If it’s already on, try turning it off and back on again. Look for a data indicator (such as 4G, 5G, or similar) next to the signal strength bars at the top of the screen to confirm that you have a signal.
  1. Next, open your Wi-Fi settings menu.
  2. Make sure that Wi-Fi is enabled and you’re connected to a network. Once you are, check the Wi-Fi signal strength bars at the top of the screen to ensure a strong connection.

Clear the Data and Cache for the YouTube App

If you’re having trouble trying to troubleshoot an issue with YouTube not working on Android, you may find it easier to clear your cached data from the app. This can help you resolve minor glitches with the app itself that could stop it from working, such as the YouTube search bar not working.

To clear the data and cache for the YouTube app, follow these steps. The steps below might slightly vary depending on your phone model.

  1. Open the Settings app on your Android phone.
  2. Select Apps or Apps & Notifications (depending on your Android version).
  1. Choose YouTube from the list of apps. If you don’t see it in the list, use the search bar at the top to help you locate it.
  1. Next, tap the Storage or Data option.
  1. Select Clear cache to remove cached files. This step will not delete your saved data, like account information and preferences.
  2. Next, select Clear data to delete all the app’s saved information. This will also remove your account details and preferences from the app, so you’ll need to sign in again afterward.

After clearing your data, restart the YouTube app and check if the issues are resolved.

Check for App and Device Updates

Keeping your YouTube app and device software updated is crucial as it ensures that you have the latest bug fixes, security patches, and features. By regularly updating the app, you can minimize the chances of encountering any issues.

To update your YouTube app, follow these steps.

  1. Open the Google Play Store app on your Android device.
  2. Select your profile icon in the corner and select Manage apps and devices from the menu.
  1. In the Manage apps and device menu, tap the Manage tab, then tap the Updates available icon below it.
  1. Look for the YouTube app in the list of apps with updates available. If an update is available, tap it to select it, then press the update button in the top-right.

Once the YouTube app is updated, open it to see if the issues are resolved.

Remove and Reinstall YouTube App Updates

If you’re still having problems with YouTube crashing on Android, you might need to try and remove any recent updates and reinstall them. Most Android devices come with YouTube preinstalled, so you won’t be able to remove it entirely.

However, removing and reinstalling any app previous YouTube app updates will ensure that you have the latest version with any available bug fixes.

To remove and reinstall the YouTube app, follow these steps.

  1. Open the Google Play Store and search for the YouTube app.
  2. Select Uninstall from the menu. This will remove the updates from your phone and restore the original version of YouTube that was preinstalled on your phone.
  1. Once removed, tap Update to reinstall the updated version of the YouTube app.
  1. Tap Open to launch the updated YouTube app afterward.

After successfully reinstalling the updated version of the YouTube app, check to see if the issues you’ve been having are now resolved.

Use the YouTube Mobile Website

It’s a last resort, but if the YouTube app still isn’t working on Android, you can try and use the mobile website instead. You won’t have the same level of functionality as you would have in the app, but using the YouTube website will still allow you to watch videos.

To do this, open your preferred mobile web browser—Chrome is recommended, but you can use Firefox or an alternative if YouTube isn’t working in Chrome. In the address bar, type m.youtube.com and press Enter.

The YouTube website will load and you can begin to watch videos. If you want to access your watch history or subscription list, you can sign in using your Google account details first.

Using YouTube on Android

By following the steps above, you can quickly resolve the problem with YouTube not working on Android (in most cases). If the YouTube app is too slow, don’t forget to give your device a quick restart—it should help to fix things quickly.

If you still have trouble, don’t forget to try using YouTube on another device, such as using the YouTube app on Roku. If you get a black screen on YouTube, make sure to check that your connection is working properly and you’re not using any ad blockers on your device.

]]>
https://www.online-tech-tips.com/google-softwaretips/youtube-not-working-on-android-6-ways-to-fix/feed/ 0
How to Insert Word Art in Google Docs https://www.online-tech-tips.com/google-softwaretips/how-to-insert-word-art-in-google-docs/ https://www.online-tech-tips.com/google-softwaretips/how-to-insert-word-art-in-google-docs/#disqus_thread Marshall Gunnell]]> Tue, 05 Sep 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=97930

Google Docs is widely recognized for its large collection of features and its ease of use. One often-overlooked feature is the ability to insert Word art, which is quietly nested […]]]>
Google Docs is widely recognized for its large collection of features and its ease of use. One often-overlooked feature is the ability to insert Word art, which is quietly nested in the drawing tool.

This free Word art tool lets you turn a regular document into a more visually appealing piece. Here’s where you can find this somewhat-hidden Drive feature and how to use it.

How to Create and Insert Word Art in Google Docs

You can only insert Word art in the web version of Google Docs and not the mobile app. Open Google Docs in your browser and then create a new document or open the document you want to insert the Word art in.

  1. Click the Insert option in the menu bar.
  2. Hover your cursor over the Drawing option in the dropdown menu and then select New from the sub-menu.
  1. The Drawing window will appear. You’ll see a checkerboard which you can draw on, as well as several options in the header menu. Click Actions and then select Word art from the menu.
  1. Next, enter the text that you want to turn into Word art in the text box that appears. You can add multiple lines by pressing Shift + Enter. When you’re ready to save, press Enter.
  1. Your text will now appear on the checkerboard as Word art. You can then customize it using the options in the header menu, like changing its color, border weight, and so on. Click Save and Close once you’re finished customizing the Word art.


The Word art will then be inserted in the Google Docs document.

Aligning Word Art With Your Text

The way your Word art interacts with surrounding text can be a bit tricky, and may sometimes cause an undesirable layout shift. There are a few options available for positioning the Word art with your text.

  • In line: This option is the default option and makes the Word art behave the same as a character written in the text. It sits directly on the line of the text.
  • Wrap text: This allows your text to wrap around the Word art. In other words, the Word art remains in place while the surrounding text adjusts to it.
  • Break text: This makes your Word art essentially act as a barrier in your document.The text will stop above the Word art and continue below it.
  • Behind text: This places the Word art behind your text. This is a good idea for art such as a watermark. Be sure there’s enough contrast between the Word art and text, though.
  • In front of text: This places the Word art in front of your text.

You can find these options in the menu that appears when you click the Word art in your document.

Choosing the right wrapping option can have a big impact on the visual implications of the document, so choose carefully.

Bring Visual Potential to Your Document

Google Docs, aside from its many other features, offers creative potential with Word art. This allows users to transform ordinary text into a visual element, drawing attention to important details when necessary.

The available wrapping options also allow you to place your Word art appropriately while keeping in mind the content of the document.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-insert-word-art-in-google-docs/feed/ 0
How to Enter and Exit Full Screen in Google Chrome https://www.online-tech-tips.com/google-softwaretips/how-to-enter-and-exit-full-screen-in-google-chrome/ https://www.online-tech-tips.com/google-softwaretips/how-to-enter-and-exit-full-screen-in-google-chrome/#disqus_thread Sandy Writtenhouse]]> Tue, 22 Aug 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=97730

Full screen mode gives you a distraction-free experience for the apps you’re using. When you want to work online, read a web page, or watch an online video, you can […]]]>
Full screen mode gives you a distraction-free experience for the apps you’re using. When you want to work online, read a web page, or watch an online video, you can enter full screen mode in Google Chrome easily on Windows and macOS.

How to Enter Full Screen in Chrome

You have a few different ways to enter full screen in the Google Chrome web browser.

Use the Chrome Menu

Chrome gives you a built-in feature for entering full screen mode that you can use on both Windows and Mac.

Select the Customize and Control Google Chrome icon (three dots) near the top right of the browser window.

Next to Zoom, choose the Full Screen Mode button (empty square).

You should then see Chrome fill your entire screen.

Use the Full Screen or Maximize Button

Windows and Mac each provide a full screen, or maximize, button in your application windows. You can then enter full screen mode with a single click.

On Windows, the Maximize button (square) is in the top-right corner. You can also right-click the top bar and choose Maximize. Note that this option keeps the Task Bar in view.

On Mac, the Enter Full Screen button (green with diagonal arrows) is on the top left. You can also hold the button and choose Enter Full Screen in the drop-down menu.

Use a Keyboard Shortcut

If you like using keyboard shortcuts to perform actions, you can use one to enter full screen mode in Chrome as well.

  • On Windows, use the F11 key.
  • On Mac, use the key combination Control + Command + F or Fn + F.

Use the Mac Menu Bar

On Mac, you have one additional way to enter full screen mode in Chrome. Go to the menu bar and select View > Enter Full Screen.

How to Exit Full Screen in Chrome

Just like entering full screen mode in Chrome, you can exit it a variety of ways on Windows and Mac.

Use the Chrome Menu

Select the three dots near the top right of the Chrome window and choose the Exit Full Screen Mode icon next to Zoom.

Note: If you don’t see the Chrome toolbar in full screen mode on Windows, move your cursor to the top and select the X when it appears at the top of the screen.

Use the Exit Full Screen Mode Button

On Windows, use the Restore Down button (square) on the top right or right-click the top bar and pick Minimize.

On Mac, use the Exit Full Screen button (green) on the top left or hold the button and choose Exit Full Screen.

Use a Keyboard Shortcut or the Menu Bar

You can use the same keyboard shortcut to exit full screen in Google Chrome as you do to enter it.

  • On Windows, use the F11 key.
  • On Mac, use the key combination Control + Command + F or Fn + F.

Additionally, you can select View > Exit Full Screen in the Mac menu bar.

Entering and exiting full screen mode in the Chrome browser is simple enough and with various ways to do it, you can use whichever method is quickest or easiest for you.

For more, look at our list of ways to customize Google Chrome.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-enter-and-exit-full-screen-in-google-chrome/feed/ 0
How to Fix “Unable to connect to chat” on Google Chat https://www.online-tech-tips.com/google-softwaretips/how-to-fix-unable-to-connect-to-chat-on-google-chat/ https://www.online-tech-tips.com/google-softwaretips/how-to-fix-unable-to-connect-to-chat-on-google-chat/#disqus_thread Mahesh Makvana]]> Sun, 20 Aug 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=97683

Can’t access Google Chat? Does the site keep saying “Unable to connect to chat”? Your internet connection may be problematic, preventing you from connecting to this online service. There are […]]]>
Can’t access Google Chat? Does the site keep saying “Unable to connect to chat”? Your internet connection may be problematic, preventing you from connecting to this online service. There are other items that can cause this problem. We’ll show you how to fix those items so you can access your favorite online chat system.

Some reasons for loading Google Chat properly are that your web browser’s JavaScript feature is disabled, your browser app is outdated, your login session for the site has a problem, your browser extensions are faulty, and more.

Fix Your Internet Connection Problems

The most common reason you can’t access Google Chat is that your internet connection isn’t working. The connection may have suddenly stopped working, causing you to be unable to load your site.

In this case, check your network connection’s status by opening a new tab in your web browser and launching a non-Google Chat site. If your browser doesn’t load the site, your internet connection is the culprit.

You can try to fix your connection issues by restarting your router. If that doesn’t work, contact your internet service provider (ISP) for help.

Hard-Refresh Google Chat’s Site in Your Web Browser

If your internet connection is working, the next fix to apply is to hard-reload the Google Chat site in your web browser. Doing so overrides your browser’s saved cache content, allowing you to load the site from scratch. This helps fix the issue if a bad cache caused it.

You can hard-refresh a site in your web browser by pressing and holding down the Shift button and selecting the refresh icon beside the address bar.

You should be able to access your site and the site’s chat features when hard-refresh is finished.

Enable JavaScript in Your Web Browser

One reason Google Chat fails to load is that your web browser’s JavaScript option is turned off. Many sites rely on this technology to function, and these sites can’t work correctly if the feature is disabled in your browser.

Luckily, it’s easy to turn on the feature in your various web browsers. We’ll show you how.

Google Chrome

  1. Open Chrome, select the three dots in the top-right corner, and choose Settings.
  2. Select Privacy and security in the left sidebar and Site settings on the right pane.
  3. Scroll down and choose JavaScript.
  4. Select Sites can use Javascript to turn on the feature.
  1. Open Google Chat in your browser.

Mozilla Firefox

  1. Open Firefox, enter the following in the address bar, and press Enter:
    about:config
  2. Select Accept the Risk and Continue.
  3. Type the following in the search box and press Enter:
    javascript.enabled
  4. Select the toggle next to that entry and ensure the value says true. This indicates the feature is enabled.
  1. Access Google Chat in your browser.

Microsoft Edge

  1. Launch Edge, select the three dots in the top-right corner, and choose Settings.
  2. Select Cookies and site permissions in the left sidebar.
  3. Choose JavaScript on the right pane.
  4. Enable the Allowed (recommended) option at the top.
  1. Open Google Chat in your web browser.

Update Your Web Browser and Use Google Chat

Outdated web browser versions are often the reason you can’t access your sites. You may be using an old version of a browser on your computer. This version may likely have many bugs, causing the sites to be unable to load correctly.

In this case, you can update your web browser to fix your issue.

Google Chrome

  1. Select the three dots in Chrome’s top-right corner and choose Help > About Google Chrome.
  1. Let Chrome check for and install the latest updates.
  2. Restart your browser to bring your updates into effect.

Mozilla Firefox

  1. Select the three horizontal lines in Firefox’s top-right corner and choose Help > About Firefox.
  1. Allow the browser to find and install the latest updates.
  2. Close and reopen your browser to bring your changes into effect.

Microsoft Edge

  1. Open Edge, select the three dots in the top-right corner, and choose Help and feedback > About Microsoft Edge.
  1. Wait for Edge to find and install the latest updates.
  2. Restart your browser when the updates are installed.

Sign Out and Back Into Your Google Account on the Chat Site

Sometimes, an issue with your login session causes your site not to load. This may be why you can’t access Google Chat in your browser. You can try to fix that issue by logging out and back into your account on the site.

  1. Open Google Chat in your browser. Use Google.com if the Chat site doesn’t open.
  2. Select your profile icon in the site’s top-right corner.
  3. Choose Sign out or Sign out of all accounts, depending on how many accounts you’ve linked to your browser.
  1. Relaunch Google Chat and sign back into your account.

Clear Google Chat’s Cookies and Site Data in Your Web Browser

Your web browser saves cookies and various other items when you access a site. When you have trouble loading a site, it’s a good idea to clear this saved content to possibly fix your issue.

Google Chrome

  1. Open Google Chat in your browser.
  2. Select the padlock icon beside the address bar and choose Site settings.
  3. Select Clear data to clear the site’s data in your browser.
  1. Launch Google Chat in a new tab.

Mozilla Firefox

  1. Access Google Chat in your Firefox browser.
  2. Select the padlock icon to the left of the address bar and choose Clear cookies and site data.
  1. Select Remove in the prompt to delete the site’s saved data in your browser.
  2. Open Google Chat in a new Firefox tab.

Microsoft Edge

  1. Open Edge, select the three dots in the top-right corner, and choose Settings.
  2. Select Cookies and site permissions on the left and Manage and delete cookies and site data on the right.
  3. Select See all cookies and site data.
  4. Type chat.google.com in the Search cookies box, select Remove all shown, and choose Clear in the prompt. Repeat this step by searching google.com.
  1. Access Google Chat and log in to your account.

Turn Off Your Web Browser Extensions

If you still get an “Unable to connect to chat” error on Google Chat, an extension installed in your web browser may be causing the issue. Sometimes, your browser extensions get corrupted or become broken for various reasons, causing your sites not to load correctly.

You can verify and fix that by turning off all your browser extensions and re-enabling one extension at a time to find the culprit. You can then remove the culprit item to resolve your issue.

Google Chrome

  1. Select Chrome’s three dots in the top-right corner and choose Extensions > Manage Extensions.
  2. Disable the toggles for all your extensions.
  1. Access the Google Chat site. If the site loads, re-enable one extension at a time to find the culprit. Then, remove the faulty extension.

Mozilla Firefox

  1. Select Firefox’s three horizontal lines in the top-right corner and choose Add-ons and themes.
  2. Turn off the toggles for all your add-ons.
  1. Open Google Chat in your browser. If the site opens, re-activate one add-on at a time to find the faulty one. Then, remove the faulty add-on from your browser.

Microsoft Edge

  1. Open Edge, select the three dots in the top-right corner, and choose Extensions > Manage extensions.
  2. Deactivate all your installed extensions.
  1. Launch the Google Chat site. If the site opens, re-enable one extension at a time to find the broken one. Then, remove the broken extension from your browser.

Troubleshooting Google Chat App’s Issues to Resume Your Online Conversations

Google Chat’s access errors prevent you from loading and replying to your online chat messages. If your issues persist and you can’t access the site, the methods offered above should help you fix your problem. These solutions fix the very items that may be causing your error, letting you regain access to your favorite chat platform.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-fix-unable-to-connect-to-chat-on-google-chat/feed/ 0
How to Use Mail Merge in Gmail https://www.online-tech-tips.com/google-softwaretips/how-to-use-mail-merge-in-gmail/ https://www.online-tech-tips.com/google-softwaretips/how-to-use-mail-merge-in-gmail/#disqus_thread Sandy Writtenhouse]]> Sun, 13 Aug 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=97571

When you want to send the same email to your customers, clients, employees, club members, or a similar group, you can type an email once and message everyone using the […]]]>
When you want to send the same email to your customers, clients, employees, club members, or a similar group, you can type an email once and message everyone using the Gmail mail merge tool.

Once dubbed the “multi-send” feature, mail merge in Gmail lets you insert Google Contacts or a mailing list from Google Sheets. Then, personalize your email message with merge tags, include unique unsubscribe links, and enjoy a simple bulk email process using your favorite email application.

About Mail Merge in Gmail

Let’s take a look at the Google account requirements, sending limits, and other details surrounding mail merge in Gmail.

  • Mail merge is available to Google Workspace subscribers including Workspace Individual, Business Standard and Plus, Enterprise Starter, Standard, and Plus, and Education Standard and Plus.
  • Supported Google Workspace accounts have a daily limit of 2,000 outgoing emails. With mail merge, you’re allowed to email up to 1,500 recipients which leaves you 500 for other emails.
  • You can only add one recipient to the CC or BCC field using mail merge. Just keep in mind that this sends an email to that address for each recipient in the To field. For example, if you send a mail merge to 100 recipients, the address in the CC field receives 100 copies of that email.
  • You can include attachments using mail merge; however, this counts toward your storage space. For instance, if you send a 1MB attachment to 100 recipients, you’ll use 100MB of space.
  • Each message contains a unique auto-generated Unsubscribe link at the bottom in case that particular recipient no longer wants to receive your emails.
  • If a recipient has previously unsubscribed from your messages and you include them in a mail merge, you’ll see a notification after you send the email with the number of recipients who won’t receive the message.
  • You cannot use mail merge for replies or forwards or when you schedule emails or use confidential mode.

How to Add Recipients to Mail Merge in Gmail

While you can select the recipients for your email after you compose your message, it’s best to select them beforehand when using mail merge. This then prompts you with the available merge tags to personalize the message.

Add Recipients From Google Contacts

To get started using your Google Contacts as recipients, follow these steps.

  1. Choose Compose on the top left to create a new email. Use the Show main menu icon (three lines) if you don’t see Compose.
  1. In the Compose window, select the Use mail merge icon (contact symbol) on the far right of the To field and check the box for Mail Merge.
  1. You can then begin typing the names of your recipients and select them from the suggestions or select the To link and choose recipients from the Select Contacts window.

Add Recipients From Google Sheets

To insert recipients from Google Sheets, begin by making sure your sheet is set up correctly.

  • All recipient information must be on the first tab of the spreadsheet.
  • Each recipient and their details must be in a separate row.
  • Use text-only column headers to designate the merge tags. If a header contains a special character, the merge tag is identified by the column letter instead, for example, @A for column A.

If your sheet is ready to go, choose Compose on the top left in Gmail to create the message.

  1. Select the Use mail merge icon on the far right of the To field and check the box for Mail Merge. Then, select Add from a spreadsheet.
  1. In the window that appears, use the Google Drive tabs at the top to locate and choose the Google Sheet. Then, select the Insert button on the bottom right.
  1. In the subsequent window, use the drop-down boxes to choose the column names containing the recipients’ details for the merge tags. Note that you may only see drop-down boxes for Email, First Name, and Last Name; however, you will see merge tags available in the email for the other details in your sheet.
  1. Select Finish and you’ll return to the Compose window with the name of the sheet in the To field.

Tip: If your recipient list is in Excel, look at ways to convert the Excel file to Google Sheets for the mail merge.

How to Use Merge Tags in Your Email

Once you have your recipients added to the mail merge, you’ll have the merge tags available to use.

As of this writing:

  • If you add recipients from Google Contacts, you can use tags for first, last, or full name as well as email address.
  • If you add recipients from Google Sheets, you can use tags for the column headers in your spreadsheet.

Add a Merge Tag

To add a tag to your email, type the @ (At) symbol with the tag name or select the tag from the drop-down list that appears.

You can add the tags to most anyplace in your message except for the email subject line and within hyperlinked text.

Preview a Merge Tag

If you’re curious how the details display after inserting a merge tag, you can easily see a preview.

  1. Hover over a merge tag in your message and select Preview.
  1. You’ll then see a window appear showing each recipient and their corresponding detail for that tag. If you have many recipients, you can use the Search at the top to find them.
  1. Select OK when you finish, and you’ll return to the Compose window.

Include a Default Value for a Merge Tag

You can also set default values to the merge tags. This is helpful if a recipient is missing the detail you’re trying to add. For example, if you insert the First Name merge tag and a recipient doesn’t have a first name listed, you can use a default word or phrase instead.

To add a default value, hover over the merge tag in your email and choose Set default value.

Add the word or phrase in the box that appears and select Save.

For any recipient missing the information, the merge tag in the email will be replaced with the default value.

Preview and Send Your Email

When you finish creating your mail merge in Gmail, you’ll be able to preview the email before you send it. This allows you to see the email as your recipients will so that if you need to make any changes, you can do so before hitting the Send button.

  1. When you’re ready, select Continue at the bottom of the Compose window.
  1. You’ll see a pop-up message with brief details about junk mail when sending mass emails. Select Learn more for additional information and then Got it to continue.
  1. Next, you’ll see another pop-up window showing you the number of recipients you’re sending the email to and an option to see a preview. Select Send preview.

You’ll receive an email labeled “Test message” to your inbox within a few minutes. The merge tags will be populated with the first recipient on your list or the default value if applicable.

Once you review the preview, you can return to the Compose window to make any adjustments you like. When you’re ready to send the email, follow these same steps and choose Send all in the Ready to Send window.

You can find the mail merge emails you send in your Sent folder like any other email sent.

Make Emails Easy With Gmail Mail Merge

When you need to send a newsletter, announcement, or other email to a mass, remember the mail merge functionality in Gmail. With the ability to insert contacts from Google Sheets, use merge fields for personalized emails, and preview the message before you send it, all without a third-party mail merge add-on, the process couldn’t be easier.

For related tutorials with other apps, look at how to create a mail merge in Microsoft Word for printed messages rather than email marketing.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-use-mail-merge-in-gmail/feed/ 0
How to Transcribe Google Meet Calls Into Google Docs https://www.online-tech-tips.com/google-softwaretips/how-to-transcribe-google-meet-calls-into-google-docs/ https://www.online-tech-tips.com/google-softwaretips/how-to-transcribe-google-meet-calls-into-google-docs/#disqus_thread Sandy Writtenhouse]]> Wed, 09 Aug 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=97462

While meeting notes are great for capturing details of what’s discussed, a meeting transcription is even better. With it, you can see the date and participants but also who said […]]]>
While meeting notes are great for capturing details of what’s discussed, a meeting transcription is even better. With it, you can see the date and participants but also who said what during your meeting.

Using Google Workspace, you can transcribe Google Meet calls into Google Docs easily. From there, simply open the document, download it, or share it with those who couldn’t attend.

About Google Meet Transcriptions

Before you get started with transcriptions in Google Meet, please review the following requirements and details.

  • You must have a supported Google Workspace edition: Business Standard or Plus, Enterprise, Teaching and Learning Upgrade, or Education Plus.
  • You can only use the feature in Google Meet on your desktop or computer, not the mobile app.
  • The transcription feature is enabled in Google Workspace by default; however, you’ll need to start it for each meeting (described below).
  • To allow others to use the transcription feature, you must turn on Google Drive and grant permission to create new files in Drive for those users. Sign into the Google Admin console and go to Apps > Google Workspace> Drive and Docs to review or enable these settings.
  • Transcriptions automatically save to the Meet Recordings folder in Google Drive, so you must have enough available storage space in Drive for the transcriptions.
  • The meeting organizer, transcription initiator, and meeting hosts automatically have access to edit the transcription document. However, if the meeting has fewer than 200 invitees, everyone has Edit access.

Start Transcription During a Google Meet Meeting

When you’re ready to transcribe a meeting in Google Meet, it takes only a few steps to start. You might also consider letting your participants know before the meeting begins that you’ll be transcribing it.

  1. Select the Activities icon (shapes) in the lower right corner and pick Transcripts in the sidebar that displays.
  1. Choose Start transcription on the subsequent screen.
  1. Read the details in the pop-up window regarding notifying participants that you’re transcribing the meeting and select Start to continue.
  1. When your participants land on the screen to join the meeting, they’ll see a message that the call is being transcribed.
  1. Additionally, everyone should see the Transcription icon on the top left of the meeting window.

To stop the transcription at any time during the meeting, select the Activities > Transcripts and choose Stop transcription.

You do not have to stop the transcription when the meeting ends. You can simply leave the meeting as normal and the transcript saves automatically.

Access Google Meet Transcripts

You have a few different ways to access the Google Meet transcript. You can open it using the email link, calendar event, or directly in Google Drive or Google Docs.

Here are a couple of things to keep in mind:

  • In most cases, you can access the transcript within a few hours after the meeting ends; however, it can take up to 24 hours.
  • Remember that the transcript is computer generated, so you may see minor errors.

Access the Transcript Via Email

After the meeting, you’ll receive an email to your connected Gmail account with the transcript as will the host, co-host, and transcript initiator. You can then either select the attachment or the link to open the transcript in Google Docs.

Access the Transcript in Google Calendar

If the meeting was organized using Google Calendar, the transcript is conveniently attached to the calendar event with the same name as the event.

If you select the meeting on the main Google Calendar page, you’ll see the transcript in the Attachments section.

If you open the event detail page, you’ll see the transcript attached to the Description section.

Choose the attachment to open the transcript in Google Docs.

Note: For recurring meetings, the transcription is attached to the calendar event each time.

Access the Transcript in Google Drive

You can also visit Google Drive to open the transcript document. If you didn’t organize the meeting through Google Calendar, the file name will be the meeting code with the date and time.

When you sign into Google Drive, you may see the transcript in the Suggested section at the top of My Drive.

Alternatively, open the Meet Recordings folder and select the transcript to open it in Google Docs.

You can also use the Search feature or one of these ways to find a file in Google Drive.

Access the Transcript in Google Docs

Finally, you’ll see the transcript right in Google Docs and can open it from there too.

Sign into Google Docs and you’ll see the transcript at the top when you sort by date.

If you prefer, you can use the Search box at the top. Enter “transcript” and choose the document from the results.

Disable Transcriptions in Google Workspace

If you want to disable the transcription feature later, you can turn it off if you have any of the supported Google Workspace plans except for Business Standard.

Sign into the Google Admin console and go to Apps > Google Workspace > Google Meet.

Open the Meet video settings and select Meeting transcripts to turn off the feature.

When you want to log everything said during a meeting, keep in mind that you can transcribe Google Meet calls into Google Docs in just a few steps. The transcribed file makes an excellent reference for everyone.

For more, look at how to record a Google Meet.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-transcribe-google-meet-calls-into-google-docs/feed/ 0
Google Chromecast Remote Not Working? 7 Fixes to Try https://www.online-tech-tips.com/google-softwaretips/google-chromecast-remote-not-working-7-fixes-to-try/ https://www.online-tech-tips.com/google-softwaretips/google-chromecast-remote-not-working-7-fixes-to-try/#disqus_thread Sodiq Olanrewaju]]> Sat, 29 Jul 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=97292

Does your Chromecast with Google TV fail to respond to its remote control? Do some remote buttons work while others perform no function? We’ll show you several ways to troubleshoot […]]]>
Does your Chromecast with Google TV fail to respond to its remote control? Do some remote buttons work while others perform no function? We’ll show you several ways to troubleshoot the Chromecast Voice Remote and get it working again.

1. Use Your Phone as Virtual Remote

The Google Home app has a built-in virtual Chromecast remote control. Use the Google Home app to navigate your Chromecast if the physical remote isn’t working.

Connect your smartphone to the same Wi-Fi network as your Chromecast and follow the steps below.

  1. Install Google Home on your Android or iOS smartphone and sign into the Google account linked to your Chromecast.
  2. The app should automatically detect your Chromecast if it’s on the same Wi-Fi network as your phone. Head to the Devices tab and select your Chromecast.

Tap the Add button to manually link your Chromecast if the Google Home app doesn’t detect it automatically.

  1. Tap Remote (iOS) or Open remote (Android) to launch the Chromecast virtual remote.

The Google Home app will display the virtual remote control on your phone screen.

You can customize the virtual remote to use Swipe or D-pad navigation control. Tap the three-dot menu icon in the top-right corner and select Swipe control or D-pad control.

2. Check Battery Status or Replace Batteries

Your Chromecast remote won’t work if its batteries are dead or inserted incorrectly. Check the battery level of your Voice Remote in the settings menu.

Open the virtual Chromecast remote in the Google Home app and follow the steps below.

  1. Select your profile picture/icon in the top-right corner and select Settings.
  1. Choose Remotes & Accessories.
  1. Check the Battery level of your Chromecast Remote in the “Chromecast Voice Remote” section. Reinsert or change your Chromecast Remote batteries if the battery level/status isn’t “Good.”

Open your Voice Remote’s back cover and check that the batteries are secure and fitted correctly. Align the battery polarities—positive(+) and negative(-) sides—in line with the inscription in the battery compartment. The LED light on the Chromecast Voice Remote should pulse twice when you reinsert the batteries.

Insert two new 1.5 Volts AAA alkaline batteries in your Voice Remote if the LED light doesn’t flash. Ensure you replace both batteries, not one—the issue might persist if you mix old and new batteries.

3. Update Your Chromecast Remote

The Chromecast Voice Remote might malfunction if its firmware needs to be updated. Use the Google Home app virtual remote to check if there’s an update available for your remote.

  1. Select your profile icon in the top-right corner and select Settings.
  1. Choose Remotes & Accessories.
  1. If there’s an “Update available” message below your Chromecast Remote, select the remote to install the update.
  1. Select Remote update to proceed.
  1. Select Continue to start the remote software update.
  1. Updating the remote unpairs it from your Chromecast. Select Connect after the update to re-pair the remote.
  1. Select Yes to continue.

4. Reset or Re-Pair Your Chromecast Remote

Resetting your Chromecast’s remote can get it working correctly again. Follow the steps below to reset a Chromecast Voice Remote to factory default.

  1. Open the remote’s back cover, remove both batteries, and wait five minutes.
  2. Press and hold the Home button on the remote.
  1. Reinsert both batteries in the remote while holding the Home button. The remote’s LED light will come on and stay solid.
  2. Release the Home button when the LED light starts flashing/pulsing.

The remorse should automatically pair with your Chromecast after the reset. If it doesn’t, or the LED light keeps flashing, pair the remote manually using the virtual remote in the Google Home app.

  1. Go to Settings > Remotes & Accessories > Pair remote or accessory.
  1. Press and hold the Home and Back buttons on your Chromecast Voice Remote. That’ll put the remote in pairing mode and make it discoverable.
  1. Select the remote when it appears on your TV screen.

5. Reboot Your Chromecast

Performing a system reboot can fix glitches with your Chromecast and Chromecast Voice Remote. You can reboot your Chromecast from the Google TV settings or by reconnecting the streaming device to its power source.

Reboot Chromecast from the Settings Menu

  1. Select your profile picture/icon in the top-right corner of your screen and select Settings.
  1. Choose System on the sidebar and select Restart.
  1. Select Restart again on the confirmation pop-up to reboot your Chromecast device.

Perform a Hard Reboot

Unplug your Chromecast from its power source, wait 1-2 minutes, and reconnect the power cable.

Update your Chromecast’s software if the remote still malfunctions after the reboot.

6. Update Your Chromecast

Google recommends installing updates to your Chromecast to enjoy the latest features and troubleshoot system glitches.

Use the virtual remote in the Google Home app to update your Chromecast software to the latest version.

  1. Select your profile icon on your Chromecast Home Screen and select Settings.
  2. Select System on the sidebar.
  3. Next, select About.
  4. Select System update and wait while your Chromecast scans for available updates.
  1. You’ll see a “System update ready” message if there’s an update for your device. Select Install to start the software update process.
  1. Select Restart now to install the update.

Perform a factory reset if the remote still doesn’t work after updating your Chromecast’s software.

7. Reset Your Chromecast

Factory resetting your Chromecast deletes downloaded apps, files, settings, and accounts. We recommend resetting your Chromecast only when the troubleshooting fixes above fail to fix the remote malfunction.

You can reset your Chromecast from the Google Home app or with the physical button on the streaming device.

Factory Reset Chromecast Using Virtual Remote

Open the virtual Chromecast remote in the Google Home app and follow the step below.

  1. Select your profile picture in the top corner and select Settings.
  2. Go to System > About and select Factory reset.
  1. Select Factory reset on the confirmation page to proceed.

Factory Reset Chromecast Using Physical Button

Keep your Chromecast plugged into its power source and turned on. Hold down the physical button at the back of the streaming device.

Release the button when the LED blinks yellow and then turns solid white. Your Chromecast should restart and automatically pair with the remote after the factory reset.

Fix Google Chromecast Remote

Contact Google Support if your Chromecast Voice Remote doesn’t work after trying all the recommendations above. You’ll get a replacement Voice Remote if the one you have has a factory defect. You can also purchase a replacement remote from Google Store or Amazon for $19.99.

]]>
https://www.online-tech-tips.com/google-softwaretips/google-chromecast-remote-not-working-7-fixes-to-try/feed/ 0
How to Insert Variable Smart Chips (Placeholders) in Google Docs https://www.online-tech-tips.com/google-softwaretips/how-to-insert-variable-smart-chips-placeholders-in-google-docs/ https://www.online-tech-tips.com/google-softwaretips/how-to-insert-variable-smart-chips-placeholders-in-google-docs/#disqus_thread Sandy Writtenhouse]]> Tue, 25 Jul 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=97197

If you’ve ever created a document where you used text placeholders, you’ll appreciate this Google Docs feature. Using a Variable Smart Chip, you can insert a placeholder, assign its value, […]]]>
If you’ve ever created a document where you used text placeholders, you’ll appreciate this Google Docs feature. Using a Variable Smart Chip, you can insert a placeholder, assign its value, and automatically update it throughout the document.

Instead of hassling with add-ons or third-party apps, you can improve your workflow when creating various types of documents with the Variable Smart Chip functionality.

Note: As of this writing, the Variable Smart Chip is available to Google Workspace Business Standard and Plus, Enterprise Standard and Plus, Education Plus, and Nonprofit customers. Hopefully, Google will bring the feature to personal Google accounts at some point.

About Variable Smart Chips

As mentioned, the Variable Smart Chip is a text placeholder that you can insert in your document. This is ideal for text you want someone else to add like first or last name, address, or phone number. You can also use Variables for things you need to add but are waiting for like a product title, date, or website address.

Whether you use Variables for yourself or another you’re sharing with, they allow you to create your document and add those items later.

Once you add a Variable, you can assign its value, the text, at any time. Then, every spot you use the Variable in the document updates with that value.

Let’s look at how to insert and use Variables in Google Docs with a couple of examples.

How to Insert a Variable Smart Chip

To add a Variable Smart Chip to your document, follow these simple steps.

  1. Place your cursor where you want it and then do one of the following:
  2. Select Insert > Smart chips and choose Variables in the pop-out menu.
  3. Type the @ (At) symbol and choose Variable from the drop-down menu.
  1. In the small window that appears, select Insert new variable.
  1. Give your Variable a name in the subsequent pop-up window. You can also use the default naming convention, Variable 1, Variable 2, and so on. Select Create.
  1. You’ll then see the Variable with its name in your document and in the Variables sidebar that opens on the right.

You can add more Variables for other items to your document the same way. Just keep in mind that the additional Variables should be used for different items. For example, you can create one Variable for name and a second Variable for address.

Reuse a Variable Smart Chip

The purpose of the Variable is to place it in your document where you need it and then update it with its value when you’re ready.

To insert the same Variable in another location, do one of the following:

  • Select Insert > Smart chips, choose Variables, and pick the Variable name from the pop-up list.
  • Type the @ (At) symbol, choose Variable, and pick the Variable name from the pop-up list.
  • Open the Variables sidebar, hover over the Variable you want to use, and select Insert.

Assign a Value to a Variable

Once you add a Variable to your document, you can assign its value at any time. The value is the text you want to use. You can do this in the Variable itself or in the sidebar.

Add Text Using the Variable

To assign a value to the Variable in-place, select the Variable and enter the text you want to use. This automatically saves the value to that Variable.

Add Text Using the Sidebar

To assign a value in the Variables sidebar, either select the Variable and use the Open in sidebar icon in the toolbar that appears or go to Tools > Variables in the menu.

Select No value below the Variable name. You’ll see the Variable in your document empty and ready for you to enter the text. Once you do, use Enter or Return to save it.

After you assign a value to your Variable, you’ll see this update in every location you place the Variable in your document, which is the intent of the Smart Chip.

Rename a Variable

Because the default names for Variables are not obvious, you may want to give them more meaningful names. This is especially helpful if you create several Variables for your document.

Open the Variables sidebar, hover your cursor over the Variable you want to rename, and select the Edit name icon (pencil).

When the rename pop-up appears, give it a new name and select Save.

You’ll then see the updated name in the sidebar, list of variables to insert, and inside the Variable itself until you assign its value.

Remove a Variable

If you decide you no longer want to use a Variable, you can delete it. Keep in mind that this will remove the Variable, and its value if assigned, from every location in your document.

Open the Variables sidebar, hover your cursor over the Variable you want to remove, and select the Delete variable definition icon (trash can).

In the confirmation pop-up, select Delete to remove the Variable.

Example Uses for Variables in Google Docs

If you’re wondering how to use Variables for your own purposes, we have a couple of examples.

Marketing Copy

Here, we’re creating a document for our client’s new product. We don’t have the product name or the website address yet, so we insert Variables for those two items instead. With the Variables sidebar open, you can see them with blue borders throughout the text.

Once our client provides us these details, we simply assign the values to the Variables and our document automatically updates. Those variables then display the text and gray borders.

When you close the Variables sidebar, you’ll notice those Variables look just like the rest of the text without any borders.

Shared Documents

In this next example, we have a document we want someone else to complete with their details. We set up Variables for first name, last name, address, phone number, and date.

When we share the document, the recipient simply selects each Variable and enters their information. The Variables that are used more than once update automatically.

We then have our completed document where the Variables appear like any other text.

Note: If you share a document using Variables with more than one person, the assigned values will update with each change. To avoid this, you may ask each of your recipients to make a copy for their changes.

Save Time, Minimize Errors, and Organize

Google has introduced several new Smart Chips in the last year since the introduction of the Smart Canvas feature. You can add a calendar event using a Date chip, link to a file name with the File chip, and include contact details with the People chip.

Now, you can save time from typing the same text over and over as well as reduce the risk of typos and organize your document using the Variable Smart Chip in Google Docs. Keep this handy feature in mind for your next document.

For more ways to save time in Google apps, look at how to use a drop-down list in Google Sheets.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-insert-variable-smart-chips-placeholders-in-google-docs/feed/ 0
10 Hidden Google Sheets Features You Didn’t Know Existed https://www.online-tech-tips.com/google-softwaretips/10-hidden-google-sheets-features-you-didnt-know-existed/ https://www.online-tech-tips.com/google-softwaretips/10-hidden-google-sheets-features-you-didnt-know-existed/#disqus_thread Sandy Writtenhouse]]> Mon, 24 Jul 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=97174

If you use Google Sheets regularly, you’re probably familiar with those tools you use often. However, there are many features of this spreadsheet application that go unnoticed and underused. Here, […]]]>
If you use Google Sheets regularly, you’re probably familiar with those tools you use often. However, there are many features of this spreadsheet application that go unnoticed and underused.

Here, we’ll walk through several cool Google Sheets features that might just become your fast favorites. Head to Google Sheets, sign in with your Google account, and try out some of these hidden gems.

1. Extract Data From a Smart Chip

If you’ve taken advantage of the Smart Chips in Google’s apps, then you’ll be happy to know you can do even more with them. After you insert a Smart Chip, you can extract data from it and place it in your sheet, making chips even more useful.

You can currently extract data from People, File, and Calendar Event Smart Chips. This includes name and email, owner and filename, and summary and location.

  1. After you insert a Smart Chip, hover your cursor over it, select it, or right-click. Then, choose Data extractions.
  1. When the sidebar opens, use the Extract tab to mark the checkboxes for those items you want to extract.
  1. Use the Extract to field to enter or select the sheet location where you want the data.
  1. Pick Extract and you’ll see your data display in your selected location.

If you need to refresh the extracted data, you can use the Refresh & manage tab in the sidebar.

2. Create a QR Code

QR codes are popular ways to share information, direct people to your website, and even provide discounts. By creating your own QR code in Google Sheets without add-ons or third-party tools, you or your collaborators can quickly take action.

To make the QR code, you’ll use the Google Sheets IMAGE function and a link to Google’s root URL: https://chart.googleapis.com/chart?.

Here, we’ll link to the website in cell A1 using the formula below. Place the formula in the cell where you want the QR code.

=IMAGE(“https://chart.googleapis.com/chart?chs=500×500&cht=qr&chl=”&ENCODEURL(A1))

Use the following arguments to build your formula:

  • CHS argument: Define the dimensions of the QR code in pixels (chs=500×500).
  • CHT argument: Specify a QR code (cht=qr).
  • CHL argument: Choose the URL data (chl=”&ENCODEURL(A1)).

Then, use the ampersand operator (&) to connect the arguments.

Once you see the code, you may need to resize the row and/or column to view its full size. Then, scan the QR code to make sure it works as you expect.

You can also use optional arguments for encoding the data in a particular way or assigning a correction level. For more on these arguments, check out the Google Charts Infographics reference page for QR codes.

3. Insert a Drop-Down List

Drop-down lists are terrific tools for data entry. By selecting an item from a list, you can make sure you’re entering the data you want and can reduce errors at the same time.

Since the introduction of drop-down lists in Sheets, the feature has been enhanced to give you a simpler way to create and manage these helpful lists.

  1. Insert a drop-down list by doing one of the following:
  2. Select Insert > Dropdown from the menu.
  3. Right-click and choose Dropdown.
  4. Type the @ (At) symbol and choose Dropdowns in the Components section.
  1. You’ll then see the Data Validation Rules sidebar open. Enter the location for the list in the Apply to range box and confirm that Dropdown is selected in the Criteria drop-down menu.
  1. Then, add your list items in the Option boxes and optionally select colors for them to the left.
  1. To display help text, pick the action for invalid data, or choose the display style, expand the Advanced Options section.
  1. When you finish, select Done. Then, use your new drop-down list to enter data in your sheet.

4. Validate an Email Address

When you have a spreadsheet that contains email addresses, whether Gmail, Outlook, or something else, you may want to make sure they’re valid. While Sheets doesn’t show you if an address is legitimate, it does show you if it’s formatted correctly with the @ (At) symbol and a domain.

  1. Select the cell(s) you want to check and go to Data > Data validation in the menu.
  1. When the Data Validation Rules sidebar opens, select Add rule, confirm or adjust the cells in the Apply to range field, and choose Text is valid email in the Criteria drop-down box.
  1. Optionally select the Advanced Options such as showing help text, displaying a warning, or rejecting the input. Pick Done to save and apply the validation rule.

You can then test the validation and options by entering an invalid email address.

5. Make a Custom Function

Are you a fan of using functions and formulas in Google Sheets? If so, why not create your own? Using the Custom Function feature, you can set up your own function and reuse it whenever you like.

  1. Select Data > Named functions from the menu.
  1. In the Named Functions sidebar that opens, use Add new function at the bottom to create your custom function. You can also look at an example, watch the demonstration, or find out more about the feature.
  1. Enter the function name, description, and optionally argument placeholders. Enter the formula you want to use to define the function and select Next.
  1. Check out the Function preview and either select Back to make changes or Create to save the new function. Notice you can also add optional arguments if necessary.
  1. You’ll then see the function in the sidebar list. Enter it into a cell in your sheet to test it out.

If you need to make edits, reopen the Named Functions sidebar, select the three dots to the right of the function, and pick Edit.

6. Use a Slicer to Filter a Chart

Charts give you handy and effective ways to display your data. Using a slicer, you can filter the data that displays in the chart. This is convenient for reviewing specific portions of the chart data when needed.

Insert a Slicer

After you insert your chart, select it and go to Data > Add a slicer in the menu.

When the sidebar opens, open the Data tab, confirm the Data Range at the top, and then pick the Column to use for the filter.

You’ll see the slicer appear as a black rounded rectangle which you can move or resize as you please.

Use a Slicer

Once you have your slicer, select the Filter button on the left or drop-down arrow on the right. Then, select the data you want to see in the chart which places checkmarks next to those items.

Select OK and you’ll see your chart update immediately.

To return your chart to the original view showing all data, open the filter and pick Select all > OK.

7. Quickly Calculate Data

Sometimes you want to see a quick calculation without adding a formula to your sheet. In Google Sheets, you can simply select the values and then choose a calculation to view without any extra work.

  1. Select the data you want to calculate and then look on the bottom right of the tab row. You’ll see the calculation menu in green which contains the Sum of your data.
  1. Open that menu and choose the calculation you want to perform. You’ll see the new result in that menu.
  1. You can also simply open the menu to see all available calculations in real-time.

If you decide to include the calculation in your sheet, keep the cell selected and choose Explore to the right of the sheet tabs.

When the sidebar opens, drag the calculation you want to use to a cell in your sheet.

8. Explore Ways to Present Your Data

Maybe you have data in your spreadsheet but aren’t sure of the best way to display or analyze it. With the Explore feature, you can see various quick ways to present your data, review details about it, and ask questions.

Select your data and pick Explore on the bottom right.

When the Explore sidebar opens, you’ll see options for your data. Type a question in the Answers section, apply color using the Formatting section, or insert a chart from the Analysis section.

After you finish, simply use the X on the top right of the sidebar to close it.

9. Request Sheet Approvals

If you use a Google Workspace account for business or education, check out the Approvals feature. With it, you can request approvals from others and keep track of what’s approved and what isn’t.

Go to File and select Approvals.

When the Approvals sidebar opens, choose Make a request.

In the pop-up window, add those you want to approve your request and optionally a message. You can also include a due date, allow the approvers to edit the sheet, or lock the file before sending your request for approval. Choose Send request when you finish.

If you haven’t shared the document with the approvers already, you’ll be asked to do so and assign the permissions.

You can then view the status by returning to the Approvals sidebar.

10. Set Up a Custom Date and Time Format

While Google Sheets provides many different ways to format your dates and times, maybe you want something in particular. You can create your own date and time format with the structure, colors, and style you want.

  1. Select the cell(s) containing the date or time and go to Format > Number > Custom date and time. Alternatively, you can select the More Formats option in the toolbar and pick Custom date and time.
  1. When the window opens, you’ll see the current format for your date and/or time. Select an existing element at the top to change the format or delete it.
  1. To add a different element, select the arrow on the right side and choose one from the list. You can then format that element using its arrow.
  1. When you finish, select Apply to use the custom date and time format and you should see your sheet update.

With these Google Sheets features, you can do even more with your data. Be sure to try one or more and see which come in handy for you.

For related tutorials, look at how to find duplicates in Google Sheets using the conditional formatting options.

]]>
https://www.online-tech-tips.com/google-softwaretips/10-hidden-google-sheets-features-you-didnt-know-existed/feed/ 0
How to Pause or Cancel Google Play Subscriptions https://www.online-tech-tips.com/google-softwaretips/how-to-pause-or-cancel-google-play-subscriptions/ https://www.online-tech-tips.com/google-softwaretips/how-to-pause-or-cancel-google-play-subscriptions/#disqus_thread Dilum Senevirathne]]> Sun, 23 Jul 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=97117

If you’ve been using your Android phone for some time, the chances are you’ve ended up subscribing to multiple apps and services from the Google Play Store. Left unchecked, these […]]]>
If you’ve been using your Android phone for some time, the chances are you’ve ended up subscribing to multiple apps and services from the Google Play Store. Left unchecked, these can add up and seriously strain your wallet.

Luckily, Google Play makes it easy to pause or cancel subscriptions, and this tutorial will walk you through the process. You’ll also learn how to request refunds for subscriptions on Google Play.

How to Cancel Google Play Subscriptions

If you’ve decided to discontinue a Google Play subscription permanently, just deleting the relevant app from your Android phone won’t suffice. Instead, you must visit Google Play’s Subscriptions management console and cancel the subscription.

Note: Despite canceling a subscription, you’ll have access to paid content until the end of the current billing period. For example, if you cancel halfway through a yearly subscription, you still have six months of access.

To cancel a subscription to Google Play:

  1. Open the Google Play Store and tap your profile picture on the top right of the screen.
  2. Select Payments & subscriptions. If you have multiple Google Accounts on your Android, tap the email address at the top and pick the correct account.
  3. Tap Subscriptions.
  1. Tap the subscription you want to cancel under the Active section.
  2. Tap Cancel subscription.
  1. Provide a reason and tap Continue.
  2. Tap Cancel subscription again as confirmation.

If you change your mind and want to re-subscribe before or after the subscription expires:

  1. Re-visit the Subscriptions management console and tap the subscription you want to re-subscribe.
  2. Tap Resubscribe.
  3. Review the subscription information and tap Resubscribe again to confirm.

How to Pause Subscriptions on Google Play

At times, you may want to temporarily halt a Google Play subscription without canceling it entirely. Pausing a subscription allows you to suspend payments for a specified period.

To pause a subscription on Google Play:

  1. Open the Google Play Store and tap your profile picture on the top right of the screen.
  2. Select Payments & subscriptions.
  3. Tap Subscriptions.
  1. Tap the subscription you want to pause under the Active section.
  2. Set the pause length.
  3. Tap Confirm.

To restart the subscription before it automatically resumes:

  1. Re-visit the Subscriptions management console and tap the subscription you want to resume.
  2. Tap Resume.
  3. Review the payment information and Resume again as confirmation.

How to Receive Refunds for Google Play Subscriptions

There are circumstances where you want a refund for a Google Play subscription. For example, it could be an accidental purchase, issues with the app or service, false advertising, etc.

Requesting a refund for a Google Play subscription depends on whether it’s been less or more than 48 hours since purchase.

  • You can request a refund from Google if it’s been less than 48 hours since you subscribed to the app or service.
  • You must contact the app developer for a refund if it’s been more than 48 hours since you subscribed to the app or service.

Before 48 Hours—Contact Google

To request a refund from Google:

  1. Open Google Chrome on your Android phone and visit the Request your Google Play refund page.
  2. Select Yes to confirm you’re signed in with the Google Account used to make the purchase, and tap Continue. If not, select No and log in with the correct account.
  1. Select the subscription you want to receive a refund for and tap Continue.
  2. Pick a reason for the refund and tap Continue. It’s best to be accurate with your selection—e.g., choosing I purchased this by accident may not work in your favor if you used the app several times before initiating your refund request.
  3. Tap Continue.
  4. Review your details and tap Request refund.

Refund requests take up to four days to process. You’ll receive an email if Google decides to approve or decline the refund. Visit the Check your Google Play refund status page to check the request’s status. If you receive a refund, the amount will be credited to the payment method you used to make the subscription—Google Play balance, credit card, etc.

After 48 Hours—Contact the Developer

To contact the developer for a refund, you must:

  1. Open the Google Play Store and visit the app’s store page.
  2. Scroll down and expand the Developer contact section.
  3. Reach out to the developer with the contact information.

How to Pause, Cancel, and Refund Subscriptions on Non-Android Devices

If you do not have access to your Android phone, don’t worry. You can pause, cancel, or refund subscriptions on any non-Android device via the web version of the Google Play Store. Here’s how:

  1. Visit the Google Play website and sign in with your Google Account credentials.
  2. Select your profile picture on the top-right corner and choose Payments & subscriptions.
  1. Switch to the Subscriptions tab.
  2. Tap Manage next to the subscription you want to pause or cancel.
  1. Select Cancel subscription or Pause payments.

If you want to initiate a refund for a subscription:

  • Visit the Request your Google Play refund page if it’s been less than 48 hours since making your payment.
  • Contact the developer—you can find the contact information on the app’s store page—to request a refund after 48 hours.

Take Control of Your Google Play Subscriptions

Knowing how to manage your Google Play subscriptions is essential to tailoring the digital experience on your Android device. Whether you want to pause a subscription, cancel it permanently, restart a paused or canceled subscription, or seek a refund when necessary, you have the power to take control.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-pause-or-cancel-google-play-subscriptions/feed/ 0
How to Transpose Rows and Columns in Google Sheets https://www.online-tech-tips.com/google-softwaretips/how-to-transpose-rows-and-columns-in-google-sheets/ https://www.online-tech-tips.com/google-softwaretips/how-to-transpose-rows-and-columns-in-google-sheets/#disqus_thread Sandy Writtenhouse]]> Wed, 05 Jul 2023 10:00:00 +0000 https://www.online-tech-tips.com/?p=96762

Have there been times you set up your spreadsheet and then realized that a different layout would work better? You can easily convert rows to columns or vice versa in […]]]>
Have there been times you set up your spreadsheet and then realized that a different layout would work better? You can easily convert rows to columns or vice versa in Google Sheets to display your data as you please.

With two ways to switch your rows and columns, you can use whichever is most comfortable for you. This includes the Paste Special feature and the TRANSPOSE function. If you’re ready to go, here’s how to use transpose in Google Sheets.

Convert Rows and Columns With Paste Special

A quick way to convert rows and columns is using the Paste Special feature in Google Sheets. With it, you simply copy the data and then paste it as transposed.

The nice thing about using this option is that if you have formatting like bold text or a fill color in your cells, that formatting applies to the pasted cells.

  1. Start by selecting the data you want to transpose. For example, we’ll convert our column of cities to a row.
  1. Copy the data by doing one of the following:
  • Select Edit > Copy from the menu.
  • Right-click and choose Copy.
  • Use the keyboard shortcut Ctrl + C on Windows or Command + C on Mac.
  1. Go to the cell where you want to paste the data, making sure you have enough space so that you don’t overwrite existing data.
  2. Either select Edit > Paste Special or right-click and move to Paste Special. Then, pick Transposed in the pop-out menu.

You should then see your selected cells pasted.

If you want to remove the original data after you paste it, you can delete it like any other data in your sheet.

Convert Rows and Columns With the TRANSPOSE Function

If you’re accustomed to using Google Sheets formulas, you can convert your rows or columns using the TRANSPOSE function and a simple formula.

Keep in mind that unlike the Paste Special feature above, existing text or cell formatting does not apply when you use the TRANSPOSE function.

The syntax for the formula is TRANSPOSE(range) with just one required argument for the range of cells you want to switch.

Go to the cell where you want the data transposed, making sure you have adequate space. Then, enter the following formula replacing the cell range with your own:

=TRANSPOSE(A2:G3)

Press Enter or Return and you should see your transposed data.

Again, you delete the original dataset after you use the TRANSPOSE formula to convert it if you like.

Convert Rows and Columns on Mobile

If you’re working with Google Sheets on your Android or iOS device, you can convert rows and columns there as well. While you can use the Paste Special feature or the TRANSPOSE function on Android, you can currently only use the function on iPhone.

Transpose on Android

To switch rows or columns on Android, open your Google Sheet and follow these simple steps to use Paste Special.

  1. Select the cells you want to transpose. You can drag through them using the blue dot on the bottom right corner. Then, tap to display the toolbar and choose Copy.
  2. Go to the cell where you want the converted rows or columns, tap, and select Paste special in the toolbar.
  1. When the Paste Special options appear, choose Paste transposed.

You’ll then see your converted rows or columns.

If you prefer to use the TRANSPOSE function on Android, follow the steps below as they are the same on iPhone.

Transpose on iPhone

As mentioned, you cannot use the Paste Special feature in Google Sheets on iPhone as of this writing. You can, however, use the TRANSPOSE function to switch your rows and columns.

  1. Go to the cell where you want the transposed cells.
  2. Type the formula into the text box at the bottom.
  3. Tap the green checkmark to apply the formula and you should see your converted rows or columns.

Converting rows to columns or the other way around is easy to do in Google Sheets. If you also use Microsoft Office, look at how to transpose data in Excel too!

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-transpose-rows-and-columns-in-google-sheets/feed/ 0
How to Remove Reading List From Google Chrome’s Bookmark Bar https://www.online-tech-tips.com/google-softwaretips/how-to-remove-reading-list-from-google-chromes-bookmark-bar/ https://www.online-tech-tips.com/google-softwaretips/how-to-remove-reading-list-from-google-chromes-bookmark-bar/#disqus_thread Paula Beaton]]> Thu, 29 Jun 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=96665

Older versions of Google Chrome had a Reading List in the Bookmarks Bar. While this was a handy way to save pages to read later, it took up precious space. […]]]>
Older versions of Google Chrome had a Reading List in the Bookmarks Bar. While this was a handy way to save pages to read later, it took up precious space.

In recent Chrome versions, this feature has been moved to the Sidebar, so it’s no longer an issue. However, if you’re running an older version of Chrome and want to free up space on your Bookmark bar, here’s how to remove the reading list from Chrome bookmark bar.

How to Remove Reading List from Chrome Bookmark Bar

There are a couple of different ways to remove the reading list from Google Chrome’s bookmark bar. The method to use depends on the version of Chrome you have installed. As mentioned above, if you’re running the most current version of Chrome, you’ll no longer see the Reading List option in the Bookmark Bar. Instead, you can click the Side Panel icon at the top right (it looks like a page with a shaded-out column) to open your Reading List.

Removing Reading List from Chrome 90 And Newer Versions

Chances are that most people reading this will be running a fairly recent version of Chrome, so if you’re unable to update to the latest version, but you’re running Chrome 90 — or a newer version that still has the Reading List visible — here’s how to remove the reading list from Chrome.

  1. Click the Reading List icon in the Bookmark Bar, or right-click the bar.
  2. From the drop-down menu, uncheck Show Reading List.
  3. It’s that simple, and now the Reading List should no longer show up in your Bookmark Bar.

Changed your mind? To bring it back, just head back into the menu and re-check the Show Reading List box.

Removing Reading List from Chrome 89 or Older Versions

If you’re running Chrome 89 or an older version of Google Chrome, things get a bit more complicated if you want to remove the Reading List from your Bookmark bar since there’s no official way to disable this. There is a workaround, though, and luckily it’s pretty easy to do. Below, we’ll walk you through how to remove Reading List from Chrome Bookmark bar in older versions of the browser using a Chrome “flag.”

Before we get started, a warning: Enabling flags comes with a risk, as features behind them could impact browser performance causing Google Chrome to crash or freeze, or may be unstable.

  1. Open Google Chrome on your computer.
  2. In the address bar, type chrome://flags, then press Enter.
  3. In the search box enter “Reading List.”
  4. You should see a flag titled “Reading List.”
  5. Select Disabled from the drop-down menu.
  6. Chrome will prompt you to restart your browser so that it can apply the changes.
  7. Click Relaunch at the bottom of your screen to restart Chrome.
  8. When your browser reopens, you should notice that the Reading List button has vanished from the Bookmarks Bar.

If you need to bring the button back, navigate back to the Chrome flag following steps one to four above, then change it to Enabled or Default.

As you can see, whichever older version of Chrome you’re running, it’s pretty simple to remove the Reading List from Google Chrome Bookmark bar. Though for Chrome 89 and older versions, there remains no official way to do this to date. The workaround is easy enough, though, and should solve the age-old problem of the Reading List taking up prime bookmark bar real estate.

If you’re running the most recent version of Chrome, you won’t need either of these methods, as the Reading List is now handily tucked away in the Side Panel, so you can still store any articles or pages to read later here, You can access the Reading List by clicking the icon that looks like a page with a shaded column in the top right corner of your browser window.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-remove-reading-list-from-google-chromes-bookmark-bar/feed/ 0
How to Merge Cells in a Google Docs Table https://www.online-tech-tips.com/google-softwaretips/how-to-merge-cells-in-a-google-docs-table/ https://www.online-tech-tips.com/google-softwaretips/how-to-merge-cells-in-a-google-docs-table/#disqus_thread Sandy Writtenhouse]]> Wed, 28 Jun 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=96659

A table gives you a neat and clean way to structure details in your document. If you want to adjust how the data displays, we’ll show you how to merge […]]]>
A table gives you a neat and clean way to structure details in your document. If you want to adjust how the data displays, we’ll show you how to merge cells in Google Docs for tables on the web, Android, and iPhone.

Maybe you want to enhance a table’s appearance by including a title row or improve its readability by spanning the column headers. You can do both of these things easily by merging cells in your Google Docs table.

How to Merge Cells in Google Docs on the Web

If you’re working in Google Docs on the web, merging table cells takes only a couple of steps. Keep in mind that you can only combine adjacent cells, but you can merge vertically or horizontally.

Start by selecting the cells you want to merge. You can do this by selecting the first cell and dragging your cursor through the rest. You’ll then see the cells highlighted.

Right-click one of the selected cells and choose Merge cells in the shortcut menu.

That’s all there is to it—you should see your cells merged into one.

Unmerge Cells in Google Docs on the Web

Should you decide later that the combined cells aren’t working out, you can unmerge them just as easily. Remember that you can only unmerge cells that you’ve previously merged.

Right-click the merged cell and choose Unmerge cells in the shortcut menu.

You’ll then see your cells return to their original states.

How to Merge Cells in Google Docs on Android

If you take advantage of working with your Google Docs on the go, you can also merge table cells in the app on Android. Plus, you have two different ways to do it.

  1. Open your document and select the table cells you want to combine. You can do this by dragging the blue dot through the cells.
  1. Select the Edit button (pencil) if necessary and then do one of the following to merge the cells:
  • Tap the Merge cells button in the toolbar at the bottom of the screen.
  • Tap the three dots in the floating toolbar that appears on the screen and select Merge cells in the drop-down menu.
  1. You’ll then see your merged cells, ready for you to work.

To unmerge the cell later, follow the same steps and either deselect the Merge button or choose Unmerge cells in the three-dot menu.

How to Merge Cells in Google Docs on iPhone and iPad

Similar to Android, you can merge cells in the Google Docs app on iPhone and iPad and can use one of two methods.

  1. Open your document and select the table cells you want to combine by dragging the blue dot through the cells.
  1. Select the Edit button if necessary and then do one of the following to merge the cells:
  2. Tap the Merge cells button in the toolbar at the bottom (iPhone) or top (iPad) of the screen.
  1. Tap the Format button (underlined A) at the top, select the Table tab in the pop-up menu, and turn on the toggle for Merge cells.
  1. You’ll then see your cells merged into a single cell.

To unmerge the cell later, follow the same steps and either deselect the Merge button or turn off the Merge cells toggle.

Whether a title, headings, or other data, you can merge cells easily in a Google Docs table. For more, look at how to remove a border from a table in Docs.

]]>
https://www.online-tech-tips.com/google-softwaretips/how-to-merge-cells-in-a-google-docs-table/feed/ 0
10 Ways to Organize Documents in Google Docs https://www.online-tech-tips.com/google-softwaretips/10-ways-to-organize-documents-in-google-docs/ https://www.online-tech-tips.com/google-softwaretips/10-ways-to-organize-documents-in-google-docs/#disqus_thread Sandy Writtenhouse]]> Tue, 20 Jun 2023 22:00:00 +0000 https://www.online-tech-tips.com/?p=96503

Effectively organizing documents, especially lengthy ones, can be challenging. With the built-in features in Google Docs, you have several ways to compose reports, articles, essays, proposals, team documents, and more […]]]>
Effectively organizing documents, especially lengthy ones, can be challenging. With the built-in features in Google Docs, you have several ways to compose reports, articles, essays, proposals, team documents, and more in an efficient way.

You need to structure the document so it’s easy to display information and scan for details. So, let’s look at several key features for organizing your next Google Doc.

MONTREAL, CANADA – APRIL 26, 2019: Google Docs logo and app on a home page. Google is an American multinational technology company that specializes on Internet services and products.

1. Scan the Document With a Summary and Outline

One of the simplest ways to create an overview of your document details is with the summary and outline features. These handy tools sit outside the content so they don’t distract and can be shown or hidden with a click.

These organizational features let you summarize the contents of your document and skip to the section you need with the automatically generated outline.

Show and Close the Summary and Outline

To display the summary and outline, head to the View tab and select Show outline.

You’ll then see the Show document outline icon on the top left of the document space. Select it to expand it.

When you finish with the summary and outline, use the Close document outline arrow to hide it and display the Show document outline icon again.

Add a Summary and Outline

To add a summary, use the plus sign to open the box and enter your text.

To change it later, just select the Edit icon (pencil).

To use the outline, add headings to your document (explained below), and they’ll appear in the outline automatically. You can then select a heading to jump to that section of the document.

You can remove a particular heading from the outline if needed by selecting the X to the right of it in the outline.

2. Include and Customize a Table of Contents

If you want something within the content that your readers can use to navigate your document, you can insert a table of contents in Google Docs. This feature was basic, but Google has enhanced it over time to make it customizable and attractive.

Insert a Table of Contents

To create a table of contents, structure your document section with headings. Enter text for a heading, select it, and then pick a heading level from the Styles drop-down box in the toolbar. These headings automatically appear in the table for you.

When you’re ready to insert the table, place your cursor in the document where you want it. Then, open the Insert menu, move to Table of contents, and pick a style from Plain Text, Dotted, and Linked.

Choose the design you want to use, and you’ll see the table appear.

Customize a Table of Contents

You can adjust how your table of contents looks and works in Google Docs, which is a nice feature.

To open the editing tools, select the table to display the small toolbar. Then, use the three dots on the toolbar to pick More Options.

When the sidebar opens, you’ll see two sections for Formatting and Heading Levels.

  • Formatting: Choose a different table style, show or hide the page numbers, and optionally use a tab leader like dots, dashes, or lines.
  • Heading Levels: Pick the headings you want to display in the table and optionally adjust the indents.

You should see your adjustments update in real time.

3. Work Efficiently With Collapsible Headings

Google added a super helpful feature to Docs in early 2023 that allows you to work with lengthy documents a bit easier. You can collapse and expand the headings. This is great for focusing on sections of the document you’re using while collapsing those you aren’t.

As of this writing, the collapsible headings only work when you use the Pageless layout. It’s unclear if the feature will eventually carry over to the Pages layout.

To use the Pageless layout in a new or existing document, go to File and select Page setup. Then, choose Pageless at the top and OK at the bottom.

You should see arrows to the left of the headings in your document. Simply use those arrows or right-click to collapse and expand the headings.

4. Track Info Easily With Building Blocks

Building Blocks in Google Docs give you quick and convenient ways to display information using tables, text entries, and drop-down lists. Simply insert one of these prepackaged blocks and enter your details in one spot.

You can currently choose from four premade blocks, including a product roadmap, review tracker, project assets, and launch content tracker. You can use the Building Block as-is or customize it to suit your needs.

To insert a Building Block, select a location in your document and go to Insert > Building blocks. Choose the type you want to use from the pop-out menu.

You’ll see the block pop into your document, ready for you to use. If you want to change the headings to match your content, you can edit them like any other text.

5. Create and Reuse Custom Blocks

If you have a supported work or school Google account, you can set up custom Building Blocks in Docs. This allows you to create a block, save it, and reuse it. The block is saved to your Google Drive as a Google Docs file type, so you can use it in new documents down the road as well.

  1. Go to Insert > Building blocks and pick Custom building block in the pop-out menu.
  1. When the pop-up message appears in your document, choose New custom building block.
  1. Select the content you want to use as the custom block and choose Save in the blue bar at the top.
  1. Enter the name for your block and, optionally a description. Then, select Create. You’ll receive a confirmation that your block has been saved.

To use your new block, type the @ (At) symbol followed by the block’s name and choose it from the list that appears.

6. Enter Programming Snippets With Code Blocks

If your document contains programming code like Java, JavaScript, or Python, you can take advantage of the code Building Block. This allows you to structure your code neatly in your document.

Go to Insert > Building Blocks, move to Code block and choose the language in the pop-out menu.

When your block appears, simply enter your snippet. If you want to change the programming language, use the drop-down box on the top left. To update the colors, use the Refresh icon on the top right.

7. Collaborate on Emails, Calendar Invites, and Meeting Notes

Another cool tool to organize items in Google Docs is a built-in template block. These are especially useful if you’re collaboratively working together on emails, calendar invites, and meeting notes.

For emails, you can fill in the recipients, subject, and message. Then, select the Gmail icon to create the draft directly in Gmail.

For calendar invites, enter the title, guests, start and end times, location, and description. Use the Calendar icon to open the event in Google Calendar.

For meeting notes, choose an event from the drop-down list, and you’ll receive a block with the title, date, and attendees with bullets for notes and checkboxes for action items. Use the Email icon to create a draft with the meeting notes in Gmail.

MISSING IMAGE

To use one of these templates, go to Insert > Building Blocks and pick an option from the pop-out menu.

8. Enter Details Using a Drop-Down List

Using the Building Blocks above for tracking information, you can take advantage of Google Docs’ premade drop-down lists. However, you can create a drop-down list of your own just like in Google Sheets. This is handy for you, your readers, or your collaborators to enter the details you need easily.

Place your cursor where you want the list, open the Insert menu, and choose Dropdown.

To use a premade drop-down list, choose one from the bottom section.

To create your own, choose New dropdown. Then, enter the name and list of options. You can choose a color next to each list item, add more items, and rearrange the order using drag-and-drop. When you finish, select Save.

You’ll then see your new drop-down list, which you can reuse repeatedly. Simply select it from the Insert > Dropdown menu.

To make changes later, open the drop-down list and choose Add / Edit Options.

9. Pop In Information With Smart Chips

To list and view contacts, events, files, locations, and dates clearly, you can insert Smart Chips in your documents. These nifty tools stay condensed but expand to show the details and allow you to perform actions with a click.

You can insert a Smart Chip by typing the @ symbol followed by the item’s name or by going to Insert > Smart chips and picking one from the pop-out menu.

Once you insert the chip, hover your cursor over it or select it to view a preview. Each chip contains different details and actions depending on the chip type. For example, with a File Smart Chip, you can preview the file, copy a link to it, or open it.

If you have a supported Google Workspace account, you have access to additional Smart Chips, including a stopwatch, timer, and reusable variables.

Take advantage of these Smart Chips to include the information you need while keeping your content short and sweet.

10. Insert Equations With Ease

One more good tool Google Docs offers is for equations. Whether a student or professor, you can stop searching for the correct symbols and then format them to fit your document. Just use the equation editor.

To open the editor, go to View > Show equation toolbar. You can also select Insert > Equation. You’ll see the editing toolbar appear at the top of your document.

Use the drop-down boxes within the toolbar to add your symbols. You can use Greek letters, math operators, relation symbols, and arrows.

You’ll then see your equation appear in a nice and neat text box within your document.

From a summary to a tracking table to a drop-down list to a detailed chip, you can organize your Google documents in a variety of ways to meet your needs. Which of these features will become your fast favorite?

For related tutorials on other Google apps, look at how to set an expiration date on your Google Drive files.

]]>
https://www.online-tech-tips.com/google-softwaretips/10-ways-to-organize-documents-in-google-docs/feed/ 0