Article Listing

Quotas for Google Services

posted May 23, 2019, 7:28 PM by Sanjeev Jain

Google Apps Script services impose daily quotas and hard limitations on some features. If you exceed a quota or limitation, your script throws an exception and execution terminates.

Current quotas

Quotas are set at different levels for users of consumer accounts (such as and G Suite free edition (discontinued), or different G Suite editions.

Daily quotas are refreshed at the end of a 24-hour window; the exact time of this refresh, however, varies between users.

The table below lists the daily quotas as of August 2018. You can confirm the current on the Quota Limits tab of theApps Script Dashboard. The quotas shown below are provided solely to assist you in testing scripts. All quotas are subject to elimination, reduction, or change at any time, without notice.

G Suite free edition (legacy)G Suite
Basic / Gov
G Suite Business / Enterprise / EducationEarly Access
Calendar events created5,000 / day10,000 / day10,000 / day10,000 / dayFlexible
Contacts created1,000 / day2,000 / day2,000 / day2,000 / dayFlexible
Documents created250 / day500 / day1,500 / day1,500 / dayFlexible
Email recipients per day100* / day100* / day1,500* / day1,500* / day1,500* / day
Email read/write (excluding send)20,000 / day40,000 / day50,000 / day50,000 / dayFlexible
Groups read2,000 / day5,000 / day10,000 / day10,000 / dayFlexible
JDBC connection10,000 / day10,000 / day50,000 / day50,000 / dayFlexible
JDBC failed connection100 / day100 / day500 / day500 / day500 / day
Presentations created250 / day500 / day1,500 / day1,500 / dayFlexible
Properties read/write50,000 / day100,000 / day500,000 / day500,000 / dayFlexible
Spreadsheets created250 / day500 / day3,200 / day3,200 / dayFlexible
Triggers total runtime90 min / day3 hr / day6 hr / day6 hr / day6 hr / day
URL Fetch calls20,000 / day50,000 / day100,000 / day100,000 / dayFlexible

Note: Newly created G Suite domains are subject to the consumer limit for the first billing cycle if they have six or more users, or several billing cycles if they have fewer users. For more information, see the Help Center page on sending limits.

Current limitations

The table below lists hard limitations as of August 2018. The limits shown below are provided solely to assist you in testing scripts. All limits are subject to elimination, reduction, or change at any time, without notice.

G Suite free edition (legacy)G Suite
Basic / Gov
G Suite Business / Enterprise / EducationEarly Access
Script runtime6 min / execution6 min / execution6 min / execution30 min / execution30 min / execution
Custom function runtime30 sec / execution30 sec / execution30 sec / execution30 sec / execution30 sec / execution
Simultaneous executions3030303060
Email attachments250 / msg250 / msg250 / msg250 / msg250 / msg
Email body size200kB / msg200kB / msg400kB / msg400kB / msg400kB / msg
Email recipients per message50 / msg50 / msg50 / msg50 / msg50 / msg
Email total attachments size25MB / msg25MB / msg25MB / msg25MB / msg25MB / msg
Properties value size9kB / val9kB / val9kB / val9kB / val9kB / val
Properties total storage500kB / property store500kB / property store500kB / property store500kB / property store500kB / property store
Triggers20 / user / script20 / user / script20 / user / script20 / user / script20 / user / script
URL Fetch response size50MB / call50MB / call50MB / call50MB / call50MB / call
URL Fetch headers100 / call100 / call100 / call100 / call100 / call
URL Fetch header size8kB / call8kB / call8kB / call8kB / call8kB / call
URL Fetch POST size50MB / call50MB / call50MB / call50MB / call50MB / call
URL Fetch URL length2kB / call2kB / call2kB / call2kB / call2kB / call

For more details See:

Setup Page Level Permissions on Google Sites

posted Mar 28, 2019, 8:37 PM by Sanjeev Jain

Let's say you are the owner of a website with a Home page at the top and two pages -- called Private Page and Public Page -- underneath it. You want to share this site with your coworkers and allow them to edit both the Home and Public Page. However, your interns aren't allowed to see the financial data you keep on Private Page, and only accountants are allowed to edit that data. Everyone else can only view the Private Page.

To set this up:

  1. Click the More actions button  and select Sharing and Permissions.
  2. In the top right, click Enable page-level permissions.
  3. In the dialog box, click Turn on page-level permissions.
  4. Once you have page-level permissions on, you'll see the hierarchy of your site on the left side of the "Sharing and Permissions" page. At the top, click on the name of your site to set your site's permissions.
  5. In the dialog box that appears for your site, add everyone in your company and set their access level to Can edit.
  6. Find your Private page in your site's hierarchy and click on it.
  7. Next to "Use same permissions as the Site," click Change.
  8. In the dialog box that appears, under the "Use custom permissions" section, select Inheritance iconAdd new users to this page or No inheritance iconDo not add new users to this page.
  9. Click Save.
  10. While on your permissions page for your Private Page, delete your interns from your page.
  11. Finally, set everyone who isn't an accountant or an intern to Can view.

This will make your Private page editable by accountants, restricted for interns, and viewable by everyone else. In addition, everyone will be able to edit the rest of your site.

Page Level permissions

More detail on setting permissions for a specific page

In order for a person to be able to view or edit a specific page, you'll first need to add that person at the site level. You can then change which pages they can view or edit.

Once you've turned on page-level permissions and added people to your site, you can control people's permissions for each page:

  1. In your site hierarchy on the left side of the "Sharing and Permissions" page, click on the page that you want to set permissions for.
  2. By default, your page will be set to use the same permissions as your site. To have this page use different permissions, click Change next to "Use same permissions as the Site."
  3. Under "Use custom permissions," choose if you would like for this page to be visible to people you add to your site or if this page will only show to new people if you also specifically give them permission. You can always change how this page updates permissions later.
  4. Once you've made your selection, click Save.
  5. You'll now be able to set each person's access level for that page. Or, if you don't want a person to be able to see the page at all, you can click the Delete X icon icon on the right side of their name. This will also prevent them from seeing any pages below this page.
  6. Click Save changes to save your page-level permissions.

You can now see what permissions people have on this page in the box on the right side of the "Sharing and Permissions" page. You can also see the permissions for other pages by clicking on those pages in your site's hierarchy on the left side of the "Sharing and Permissions" page.

G-Suite Version Feature Comparison

posted Jan 22, 2019, 10:36 PM by Sanjeev Jain   [ updated Sep 25, 2019, 11:45 PM by Siddharth Jain ]

Here is a detailed comparison of various versions of G-Suite:

G-Suite Version Feature Comparison

Are you trying to decide which version of G Suite (formally is Google Apps) to sign up for? Or maybe you’re considering upgrading from your current version to one that offers more features. In this blog we will be discussing on the differences between various editions of G Suite / Google Apps.

There are three editions of Google Apps so far, they are:

  • G Suite Business (includes G Suite for Education)

  • G Suite Basic (includes special editions for nonprofits and government agencies)

  • Legacy edition of Google Apps





Messaging: Gmail, Calendar, Contacts

Storage and collaboration: Drive, Docs, Hangouts

Groups for Business

Email and document search, email retention: Vault

X *


Other Google services: Blogger, YouTube, and more

* Google Vault is available with G Suite Basic as a paid add-on.

Usage and support




Maximum number of users



10 – 10000

Email, document, photo storage per user

Unlimited *

30 GB

15 GB

99.9% uptime guarantee


24/7 phone support


Priority email support

X **

* G Suite Business accounts with 4 or fewer users get 1 TB per user.

** Any purchased accounts at will get support from us.

Your company brand




Your custom email address (

Your www address in Google Sites (

Gmail ads turned off

Addresses at multiple domains (


* By default the legacy free edition of Google Apps only supports domain aliases, not secondary domains. However, at we can adding secondary domains and making your domain as primary.

Security and business controls




Password monitoring and strength control

2-step verification

Single Sign On (SSO)

Enforced SSL connections

Mobile device management



Mobile audit




Advanced Drive auditing and reports



Advanced Drive administrator controls



Data-loss prevention




* Some Mobile Device Management features (like Device Owner) are not available in G Suite for Education and can be purchased.

** Not available in G Suite for Education

Contacts, lists, and groups




Mailing lists (admin controlled)

Mailing lists (user controlled)


Global directory (internal contacts)

Global directory (external contacts)


Forums and collaborative inboxes


Access options




Supported web browsers

Mobile phones and tablets

Offline mail and Docs editors

Voice and video chat

IMAP and POP mail programs

Microsoft Outlook®

Data import (mail, contacts, calendars)




Migrate data using the Admin console


Single-user import from Microsoft Outlook

Email import from webmail host

Multi-user import from Microsoft Exchange


Multi-user import from IBM® Notes®


Enterprise sync options




Sync user data with your LDAP server


Use Exchange Calendar with G Suite



Email usage




Email storage (shared with documents and photos)

Unlimited *

30 GB

15 GB

Attachment size limit

25 MB

25 MB

25 MB

Maximum recipients per message




Maximum recipients/day per user (outside your domain)




Maximum recipients/day per user (Emails sent thru Java Scripting)




* G Suite Business or G Suite for Education accounts with fewer than 5 users get 1 TB per user

Email security and business controls




Junk email filtering and virus blocking

Gmail ads turned off

Custom filtering and content policies


Email retention policies


IP address whitelisting


User-managed blacklists


Enforced compliance footers


Email/IM search, retention, eDiscovery (Google Vault)

X *


* Google Vault is available with G Suite Basic as a paid add-on.

Administrative controls




Option to disable Services from Admin Console

Other email delivery options




Catch-all address

Email routing (user and domain level)


Inbound gateway


Outbound gateway (for entire domain)


Outbound relay server (for alternative From: addresses)

Receive mail from multiple POP addresses (Mail Fetcher)

For further details and if you would like to purchase any if these editions of G-Suite please contact our team :

Rahul Singh : 8527436748 or 1-800-4198-477, Email:

Or Click :

G-Suite Setup

posted Nov 26, 2018, 5:47 AM by Sanjeev Jain   [ updated Nov 26, 2018, 7:18 AM ]

Please select the correct domain names that you wish to configure as Primary & Secondary domains for your G-Suite account.

Your domain needs to be verified before using with G suite (a.k.a Google Apps). To verify your domain and set up Gmail, you have to log in to your domain host such as GoDaddy\Bigrock\Net4India\Hostgator. Typically, this is where you bought your domain. There are 2 scenario's:

1. No Website or website is hosted by the domain provider

This will work fine if there is no website hosted by you or website is hosted on the same host. So you need to provide us the credentials of the Domain Provider.

2. Website is there and it is hosted by another  hosting provider not the same as the domain provider

In case you have hosted a website using a different company then you will need to make the changes on the domain panel of the company where the website is hosted. In this case you need to provide credentials of the Website Hosting provider's Cpanel.

3. In case you cannot provide the credentials, we can provide the settings required to be done and you can get these done yourself or by your website developer.  The settings required include the following:

a. Add the TXT record to the DNS configuration or upload an html file provided by us to help verify the domain with google
b. Make changes to MX records in order to redirect email server to Google
c. Add the TXT records to DNS for additional security settings like SPF, DKIM etc.

Here is additional information:

For any further support please contact 1-800-3070-1067 or 

How to Fix Slow Google Sheets

posted Nov 5, 2018, 9:04 AM by Sanjeev Jain   [ updated Jan 11, 2021, 3:22 AM ]

If your Google sheets are  taking forever to load or process data, then these 20 Optimisation strategies will be able to help you.

  1. How to know if Sheets are Slow
  2. Google Sheets Limitations. 
  3. Check size of Google Sheets
  4. Deleting un-used row\columns
  5. Converting formulas to static numbers to improve speed
  6. Using closed ranges
  7. Use volatile functions with care or eliminate them 
  8. VLOOKUP Optimization
  9. Import formula optimisation
  10. Use IF to optimise formula calls
  11. Using a Control Switch to manage extensive formulas
  12. Use Filter, Unique and Array_Constrain to create helper tables
  13. Avoid Calculation Chains
  14. Use Conditional Formatting sparingly
  15. Split & Combine your slow Google Sheets to speed them up
  16. Archive Old Data
  17. Use the power of Google Apps Scripts
  18. Other Troubleshooting Tips
  19. Know when it’s time to move to a database

1. How to know if Sheets are SlowCheck for these behaviours:

  • Calculations become very slow and loading bar appears frequently every time you make a change in the sheet.

  • Sheets are slow to respond to mouse or keyboard clicks.
  • Data does not show even after you have entered the same into a cell. You need to reload the sheet sometimes to have it show.
  • Sheet becomes un-responsive. You may get an error message like the one below or you may need to re-load the page.
  • Computer heating up, using a lot of RAM & battery. 

2. Google Sheet LimitationsKnow these limitations inherent in Google Sheets -
  • Google Sheets has a limit of 2 million cells per workbook (see Details Here).
  • Google Sheets has a maximum number of columns of 18,278 columns.
  • Within a single cell, there’s a maximum string length of 50,000 characters.
  • You can add a maximum of 40,000 new rows at a time.

Check size of Google Sheets

  • Using a special  audit tool you can see the total number of cells in the Sheet, how many have data in them and then statistics for each individual sheet too, including how many volatile and array functions you have.

Delete Unused Rows\Columns

  • Google Sheets get slower as they get larger. So one of the first things to try, is to reduce the size of your Google Sheet.
  • Blank rows\columns slow down performance, dramatically so in fact. So it’s a good idea to delete them whenever you can, so you reduce the number of cells Google Sheets is holding in memory.
  • Ideally you should remove any large numbers of blank rows under your data, or columns to the right of your data.
  • Especially for pages getting input from Forms you can delete all the rows under the data as every Form Input creates a new row for itself.
5. Convert formulas to static values wherever possible

  • After you have used a set of formulas in your data, you don't need them again, you should convert them to values. This is also true for columns like etc.
  • This will reduce the file size, which will help performance overall, and it’s also best practice (to reduce errors occurring if someone or something happens to break the formulas).
  • You change formulas to values by copying them and then:  Edit > Paste special > Paste values
  • Do keep a copy of a “live” formula at the top of your columns of data in your tables, so you have a record of how the calculation was performed and can also very quickly re-use it if needed:

Use closed range references

  • It's better to use Closed range references  like A1:B1000 instead of open references like A:B in your formulas wherever possible. Open references add 
     extra calculation overhead to your Sheet.
  • It might not look like there’s much data in column A, but Sheets will check every cell, including all the blank ones, if you use open ranges like A:B.
7. Remove volatile functions or use with caution

  • Remove volatile functions or use with caution - NOW(), TODAY(), RAND() and RANDBETWEEN() as they recalculate every time there’s a change to the Sheet. All dependent formulas must also be recalculated too (i.e. formulas that reference or include a nested volatile function).
  • This uses up processing power and so can negatively impact your Sheet’s performance. Best idea is to put these functions in a cell like A1 & then you can refer to the cell in any formula using $A$1 (absolute reference) where required. This will significantly increase the speed.

Vlookup Optimization

  • Use closed, rather than open, range references for your search tables where possible.

  • Reduce the size of your lookup table, if possible. For example, rather than search across everything you might use the Filter function to create a smaller, helper table for the lookup first, and then use that in your VLOOKUP.

  • Don’t nest the FILTER (or other) function inside your VLOOKUP and create the table on the fly each. It’s much, much slower.

  • For example, this formula is bad practice and will really slow down your Sheet if you have a lot of them:

    =VLOOKUP( $A1 , UNIQUE( FILTER( $K$1:$N$10000 , $K$1:$K$10000 < 100 )) , 2 , FALSE )

    whereas creating that nested Filter table as a helper table and referencing it is the preferred method:
    =VLOOKUP( $A1 , $F$1:$I$10 , 2 , FALSE)

9. IMPORTARANGE Optimization

  • The ImportHtml, ImportFeed, ImportData, ImportXml and ImportRange formulas pull data from sources external to your Google Sheet, so they require an Internet connection to function and are slower than other functions that operate entirely within your single Sheet, so they will potentially affect the performance of your Sheet.

  • For example, using ImportRange to import large amounts of data from another Sheet will take time and you may see the Loading… error message for a while:

  • The best idea is to minimize the number of times importrange formula is used. It may be best to get the entire data in one go in a hidden sheet and then use the data for reference in other sheets instead of having multiple use of import range.
  • Note, you’re limited to a maximum of 50 of ImportData functions in a single spreadsheet. Also note, that these functions recalculate as follows :

    ImportRange: Every 30 minutes

    ImportHtml, ImportFeed, ImportData, ImportXml: Every hour

10. Use IF statements to optimise formula calls

  • You can reduce the number of lengthy calculations being done in Sheets by using the IF Statement to check for certain preconditions. For example - only perform a Vlookup if the cell is not empty:

    = IF( A2="","", Vlookup (A2.....))

  • The same can be done for any formula. Other examples could be to check if a certain Value is larger or smaller or check for a certain text to do length calculation only if required. 
        = IF( A2>=1000,Filter("Sheet1!....),"NA")

Using a Control Switch to manage extensive formulas

  • You can actually turn Calculation on & off using a control switch cell with the IF statement. This way the sheets will not slow down as they will only start calculating the desired formula when you actually need them to. 

  • For example - Use data validation to create a drop-down menu in a single cell, the control cell, with values “Process” and “On Hold”.

    Then use an IF formula like this to only process the performance-hungry formulas in your slow Google Sheets when you want to:

    =IF( $A$2 = "On Hold" , "On hold" , your_formula_here )

  • Here’s an example of this control switch technique applied to some performance-hungry Instagram IMPORTXML formulas (for the top 25 accounts):

Use Filter, Unique and Array_Constrain to create helper tables

  • The FilterUnique and Array_Constrain functions can be used to create smaller helper tables for further data analysis work.
  • If you had a big table with 150,000 rows of data in, but were only interested in performing calculations on a smaller subset meeting certain parameters like "New/Old", "Country/City etc." , then you could use these functions to reduce the size of your table and create a new helper table for your calculations.

  • For example, you might use the Filter and Unique functions to create a helper table from a dynamic subset of your larger table:

=UNIQUE( FILTER( A1:E100000 , B1:B100000 = "India"))

        or using Array_Constrain to create a helper table from a static subset of your larger table:

=ARRAY_CONSTRAIN( A1:E100000 , 10 , 4 )

Avoid Calculation Chains

  • Avoid calculation chains of cells that reference each other in a long chain, for example a long column of cells equal to the cell above, like so:

  • It's better to reference a single cell with absolute references and then copy that down your column, e.g.


Use Conditional Formatting sparingly

  • Conditional formatting can be very slow on large datasets because it’s implemented on a cell-by-cell basis. So it’s best to use it for small data tables and in your dashboard reports. You will see immediate improvement by removing the same from large data sets.

Split & Combine your slow Google Sheets to speed them up

  • Assuming we’re sticking with Google Sheets though, it might be time to split up your huge dataset into separate Sheets if your Sheet is so slow that it’s frustrating to use.

  • This is especially true if you are importing large amounts of data from other sheets. If you are importing data from say 16 separate files then instead to importing directly into one single file it may be an excellent idea to make 3 or 4 separate sheets and each one imports data from 3-4 sources. You can them bring the data from just 3-4 sources to your main sheet. This will reduce the calculation load on the main sheet and make things much faster.

Archive Old Data

  • Once your sheet starts getting too much data and is becoming sluggish it may be a good idea to Archive the old data into a separate sheet for future reference. Maintain the past Months, Quarter or Year's data as your need may be. 

    The best approach to split & archive your really big Google Sheets is to make new copies, label each Sheet clearly and then delete all the data apart from the data relevant to that Sheet. For example, if you’re offloading data from 2017 into it’s own Sheet, then here are the steps:
    • Make a copy of the master Sheet, with all your data in
    • Name this new Sheet and include “2017” somewhere in the title
    • Sort the data by year in this new Sheet
    • Add a filter and show everything except 2017 data (i.e. hide the 2017 data)
    • Delete all these rows
    • Remove the filter to leave only the 2017 data

    Once you’ve completed all the steps for all your archived data, you’ll want to remove it from your master Sheet. I’d advocate keeping a full copy of your master Sheet before you start deleting any rows of data though.

    You’ll end up with a master Sheet that just has your current, or live, data in it, and it’ll hopefully be much faster.

    You can also do any calculations or data analysis locally and then bring the data back together in your master Sheet using the IMPORTRANGE formula.

Use the power of Google Apps Scripts

  •  Google Apps Script can be used to extend the functionality of Sheets.

  • Apps Script is extremely effective at doing big batches of calculations, especially repetitive ones, often more quickly than thousands of regular formulas.

  • Detailed instructions on the same are out of scope of this article, however we do conduct in-dept tutorials for the same. You can send you inquiry using this LINK to us for training on Google Apps Scripts. 

Other Troubleshooting Tips 

Sometimes it might not be an issue with Google Sheets themselves, try these strategies to see if any resolve your issues:

  • Close and re-open the Google Sheet (sometimes it’s the simplest fixes that work).
  • Refresh your browser. Close other tabs, opening too many tabs will slow down your computer as each Tab uses a large amount of RAM.
  • Clear your cache and cookies. 
  • Try another browser or operating system. Make sure both browser and operating system are currently running on their latest version.
  • Disable browser plugins or extensions or try accessing the sheet in Incognito\Private mode.
  • Try replicating the issue on another computer to see if it’s the computer hardware having issues. A Google Sheet’s calculation speed depends mostly on the local resources.
  • Try replicating your issue on another network to see if it is a network/internet issue. Most functions are run locally in the browser but some, like the IMPORT formulas, require access to the Internet (as well as any Apps Script which is run on Google servers).
  • Try disabling and re-enabling offline access.
  • Try on a different or a faster computer.

Know when it’s time to move to a database

There will come a time, when Google Sheets won’t fulfill all of your data needs. There is the 2 million cell limit that may fill up pretty quickly with real-world data. Before you hit the  2 million limit you should think through the next steps beyond slow Google Sheets. You’re going to want to move your data into a database archive. You can still work in a Sheets environment but offload the data storage to a dedicated database.

Google Database Options

Within the Google ecosystem, we’re talking about BigQuery and Cloud SQL, both cloud databases. However, the integration isn’t simply drag-and-drop anymore, so you’ll need development skills to connect these services.

Google BigQuery is integrated with Google Drive, so you can use your Google Sheets as tables in BigQuery. You can also use the BigQuery Apps Script service to manage your BigQuery projects.

Connecting a Google Sheet to Cloud SQL directly requires Apps Script, although you could export data from Google Sheets (e.g. as CSV) and import that into Google Cloud SQL.

Detailed instructions on the same are out of scope of this article, however you can send your inquiry using this LINK to us for more details & support on this Topic. 


I hope that you will find a lot of value in the above article. Google Sheets are only a small part of the Tech Ecosystem  that can help you to convert technological threats into an opportunity, re-invent themselves & transform their industry.

If still find yourself struggling even after doing lengthy & expensive trainings then probably you lack the Thought Process & Tools for Exponential Growth. 

STOP trying to Re-Invent the Wheel ! 

Check out our  100% Practical & Transformational Coaching that have turned around hundreds of businesses.


Remember: You need to work Hard in Business but Struggle is optional !

Resolved - Message Blocked Gmail Google Apps Script

posted Nov 4, 2018, 7:09 PM by Sanjeev Jain   [ updated Mar 25, 2019, 12:08 AM by Siddharth Jain ]

Learn how to resolve the Message Blocked issue affecting new G-Suite users when trying to send an email through Google Apps Script. Please see the video below where I have explained the issue and how to resolve the same in detail.

For any further support please contact me at Do feel free to browse this site for more amazing Tips & Article on how to use Technology to Grow your business.

We also conduct unique Tech Workshops to help  you Grow your business !

Get new Gmail for G-Suite Legacy\Paid users

posted Jul 29, 2018, 7:37 PM by Sanjeev Jain   [ updated Jul 29, 2018, 7:40 PM ] gets its biggest upgrade in the service's history. There's a new Confidential Mode, the ability to set expiration dates and passcodes for emails, and other advanced security features.

If you’re using a G-Suite Legacy\Paid Account, your account administrator will have to turn on the new interface for you.

Here is the hidden link you can use from admin account: Click Here

We hope you find this interesting and valuable. 

For any support please contact us on 1 800 3060 1067  | Vandana@Ceoitbox.In  | Www.Ceoitbox.Com 

             We also conduct unique Tech Workshop to help  you build Remarkable Intranets !                 

Tech Mastery 2018

These Windows shortcuts can save you min 46 hours per year

posted Jul 15, 2018, 7:28 AM by Sanjeev Jain   [ updated Jul 15, 2018, 7:29 AM ]

When it comes to using your computer, it's keyboard shortcuts that get things done the fastest. And for every version of Windows, Microsoft add a few useful new ones to the old standbys. Here are our favorites.

New Windows 10 keyboard shortcuts

The Windows key is the key on your keyboard that has the Windows logo on it. On a regular desktop keyboard, it sits between the Ctrl and Alt keys to the left of the space bar.  Pressed by itself, the Windows key opens or closes the Start menu, but when pressed in combination with other buttons, it works wonders.

Desktop and Cortana shortcuts

  • Windows key + A This key combination opens the Action Center menu at the right side of the screen. Here you can view your notifications and access commonly used settings like Wi-Fi and Bluetooth.
  • Windows key + I If you need to modify your computer’s settings, this is the key combination to press. It opens the Settings app (known in previous Windows versions as Control Panel).
  • Windows key + C Open Cortana in listening mode with this keystroke to perform a quick search using your voice. Voice search is supported in selected countries only. If voice search is disabled or turned off, you can still use text search on Cortana.
  • Windows key + S If you want to find a file or an app installed on your computer or search for a term on the Web, this is the keystroke to press.

Task View and Virtual Desktop

Windows buttonOne of Windows 10’s new useful features is the ability to create multiple virtual desktops. They let you group related applications for more efficient multitasking. For instance, you can open all work-related apps on the first desktop, your browser for personal browsing and personal apps on the second desktop and so on. You can also move open apps from one desktop to another.

  • Windows key + Ctrl + D Create a new virtual desktop with this combination. You can open new sets of applications and programs in the new virtual desktop.
  • Windows key + Ctrl + Left Switch to the next virtual desktop on the left.
  • Windows key + Ctrl + Right Switch to the next virtual desktop on the right.
  • Windows key + Tab Opens Task View, which shows you all the currently running programs on a desktop. If you’re using more than one virtual desktop, you will see them below the switcher in Task View and you can switch between desktops.
  • Windows key + Ctrl + F4 Remove a virtual desktop without terminating the apps running within that desktop. Any open application on the removed desktop will be moved to the next available virtual desktop.

Command Prompt shortcuts

The Command Prompt (or command line terminal or DOS prompt) lets you perform many functions such as moving, copying and deleting files and folders using text-based commands without having to click and use the graphical user interface.

Windows 10’s Command Prompt has new shortcuts, but to be able to use them, you need to set some options in the Options tab. Here’s how:

  1. On the Command Prompt window, right-click on the title bar and select Properties.
  2. On the Options tab, disable Use Legacy Console.
  3. Also, enable Enable Line Wrapping Selection and Extended Text Selection Keys under Text Selection.

The following Command Prompt shortcuts have been staples in text editors and word processors, but they are new to the Command Prompt.

  • Shift + Left Highlights one character to the left of the cursor.
  • Shift + Right Highlights one character to the right of the cursor.
  • Ctrl + Shift + Left Highlights a block of text to the left of the cursor.
  • Ctrl + Shift + Right Highlights a block of text to the right of the cursor.
  • Ctrl + A Highlights all text in the Command Prompt window.
  • Ctrl + C Copies the highlighted text to the Clipboard.
  • Ctrl + V Paste the Clipboard contents to the Command Prompt.

Other helpful keyboard shortcuts

Commonly used shortcuts for Windows

  • F2 Select a file, then press the F2 function key to rename it.
  • F3 Search for a file in File Explorer. If pressed in a browser window, the Find in Page function activates instead.
  • F4 Show the Address Bar in File Explorer.
  • F5 Reload or refresh the content of the current File Explorer window. If used inside a browser, this reloads the web page.
  • F6 Cycle through the different interface elements of the active window. The first time you press this key, the Display Information button will be highlighted, then the Address Bar, and so on. To execute the highlighted button, press the Enter key. If multiple items are highlighted, use the arrow keys to navigate.
  • F10 Activate the shortcut functionality in File Explorer. When pressed, an overlay appears showing letters or numbers on top of menus and buttons. Pressing a button or letter executes the corresponding command or open the corresponding menu or dialogue.
  • Ctrl + C This is the standard Copy shortcut. It copies the selected item (text, objects, files, and so on) to the clipboard.
  • Ctrl + X This is the standard shortcut for the Cut command. When the cut item is pasted elsewhere, it is removed from its original location.
  • Ctrl + V This is the standard keystroke for the Paste function. It puts the Clipboard’s content into the current window.
  • Ctrl + Z Reverse a previous action. This is also known as the Undo shortcut.
  • Alt + Tab Switch to the next open app.
  • Alt + F4 Close a running app or program.
  • Shift + Delete Delete a file permanently, bypassing the Recycle Bin.
  • Windows Key + L Lock the computer screen.
  • Windows Key + D Minimize all running programs and shows the Desktop.

Other shortcuts using the Windows Key

  • Windows Key + E Launch File Explorer, which is used to locate and manage files saved in your computer.
  • Windows Key + G Open the Game Bar so you can take a screenshot or record a video while playing a game.
  • Windows Key + H Press this combo to open the Share charm or side popup so you can quickly share files via email, social media or other apps capable of file sharing.
  • Windows Key + K Opens the Connect Quick menu to quickly connect to a wireless display or audio device.
  • Windows Key + M Minimize all open windows.
  • Windows Key + Shift + M Restore all minimized windows.
  • Windows Key + P Toggle a presentation display mode when using multiple screens. You can choose to show the display on the main screen only, duplicate the display on the second screen, use the second display as an extension or use only the second display attached to the computer.
  • Windows Key + R Open the Run dialog box where you can execute commands, open files and launch programs.
  • Windows Key + T Cycle through apps pinned on the Taskbar. When the app you want is highlighted, press Enter to launch it.
  • Windows Key + U Open the Ease of Access Center window for configuring accessibility features.
  • Windows Key + X Open the Quick Link menu to access tools such as Command Prompt, File Explorer, Settings and Task Manager.
  • Windows Key + Pause Open the System Properties window, which contains technical information about your computer. You can also find here settings that determine how your computer behaves or functions. Requires admin access.
  • Windows Key + PrtScr Take a screenshot of the display and saves it to Computer > Pictures > Screenshots.
  • Windows Key + Arrow key (up/down/left/right) Sometimes you want to see the contents of more than one window at a time. This key combination snaps the current window to the edge of the screen, depending which cursor key you press. Up to four windows can fit on one screen. For instance, to snap a window to the lower right corner, press Windows Key + Down, then press Windows Key + Right.
  • Windows Key + , (comma) Hold down this key combination to temporarily hide open apps and windows and show the Desktop. When the keys are released, the hidden apps and windows return to their original positions.

For more news & articles visit us at

What are Intranets and why they are Critical for your Company

posted Jul 8, 2018, 12:29 PM by Sanjeev Jain   [ updated Mar 22, 2020, 8:52 AM ]

This is a video guide, please see the video below.

Guide to Intranets

We hope you find this interesting and valuable. 

For any support please contact us on 1 800 4198 477  | siddharth@Ceoitbox.In  | Www.Ceoitbox.Com 

             We also conduct unique Tech Workshop to help  you build Remarkable Intranets !                 

Consolidate multiple email accounts using Gmail

posted May 13, 2018, 10:22 PM by Sanjeev Jain   [ updated Sep 12, 2018, 9:24 AM ]

It is not uncommon to have several email accounts, but checking multiple accounts in different places is tedious. Hence, many people revert to a desktop email client like Thunderbird or Outlook to manage all their mail from one place. 

However, I found that Gmail can do the same and it can do it much better. Since I switched, I no longer have to worry about backing up or moving my profile, I save a bit of RAM as my browser is running anyway, I save several gigabytes of hard drive space, and no matter where I check my mail, it’s always the same familiar inbox and setup greeting me.

Besides, Gmail has an ingenious search feature, some fun and very useful Google Labs plugins, and with browser extensions you can get even more cool features. In other words, it’s bliss and I would like to share that with you.

Let Gmail become your one account to rule them all! 

STEP1: Import Email Accounts Into Gmail

The best way I recommend is that instead of importing email from other accounts, its best that you forward the email from those accounts to your main Gmail account. For more detailed instructions, Click Here

Much like a desktop client, Gmail can handle multiple email accounts. Moreover, it makes importing mail from POP3 accounts fairly easy, by automatically filling in the required POP server information for you.

Let’s say you want to import email from an old Hotmail account, what would you need to do?

  1. Open Google Mail, click the wheel icon in top right and select Settings from the drop-down menu.
  2. In your Gmail settings, go to the Accounts and Import tab.
  3. Under the header Check mail using POP3 click Add a POP3 mail account you own.
  4. Fill in your email address and click Next Step.
  5. In the next window, add your password, check the boxes that apply, and click Add Account.
  6. For more detailed instructions, Click Here

The video below illustrates how to do this easily.

STEP2: Configure your Main Gmail account to send email as other account

If you are using the paid G-Suite account and get the following error you may need to enable this functionality from your Administrator Console.

How do I allow or disallow users to use an outbound gateway?

By default, users cannot use an outbound gateway; the G Suite mail servers deliver all outgoing mail, including mail that uses alternate From addresses.

To allow users to use an outbound gateway:

  1. Sign in to the Google Admin console.
  2. From the dashboard, click Apps, then click G Suite > Gmail > User settings.
  3. In the Allow per-user outbound gateways section, select Allow users to send mail through an external SMTP server when configuring a "from" address hosted outside your email domains.

    When this check box is selected, users who associate additional email addresses with their accounts have the option to enter connection information for an alternate SMTP server. (Learn more about the required steps for the user.) When the check box is not selected, users cannot specify an SMTP server for the additional address.
  4. Click Save changes.

It can take up to an hour for the changes to propagate through Google systems.

1-10 of 36