Google Docs Blog: sheets

<!DOCTYPE html> <html class='v2 list-page' dir='ltr' itemscope='' itemtype='http://schema.org/Blog' lang='en' xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr'> <head> <link href='https://www.blogger.com/static/v1/widgets/3566091532-css_bundle_v2.css' rel='stylesheet' type='text/css'/> <title> Google Docs Blog: sheets </title> <meta content='width=device-width, height=device-height, minimum-scale=1.0, initial-scale=1.0, user-scalable=0' name='viewport'/> <meta content='IE=Edge' http-equiv='X-UA-Compatible'/> <meta content='Google Docs Blog' property='og:title'/> <meta content='en_US' property='og:locale'/> <meta content='https://docs.googleblog.com/search/label/sheets' property='og:url'/> <meta content='Google Docs Blog' property='og:site_name'/>  <meta content='Google Docs Blog' property='og:title'/> <meta content='summary' name='twitter:card'/> <meta content='@googledocs' name='twitter:creator'/> <link href='https://fonts.googleapis.com/css?family=Roboto:400italic,400,500,500italic,700,700italic' rel='stylesheet' type='text/css'/> <link href='https://fonts.googleapis.com/icon?family=Material+Icons' rel='stylesheet'/> <script src='https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js' type='text/javascript'></script>  <style id='page-skin-1' type='text/css'></style> <style id='template-skin-1' type='text/css'></style>  <meta content='text/html; charset=UTF-8' http-equiv='Content-Type'/> <meta content='blogger' name='generator'/> <link href='https://docs.googleblog.com/favicon.ico' rel='icon' type='image/x-icon'/> <link href='https://docs.googleblog.com/search/label/sheets' rel='canonical'/> <link rel="alternate" type="application/atom+xml" title="Google Docs Blog - Atom" href="https://docs.googleblog.com/feeds/posts/default" /> <link rel="alternate" type="application/rss+xml" title="Google Docs Blog - RSS" href="https://docs.googleblog.com/feeds/posts/default?alt=rss" /> <link rel="service.post" type="application/atom+xml" title="Google Docs Blog - Atom" href="https://www.blogger.com/feeds/35192255/posts/default" />  <meta content='https://docs.googleblog.com/search/label/sheets' property='og:url'/> <meta content='Google Docs Blog' property='og:title'/> <meta content='The official source for news, updates and tips about Docs, Sheets, Slides, Forms, and Keep.' property='og:description'/>  <base target='_self'/> <style> html { font-family: Roboto, sans-serif; -moz-osx-font-smoothing: grayscale; -webkit-font-smoothing: antialiased; } body { padding: 0; /* This ensures that the scroll bar is always present, which is needed */ /* because content render happens after page load; otherwise the header */ /* would "bounce" in-between states. */ min-height: 150%; } h2 { font-size: 16px; } h1, h2, h3, h4, h5 { line-height: 2em; } html, h4, h5, h6 { font-size: 14px; } a, a:visited { color: #4184F3; text-decoration: none; } a:focus, a:hover, a:active { text-decoration: none; } .Header { margin-top: 15px; } .Header h1 { font-size: 32px; font-weight: 300; line-height: 32px; height: 42px; } .header-inner .Header .titlewrapper { padding: 0; margin-top: 30px; } .header-inner .Header .descriptionwrapper { padding: 0; margin: 0; } .cols-wrapper { margin-top: 56px; } .header-outer, .cols-wrapper, .footer-outer, .google-footer-outer { padding: 0 60px; } .header-inner { height: 256px; position: relative; } html, .header-inner a { color: #212121; color: rgba(0,0,0,.87); } .header-inner .google-logo { display: inline-block; background-size: contain; z-index: 1; height: 80px; overflow: hidden; margin-top: 4px; margin-right: 8px; } .header-left { position: absolute; top: 50%; -webkit-transform: translateY(-50%); transform: translateY(-50%); margin-top: 12px; width: 100%; } .google-logo { margin-left: -4px; } #google-footer { position: relative; font-size: 13px; list-style: none; text-align: right; } #google-footer a { color: #444; } #google-footer ul { margin: 0; padding: 0; height: 144px; line-height: 144px; } #google-footer ul li { display: inline; } #google-footer ul li:before { color: #999; content: "\00b7"; font-weight: bold; margin: 5px; } #google-footer ul li:first-child:before { content: ''; } #google-footer .google-logo-dark { left: 0; margin-top: -16px; position: absolute; top: 50%; } /** Sitemap links. **/ .footer-inner-2 { font-size: 14px; padding-top: 42px; padding-bottom: 74px; } .footer-inner-2 .HTML h2 { color: #212121; color: rgba(0,0,0,.87); font-size: 14px; font-weight: 500; padding-left: 0; margin: 10px 0; } .footer-inner-2 .HTML ul { font-weight: normal; list-style: none; padding-left: 0; } .footer-inner-2 .HTML li { line-height: 24px; padding: 0; } .footer-inner-2 li a { color: rgba(65,132,243,.87); } /** Archive widget. **/ .BlogArchive { font-size: 13px; font-weight: normal; } .BlogArchive .widget-content { display: none; } .BlogArchive h2, .Label h2 { color: #4184F3; text-decoration: none; } .BlogArchive .hierarchy li { display: inline-block; } /* Specificity needed here to override widget CSS defaults. */ .BlogArchive #ArchiveList ul li, .BlogArchive #ArchiveList ul ul li { margin: 0; padding-left: 0; text-indent: 0; } .BlogArchive .intervalToggle { cursor: pointer; } .BlogArchive .expanded .intervalToggle .new-toggle { -ms-transform: rotate(180deg); transform: rotate(180deg); } .BlogArchive .new-toggle { float: right; padding-top: 3px; opacity: 0.87; } #ArchiveList { text-transform: uppercase; } #ArchiveList .expanded > ul:last-child { margin-bottom: 16px; } #ArchiveList .archivedate { width: 100%; } /* Months */ .BlogArchive .items { max-width: 150px; margin-left: -4px; } .BlogArchive .expanded .items { margin-bottom: 10px; overflow: hidden; } .BlogArchive .items > ul { float: left; height: 32px; } .BlogArchive .items a { padding: 0 4px; } .Label { font-size: 13px; font-weight: normal; } .sidebar-icon { display: inline-block; width: 24px; height: 24px; vertical-align: middle; margin-right: 12px; margin-top: -1px } .Label a { margin-right: 4px; } .Label .widget-content { display: none; } .FollowByEmail { font-size: 13px; font-weight: normal; } .FollowByEmail h2 { background: url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABEAAAALCAYAAACZIGYHAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAUBJREFUeNrMkSGLAlEUhb+ZB4JFi8mx2cz+ApvhRUGTcUCrNqNJDYIi+DO0GUwmQXDK2DSIoGgZcSaIjDrzwrK4ssvChj1w0733O+fdp+m6PozH4yQSCfb7Pa7r8pOi0SjJZBLP8zgej4gAIMvlMuPxmADIYrHger1+C6lUKmo+NJ/NZojb7SZDWiwWo1qtks1msW2bw+HwZdkwDHq9HvV6nel0SqvVYrvdIh6Ph3Qch+VyqRYLhQJSSjRNw7IsfN9XgGKxSLfbJZfL0e/3aTabrFYr7vc7IujLcOh8PqunrNdr0uk0pVKJVCpFJBJRgEajweVyod1uMxgM2O12BAGUgRbU8DV2JpOhVquRz+cRQii3+XxOp9NRN3jVR5LPOp1OjEYjlSL8hclkgmmabDabt4d+m+S30vkD/R/IU4ABAPTZgnZdmG/PAAAAAElFTkSuQmCC"); background-repeat: no-repeat; background-position: 0 50%; text-indent: 30px; } .FollowByEmail .widget-content { display: none; } .searchBox input { border: 1px solid #eee; color: #212121; color: rgba(0,0,0,.87); font-size: 14px; padding: 8px 8px 8px 40px; width: 164px; font-family: Roboto, sans-serif; background: url("https://www.gstatic.com/images/icons/material/system/1x/search_grey600_24dp.png") 8px center no-repeat; } .searchBox ::-webkit-input-placeholder { /* WebKit, Blink, Edge */ color: rgba(0,0,0,.54); } .searchBox :-moz-placeholder { /* Mozilla Firefox 4 to 18 */ color: #000; opacity: 0.54; } .searchBox ::-moz-placeholder { /* Mozilla Firefox 19+ */ color: #000; opacity: 0.54; } .searchBox :-ms-input-placeholder { /* Internet Explorer 10-11 */ color: #757575; } .widget-item-control { margin-top: 0px; } .section { margin: 0; padding: 0; } #sidebar-top { border: 1px solid #eee; } #sidebar-top > div { margin: 16px 0; } .widget ul { line-height: 1.6; } /*main post*/ .post { margin-bottom:30px; } #main .post .title { margin: 0; } #main .post .title a { color: #212121; color: rgba(0,0,0,.87); font-weight: normal; font-size: 24px; } #main .post .title a:hover { text-decoration:none; color:#4184F3; } .message, #main .post .post-header { margin: 0; padding: 0; } #main .post .post-header .caption, #main .post .post-header .labels-caption, #main .post .post-footer .caption, #main .post .post-footer .labels-caption { color: #444; font-weight: 500; } #main .tr-caption-container td { text-align: left; } #main .post .tr-caption { color: #757575; color: rgba(0,0,0,.54); display: block; max-width: 560px; padding-bottom: 20px; } #main .post .tr-caption-container { line-height: 24px; margin: -1px 0 0 0 !important; padding: 4px 0; text-align: left; } #main .post .post-header .published{ font-size:11px; font-weight:bold; } .post-header .publishdate { font-size: 17px; font-weight:normal; color: #757575; color: rgba(0,0,0,.54); } #main .post .post-footer{ font-size:12px; padding-bottom: 21px; } .label-footer { margin-bottom: 12px; margin-top: 12px; } .comment-img { margin-right: 16px; opacity: 0.54; vertical-align: middle; } #main .post .post-header .published { margin-bottom: 40px; margin-top: -2px; } .post .post-content { color: #212121; color: rgba(0,0,0,.87); font-size: 17px; margin: 25px 0 36px 0; line-height: 32px; } .post-body .post-content ul, .post-body .post-content ol { margin: 16px 0; padding: 0 48px; } .post-summary { display: none; } /* Another old-style caption. */ .post-content div i, .post-content div + i { font-size: 14px; font-style: normal; color: #757575; color: rgba(0,0,0,.54); display: block; line-height: 24px; margin-bottom: 16px; text-align: left; } /* Another old-style caption (with link) */ .post-content a > i { color: #4184F3 !important; } /* Old-style captions for images. */ .post-content .separator + div:not(.separator) { margin-top: -16px; } /* Capture section headers. */ .post-content br + br + b, .post-content .space + .space + b, .post-content .separator + b { display: inline-block; margin-bottom: 8px; margin-top: 24px; } .post-content li { line-height: 32px; } /* Override all post images/videos to left align. */ .post-content .separator, .post-content > div { text-align: left; } .post-content .separator > a, .post-content .separator > span { margin-left: 0 !important; } .post-content img { max-width: 100%; height: auto; width: auto; } .post-content .tr-caption-container img { margin-bottom: 12px; } .post-content iframe, .post-content embed { max-width: 100%; } .post-content .carousel-container { margin-bottom: 48px; } #main .post-content b { font-weight: 500; } /* These are the main paragraph spacing tweaks. */ #main .post-content br { content: ' '; display: block; padding: 4px; } .post-content .space { display: block; height: 8px; } .post-content iframe + .space, .post-content iframe + br { padding: 0 !important; } #main .post .jump-link { margin-bottom:10px; } .post-content img, .post-content iframe { margin: 30px 0 20px 0; } .post-content > img:first-child, .post-content > iframe:first-child { margin-top: 0; } .col-right .section { padding: 0 16px; } #aside { background:#fff; border:1px solid #eee; border-top: 0; } #aside .widget { margin:0; } #aside .widget h2, #ArchiveList .toggle + a.post-count-link { color: #212121; color: rgba(0,0,0,.87); font-weight: 400 !important; margin: 0; } #ArchiveList .toggle { float: right; } #ArchiveList .toggle .material-icons { padding-top: 4px; } #sidebar .tab { cursor: pointer; } #sidebar .tab .arrow { display: inline-block; float: right; } #sidebar .tab .icon { display: inline-block; vertical-align: top; height: 24px; width: 24px; margin-right: 13px; margin-left: -1px; margin-top: 1px; color: #757575; color: rgba(0,0,0,.54); } #sidebar .widget-content > :first-child { padding-top: 8px; } #sidebar .active .tab .arrow { -ms-transform: rotate(180deg); transform: rotate(180deg); } #sidebar .arrow { color: #757575; color: rgba(0,0,0,.54); } #sidebar .widget h2 { font-size: 14px; line-height: 24px; display: inline-block; } #sidebar .widget .BlogArchive { padding-bottom: 8px; } #sidebar .widget { border-bottom: 1px solid #eee; box-shadow: 0px 1px 0 white; margin-bottom: 0; padding: 14px 0; min-height: 20px; } #sidebar .widget:last-child { border-bottom: none; box-shadow: none; margin-bottom: 0; } #sidebar ul { margin: 0; padding: 0; } #sidebar ul li { list-style:none; padding:0; } #sidebar ul li a { line-height: 32px; } #sidebar .archive { background-image: url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAYCAYAAADzoH0MAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAE1JREFUeNpiNDY23s9AAWBioBCwYBM8c+YMVsUmJibEGYBNMS5DaeMFfDYSZQA2v9I3FrB5AZeriI4FmnrBccCT8mhmGs1MwyAzAQQYAKEWG9zm9QFEAAAAAElFTkSuQmCC"); height: 24px; line-height: 24px; padding-left: 30px; } #sidebar .labels { background-image: url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABEAAAARCAYAAAA7bUf6AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAUxJREFUeNpiNDY23s9AAMycOfM7UF05kHkZmzwTMkdSUhKrIcXFxZy3bt3qBjIN8RrS09PDsHnzZjCNDr58+cKQlpbGDjSoHcg1w2oIyAUODg5gARCNzUVIBrUCuVYYhjx//pzhwIEDYAEQDeJjA1CDWIAGNQK59jBxRuSABbkAlwHIgIeHh2HWrFn/1NTU2oDcvSgBS4wBSC5iArqoCsj1YGIgEyAZVMoEchqlBjEB/cZAiUHg2AEGznpKDAImxOeM////B4VLKtBvEUCngZ1ILKivr3/u6+ubBzJAGZQ9gC5aQoqLgAY8BhkAZL4BuQQkxgXE34A4BuiiZEIuAhrwEGhAEZD5DpzYoIaA2UAM4kQADUrHZRDUgAIg8wO2XAwzbQXQa5OweQ1owB10AyA6gS7BgX1u3ry5397eHow3bdo0EyjGi00tQIABANPgyAH1q1eaAAAAAElFTkSuQmCC"); height: 20px; line-height: 20px; padding-left: 30px; } #sidebar .rss a { background-image: url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAX5JREFUeNqsVDGSgkAQHL2rIiIikohIc/EBRkbwAIwuwgfwAXiAD9AHSI7kEkECRCb6AIyINDLx7K0aa6kT7uq0q7YYtnZ7umdnt7darXbr9Zpegeu61DNNc0dvwCcH4/GYJpMJnc9nOhwOVJbl/4hAAokMECZJQtvt9k+kH7qufyEYDAakqqqYxFdRFBqNRmTbNg2HQ0rTlK7XayvR0xqBdDqdkuM4dE/0ULhYLOh4PHYrknG5XGi/31MYhuL/nkwonM1mlGUZ1XXdrsiyLGEDhY7juJEZ1u5tIixDGdYhmYw+B7CAzPP5nDabjdgIAgCksMX1832/3drtdqPT6SQWapomiGEFNkDEdpDMMAzK81ys/7XYy+XyoQgq2WoURSIJ2iIIgp/WZCCTvFm2wgeAU31aI3Q2GhIDMeB53qPYPIcm5VrxXIOIOxsDMStjVawAc1VViRgN22lNBiuQN3GR+SY07hpOoStmFQAKXRRFY93bnpG+fONfedi+BRgAbkS8Fxp7QQIAAAAASUVORK5CYII="); } #sidebar .subscription a { background-image: url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABEAAAALCAYAAACZIGYHAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAUBJREFUeNrMkSGLAlEUhb+ZB4JFi8mx2cz+ApvhRUGTcUCrNqNJDYIi+DO0GUwmQXDK2DSIoGgZcSaIjDrzwrK4ssvChj1w0733O+fdp+m6PozH4yQSCfb7Pa7r8pOi0SjJZBLP8zgej4gAIMvlMuPxmADIYrHger1+C6lUKmo+NJ/NZojb7SZDWiwWo1qtks1msW2bw+HwZdkwDHq9HvV6nel0SqvVYrvdIh6Ph3Qch+VyqRYLhQJSSjRNw7IsfN9XgGKxSLfbJZfL0e/3aTabrFYr7vc7IujLcOh8PqunrNdr0uk0pVKJVCpFJBJRgEajweVyod1uMxgM2O12BAGUgRbU8DV2JpOhVquRz+cRQii3+XxOp9NRN3jVR5LPOp1OjEYjlSL8hclkgmmabDabt4d+m+S30vkD/R/IU4ABAPTZgnZdmG/PAAAAAElFTkSuQmCC"); } #sidebar-bottom { background: #f5f5f5; border-top:1px solid #eee; } #sidebar-bottom .widget { border-bottom: 1px solid #e0e0e0; padding: 15px 0; text-align: center; } #sidebar-bottom > div:last-child { border-bottom: 0; } #sidebar-bottom .text { line-height: 20px; } /* Home, forward, and backward pagination. */ .blog-pager { border-top : 1px #e0e0e0 solid; padding-top: 10px; margin-top: 15px; text-align: right !important; } #blog-pager { margin-botom: 0; margin-top: -14px; padding: 16px 0 0 0; } #blog-pager a { display: inline-block; } .blog-pager i.disabled { opacity: 0.2 !important; } .blog-pager i { color: black; margin-left: 16px; opacity: 0.54; } .blog-pager i:hover, .blog-pager i:active { opacity: 0.87; } #blog-pager-older-link, #blog-pager-newer-link { float: none; } .gplus-profile { background-color: #fafafa; border: 1px solid #eee; overflow: hidden; width: 212px; } .gplus-profile-inner { margin-left: -1px; margin-top: -1px; } /* Sidebar follow buttons. */ .followgooglewrapper { padding: 12px 0 0 0; } .loading { visibility: hidden; } .detail-page .post-footer .cmt_iframe_holder { padding-top: 40px !important; } /** Desktop **/ @media (max-width: 900px) { .col-right { display: none; } .col-main { margin-right: 0; min-width: initial; } .footer-outer { display: none; } .cols-wrapper { min-width: initial; } .google-footer-outer { background-color: #f5f5f5; } } /** Tablet **/ @media (max-width: 712px) { .header-outer, .cols-wrapper, .footer-outer, .google-footer-outer { padding: 0 40px; } } /* An extra breakpoint accommodating for long blog titles. */ @media (max-width: 600px) { .header-left { height: 100%; top: inherit; margin-top: 0; -webkit-transform: initial; transform: initial; } .header-title { margin-top: 18px; } .header-inner .google-logo { height: 42px; margin-top: 3px; } .header-inner .google-logo img { height: 42px; } .header-title h2 { font-size: 32px; line-height: 48px; } .header-desc { bottom: 24px; position: absolute; } } /** Mobile/small desktop window; also landscape. **/ @media (max-width: 480px), (max-height: 480px) { .header-outer, .cols-wrapper, .footer-outer, .google-footer-outer { padding: 0 16px; } .cols-wrapper { margin-top: 0; } .post-header .publishdate, .post .post-content { font-size: 16px; } .post .post-content { line-height: 28px; margin-bottom: 30px; } .post { margin-top: 30px; } .byline-author { display: block; font-size: 12px; line-height: 24px; margin-top: 6px; } #main .post .title a { font-weight: 500; color: #4c4c4c; color: rgba(0,0,0,.70); } #main .post .post-header { padding-bottom: 12px; } #main .post .post-header .published { margin-bottom: -8px; margin-top: 3px; } .post .read-more { display: block; margin-top: 14px; } .post .tr-caption { font-size: 12px; } #main .post .title a { font-size: 20px; line-height: 30px; } .post-content iframe { /* iframe won't keep aspect ratio when scaled down. */ max-height: 240px; } .post-content .separator img, .post-content .tr-caption-container img, .post-content iframe { margin-left: -16px; max-width: inherit; width: calc(100% + 32px); } .post-content table, .post-content td { width: 100%; } #blog-pager { margin: 0; padding: 16px 0; } /** List page tweaks. **/ .list-page .post-original { display: none; } .list-page .post-summary { display: block; } .list-page .comment-container { display: none; } .list-page #blog-pager { padding-top: 0; border: 0; margin-top: -8px; } .list-page .label-footer { display: none; } .list-page #main .post .post-footer { border-bottom: 1px solid #eee; margin: -16px 0 0 0; padding: 0 0 20px 0; } .list-page .post .share { display: none; } /** Detail page tweaks. **/ .detail-page .post-footer .cmt_iframe_holder { padding-top: 32px !important; } .detail-page .label-footer { margin-bottom: 0; } .detail-page #main .post .post-footer { padding-bottom: 0; } .detail-page #comments { display: none; } } [data-about-pullquote], [data-is-preview], [data-about-syndication] { display: none; } </style> <noscript> <style> .loading { visibility: visible }</style> </noscript> <script type='text/javascript'> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','https://www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-34322147-32', 'auto', 'blogger'); ga('blogger.send', 'pageview'); </script> <link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=35192255&zx=c47925fb-2fa7-46d6-8ba0-79598a455c65' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=35192255&zx=c47925fb-2fa7-46d6-8ba0-79598a455c65' rel='stylesheet'/></noscript> <meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/> <meta name='google-adsense-platform-domain' content='blogspot.com'/> </head> <body> <script type='text/javascript'> //<![CDATA[ var axel = Math.random() + ""; var a = axel * 10000000000000; document.write('<iframe src="https://2542116.fls.doubleclick.net/activityi;src=2542116;type=gblog;cat=googl0;ord=ord=' + a + '?" width="1" height="1" frameborder="0" style="display:none"></iframe>'); //]]> </script> <noscript> <img alt='' height='1' src='https://ad.doubleclick.net/ddm/activity/src=2542116;type=gblog;cat=googl0;ord=1?' width='1'/> </noscript>  <div class='header-outer'> <div class='header-inner'> <div class='section' id='header'><div class='widget Header' data-version='1' id='Header1'> <div class='header-left'> <div class='header-title'> <a class='google-logo' href='https://docs.googleblog.com/'> <img height="80" src="//1.bp.blogspot.com/-9v5ODBycbAE/VlVgh_dS9II/AAAAAAAAIQE/UxS3qUj0inQ/s1600-r/docs_suite_transparent_small.png"> </a> <a href='/.'> <h2> Google Docs Blog </h2> </a> </div> <div class='header-desc'> The official source for news, updates and tips about Docs, Sheets, Slides, Forms, and Keep. </div> </div> </div></div> </div> </div>  <div class='cols-wrapper loading'> <div class='col-main-wrapper'> <div class='col-main'> <div class='section' id='main'><div class='widget Blog' data-version='1' id='Blog1'> <div class='post' data-id='6854124935984152939' itemscope='' itemtype='http://schema.org/BlogPosting'> <h2 class='title' itemprop='name'> <a href='https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html' itemprop='url' title='Google Sheets: Do more with your data'> Google Sheets: Do more with your data </a> </h2> <div class='post-header'> <div class='published'> <span class='publishdate' itemprop='datePublished'> June 15, 2015 </span> </div> </div> <div class='post-body'> <div class='post-content' itemprop='articleBody'> <script type='text/template'> When you’re working with spreadsheets, it’s important to turn your raw data into a story. With today’s updates to Google Sheets on the web, you’ll find even more ways to visualize and analyze your data.<br /> <br /> <b>Customized charts, made easier </b><br /> Charts can make even the largest data sets digestible, so we’ve made a few improvements to help you highlight what’s most important.<br /> <br /> Starting today, you can add <a href="https://support.google.com/docs/answer/63824" target="_blank">data labels</a> to display the exact value of bars or points. And when you’re using line or scatter charts, you can change the shapes of your data points. Choose from stars, triangles, pentagons and more.<br /> <div style="text-align: center;"> <span id="docs-internal-guid-e7a72e1c-f839-5b8f-dc20-40c9b308ed62"><span style="background-color: white; color: #222222; font-family: Arial; font-size: 16px; vertical-align: baseline; white-space: pre-wrap;"><img height="435px;" src="https://lh3.googleusercontent.com/yYMrMijG2TEoROfConeLEKAwzAsn00DHqwdchRStbmW6ADkNL9swXReMj1QwuqOzukB8dAhIYulvyt7eTIlKvZf9RQfRbFrBUnIFHQbtxj12TAVAlsf0DiF25sZnpCGx8nWNuy0" style="-webkit-transform: rotate(0rad); border: none; transform: rotate(0rad);" width="624px;" /></span></span></div> <b>Your data, your way</b><br /> Today’s update also includes new tools for analyzing your spreadsheet data. For example, you can:<br /> <ul> <li>Preview formula results—instantly—as you type. This feature is especially useful for catching formula errors quickly and is unique to Sheets. </li> <li><a href="https://support.google.com/docs/answer/3540681" target="_blank">Filter</a> rows and columns by conditions, including “greater than” and “text contains.” This way you’ll only see the numbers, dates and text you need. </li> <li>Add <a href="https://support.google.com/docs/answer/1272907" target="_blank">calculated fields</a> to pivot tables when you want to apply formulas to pivot table data. </li> <li><span style="text-align: center;">Use the <a href="https://support.google.com/docs/answer/6167538" target="_blank">GETPIVOTDATA</a> function to more easily retrieve data from your pivot table. </span></li> </ul> <div style="text-align: center;"> <img height="421px;" src="https://lh5.googleusercontent.com/IJz2Avf7oyM_3foLv4RAmiIbxYkpo22chGaHfBb5aOVDgZ-7V-7Cj6KyPDnPMgAKgyUtha-bWCk3MMgZ2PtOcOUv--RXhk37qNWpVLP0N5TQa7scJn0Bx7IXCnYkqHDUmwnwkRU" style="-webkit-transform: rotate(0rad); border: none; color: #222222; font-family: Arial; font-size: 16px; text-align: center; transform: rotate(0rad); white-space: pre-wrap;" width="624px;" /></div> <div style="font-weight: bold;"> Collaborate, confidently </div> The more the merrier when it comes to collaborating in Sheets, but sometimes you need to take extra steps to preserve your hard work from accidental edits. With Sheets, you’ve been able to restrict editing to a specific set of users and a specific range, but now you can also warn folks who try to edit certain cells. This way you can collaborate with others, and remind everyone (even yourself) to edit with care.<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh09p7mIz5wYEMmU0jMVYVocg_W7ANJPnqc4as02Y27F1ARnVkRradQYdCKx0yPxdrCiZNGuLMHnDfSeNqOJG71B6uKCAbNQbPKjA3moqYn8qCq7ATE9wlS5fyLEnbKQio9pwGQ/s1600/Heads+Up.png.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="396" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh09p7mIz5wYEMmU0jMVYVocg_W7ANJPnqc4as02Y27F1ARnVkRradQYdCKx0yPxdrCiZNGuLMHnDfSeNqOJG71B6uKCAbNQbPKjA3moqYn8qCq7ATE9wlS5fyLEnbKQio9pwGQ/s640/Heads+Up.png.jpg" width="640" /></a><br /> Try these updated <a href="https://www.google.com/sheets/about/" target="_blank">Sheets</a> features on the web today and start telling better stories with your data.<br /> <br /> <br /> Posted by Dan Gundrum, Product Manager <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </script> <noscript> When you’re working with spreadsheets, it’s important to turn your raw data into a story. With today’s updates to Google Sheets on the web, you’ll find even more ways to visualize and analyze your data.<br /> <br /> <b>Customized charts, made easier </b><br /> Charts can make even the largest data sets digestible, so we’ve made a few improvements to help you highlight what’s most important.<br /> <br /> Starting today, you can add <a href="https://support.google.com/docs/answer/63824" target="_blank">data labels</a> to display the exact value of bars or points. And when you’re using line or scatter charts, you can change the shapes of your data points. Choose from stars, triangles, pentagons and more.<br /> <div style="text-align: center;"> <span id="docs-internal-guid-e7a72e1c-f839-5b8f-dc20-40c9b308ed62"><span style="background-color: white; color: #222222; font-family: Arial; font-size: 16px; vertical-align: baseline; white-space: pre-wrap;"><img height="435px;" src="https://lh3.googleusercontent.com/yYMrMijG2TEoROfConeLEKAwzAsn00DHqwdchRStbmW6ADkNL9swXReMj1QwuqOzukB8dAhIYulvyt7eTIlKvZf9RQfRbFrBUnIFHQbtxj12TAVAlsf0DiF25sZnpCGx8nWNuy0" style="-webkit-transform: rotate(0rad); border: none; transform: rotate(0rad);" width="624px;" /></span></span></div> <b>Your data, your way</b><br /> Today’s update also includes new tools for analyzing your spreadsheet data. For example, you can:<br /> <ul> <li>Preview formula results—instantly—as you type. This feature is especially useful for catching formula errors quickly and is unique to Sheets. </li> <li><a href="https://support.google.com/docs/answer/3540681" target="_blank">Filter</a> rows and columns by conditions, including “greater than” and “text contains.” This way you’ll only see the numbers, dates and text you need. </li> <li>Add <a href="https://support.google.com/docs/answer/1272907" target="_blank">calculated fields</a> to pivot tables when you want to apply formulas to pivot table data. </li> <li><span style="text-align: center;">Use the <a href="https://support.google.com/docs/answer/6167538" target="_blank">GETPIVOTDATA</a> function to more easily retrieve data from your pivot table. </span></li> </ul> <div style="text-align: center;"> <img height="421px;" src="https://lh5.googleusercontent.com/IJz2Avf7oyM_3foLv4RAmiIbxYkpo22chGaHfBb5aOVDgZ-7V-7Cj6KyPDnPMgAKgyUtha-bWCk3MMgZ2PtOcOUv--RXhk37qNWpVLP0N5TQa7scJn0Bx7IXCnYkqHDUmwnwkRU" style="-webkit-transform: rotate(0rad); border: none; color: #222222; font-family: Arial; font-size: 16px; text-align: center; transform: rotate(0rad); white-space: pre-wrap;" width="624px;" /></div> <div style="font-weight: bold;"> Collaborate, confidently </div> The more the merrier when it comes to collaborating in Sheets, but sometimes you need to take extra steps to preserve your hard work from accidental edits. With Sheets, you’ve been able to restrict editing to a specific set of users and a specific range, but now you can also warn folks who try to edit certain cells. This way you can collaborate with others, and remind everyone (even yourself) to edit with care.<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh09p7mIz5wYEMmU0jMVYVocg_W7ANJPnqc4as02Y27F1ARnVkRradQYdCKx0yPxdrCiZNGuLMHnDfSeNqOJG71B6uKCAbNQbPKjA3moqYn8qCq7ATE9wlS5fyLEnbKQio9pwGQ/s1600/Heads+Up.png.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="396" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh09p7mIz5wYEMmU0jMVYVocg_W7ANJPnqc4as02Y27F1ARnVkRradQYdCKx0yPxdrCiZNGuLMHnDfSeNqOJG71B6uKCAbNQbPKjA3moqYn8qCq7ATE9wlS5fyLEnbKQio9pwGQ/s640/Heads+Up.png.jpg" width="640" /></a><br /> Try these updated <a href="https://www.google.com/sheets/about/" target="_blank">Sheets</a> features on the web today and start telling better stories with your data.<br /> <br /> <br /> Posted by Dan Gundrum, Product Manager <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </noscript> </div> </div> <div class='share'> <span class='gplus-share social-wrapper' data-href='https://plus.google.com/share?url=https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html'> <img alt='Share on Google+' height='24' src='https://www.gstatic.com/images/branding/google_plus/2x/ic_w_post_gplus_black_24dp.png' width='24'/> </span> <span class='twitter-custom social-wrapper' data-href='http://twitter.com/share?text=Google Docs Blog:Google Sheets: Do more with your data&url=https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html&via=googledocs'> <img alt='Share on Twitter' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_twitter_black_24dp.png' width='24'/> </span> <span class='fb-custom social-wrapper' data-href='https://www.facebook.com/sharer.php?u=https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html'> <img alt='Share on Facebook' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_facebook_black_24dp.png' width='24'/> </span> </div> <div class='comment-container'> <i class='comment-img material-icons'>  </i> <span class='cmt_count_iframe_holder' data-count='0' data-onclick='' data-post-url='https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html' data-url='https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html' style='color: #4184F3;'></span> </div> <div class='post-footer'> <div class='cmt_iframe_holder' data-href='https://docs.googleblog.com/2015/06/google-sheets-do-more-with-your-data.html' data-viewtype='FILTERED_POSTMOD'></div> <a href='https://plus.google.com/112374322230920073195' rel='author' style='display:none;'> Google </a> <div class='label-footer'> <span class='labels-caption'> Labels: </span> <span class='labels'> <a class='label' href='https://docs.googleblog.com/search/label/google%20docs' rel='tag'> google docs </a> , <a class='label' href='https://docs.googleblog.com/search/label/Google%20Docs%20Blog' rel='tag'> Google Docs Blog </a> , <a class='label' href='https://docs.googleblog.com/search/label/sheets' rel='tag'> sheets </a> </span> </div> </div> </div> <div class='post' data-id='1155207071948455548' itemscope='' itemtype='http://schema.org/BlogPosting'> <h2 class='title' itemprop='name'> <a href='https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html' itemprop='url' title='Meet Alice Keeler: Google Certified Teacher, Author, and "Queen of Spreadsheets"'> Meet Alice Keeler: Google Certified Teacher, Author, and "Queen of Spreadsheets" </a> </h2> <div class='post-header'> <div class='published'> <span class='publishdate' itemprop='datePublished'> June 9, 2015 </span> </div> </div> <div class='post-body'> <div class='post-content' itemprop='articleBody'> <script type='text/template'> <i>Alice Keeler is a mother of five children, a Google Certified Teacher, and the author of the book “<a href="http://www.amazon.com/Things-You-Can-Google-Classroom/dp/098615542X/ref=asap_bc?ie=UTF8" target="_blank">50 Things You Can Do With Google Classroom</a>.” Recently we sat down with the self-proclaimed “Queen of Spreadsheets” to learn more about how she relies on (and pushes the boundaries of) Google Docs both in the classroom and in her busy everyday life. </i><br /> <i><br /></i> <i>We want to know how you use the Google Docs family of products, too, so share your own examples at <a href="http://plus.google.com/+googledocs" target="_blank">+GoogleDocs</a> or <a href="http://twitter.com/googledocs" target="_blank">@googledocs</a> with the hashtag #mygoogledocs. -Ed. </i><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="//4.bp.blogspot.com/-CKqhINIrps4/VXbwPj_HQyI/AAAAAAAAVwU/azAJYnD50KU/s1600/Alice-Keeler-Blog-Post-03%2B%25281%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="//4.bp.blogspot.com/-CKqhINIrps4/VXbwPj_HQyI/AAAAAAAAVwU/azAJYnD50KU/s640/Alice-Keeler-Blog-Post-03%2B%25281%2529.png" width="640"></a></div> <br /> <b> Tell us about yourself, the self proclaimed “Queen of Spreadsheets.” </b><br /> I am a mother of five children, have a master’s degree in educational media design and technology and am working on my doctorate in EdTech with an emphasis in games and simulation. While working on my masters degree in 2009, I realized the power of games to motivate students, so I’ve been working on applying gamification techniques and games in my instruction, built with <a href="//www.google.com/sheets/about" target="_blank">Sheets</a>.  <br /> <br /> I’m extremely high energy and I really enjoy innovating and sharing with teachers. I also have a unique talent: I can make people love data and spreadsheets. When you can get the information you need in the format that you need it, it’s truly exciting.<br /> <br /> <b>How does Google Docs fit into your teaching? </b><br /> Google Docs is essential for my instruction. I’ve been paperless for years and Google Docs makes that possible. If I were to choose one word that is most important when choosing tools for student use, I would say collaboration. Google Docs transforms group work from one student doing most of the work to a truly collaborative endeavor. Each student is able contribute concurrently to a single document; enhancing, adding, and editing work.<br /> <br /> <b>Tell us about one unconventional way you’re using Google Docs to teach. </b><br /> I use gamification techniques to motivate students. Rather than assignments, students have quests they can choose from, in a Google Sheet. Once a student selects a quest, they use a Google Form, linked in the spreadsheet, to turn in their quests. The ability to collect quests and have it neatly organized in one place saves me hours and hours of time.<br /> <br /> Collecting work this way allows me to give students choices in what they learn and to be more flexible with due dates, and grading and feedback become immensely easier. When having a classroom discussion, it’s important to give every student a chance to participate and have their voice heard. This is nearly impossible with a verbal discussion. Having students respond to discussion prompts in a <a href="https://goo.gl/AAtYwR" target="_blank">spreadsheet</a> not only allows me to hear from every student, but allows the entire class to hear from every student.<br /> <br /> <b>What are the three best tips you can suggest for teachers that are using Google Docs? </b><br /> First, give feedback via comments to students before they submit their work. I highly recommend learning the keyboard shortcuts for inserting a comment (Control Alt M) and closing a comment (Control Enter) as this significantly speeds up the feedback process.<br /> <br /> Second, a kid’s best day is when they can teach you something. Don’t be afraid to try something you do not know, embrace and celebrate help from your students. Challenge them to teach you something new about using Google Docs.<br /> <br /> And third, if you use Google Slides or Google Sheets as a collaborative document with all of your students, this gives you only one document that you have to assess. Look for opportunities to do collaborative activities using Sheets and Slides.<br /> <iframe allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/lgN5RAKvAbQ" width="640"></iframe> <b>You have a big family and a ton of extracurricular activities—do you also use Google Docs to take care of things outside of school? </b><br /> I use Google Docs for everything. Woe to anyone standing next to me in the grocery line or driving me in a taxi—I will tell you all about Google Docs and how it will change your life. I have a passion for helping find creative solutions to whatever problem someone has—and educator or not, more often than not the solution is a Google Doc. I used to make wedding cakes and created a massive <a href="https://goo.gl/yt9g7L" target="_blank">spreadsheet</a> that calculates the number of servings, the supplies I need, how much to charge, creates the invoice and more. Really, what can you not do with Google Docs?<br /> <br /> <b>Do you have any handy docs to share?</b><br /> Teachers may be interested in creating rubrics with Google Sheets. This <a href="https://goo.gl/Zwbf4e" target="_blank">template</a> allows you to create a rubric on the second tab and set the percentages for each category. Insert your class roster on the first tab and use the “Create Rubrics” menu to create a copy of the rubric for each student in your class. This makes it easy to assess students using a rubric. <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </script> <noscript> <i>Alice Keeler is a mother of five children, a Google Certified Teacher, and the author of the book “<a href="http://www.amazon.com/Things-You-Can-Google-Classroom/dp/098615542X/ref=asap_bc?ie=UTF8" target="_blank">50 Things You Can Do With Google Classroom</a>.” Recently we sat down with the self-proclaimed “Queen of Spreadsheets” to learn more about how she relies on (and pushes the boundaries of) Google Docs both in the classroom and in her busy everyday life. </i><br /> <i><br /></i> <i>We want to know how you use the Google Docs family of products, too, so share your own examples at <a href="http://plus.google.com/+googledocs" target="_blank">+GoogleDocs</a> or <a href="http://twitter.com/googledocs" target="_blank">@googledocs</a> with the hashtag #mygoogledocs. -Ed. </i><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="//4.bp.blogspot.com/-CKqhINIrps4/VXbwPj_HQyI/AAAAAAAAVwU/azAJYnD50KU/s1600/Alice-Keeler-Blog-Post-03%2B%25281%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="//4.bp.blogspot.com/-CKqhINIrps4/VXbwPj_HQyI/AAAAAAAAVwU/azAJYnD50KU/s640/Alice-Keeler-Blog-Post-03%2B%25281%2529.png" width="640"></a></div> <br /> <b> Tell us about yourself, the self proclaimed “Queen of Spreadsheets.” </b><br /> I am a mother of five children, have a master’s degree in educational media design and technology and am working on my doctorate in EdTech with an emphasis in games and simulation. While working on my masters degree in 2009, I realized the power of games to motivate students, so I’ve been working on applying gamification techniques and games in my instruction, built with <a href="//www.google.com/sheets/about" target="_blank">Sheets</a>.  <br /> <br /> I’m extremely high energy and I really enjoy innovating and sharing with teachers. I also have a unique talent: I can make people love data and spreadsheets. When you can get the information you need in the format that you need it, it’s truly exciting.<br /> <br /> <b>How does Google Docs fit into your teaching? </b><br /> Google Docs is essential for my instruction. I’ve been paperless for years and Google Docs makes that possible. If I were to choose one word that is most important when choosing tools for student use, I would say collaboration. Google Docs transforms group work from one student doing most of the work to a truly collaborative endeavor. Each student is able contribute concurrently to a single document; enhancing, adding, and editing work.<br /> <br /> <b>Tell us about one unconventional way you’re using Google Docs to teach. </b><br /> I use gamification techniques to motivate students. Rather than assignments, students have quests they can choose from, in a Google Sheet. Once a student selects a quest, they use a Google Form, linked in the spreadsheet, to turn in their quests. The ability to collect quests and have it neatly organized in one place saves me hours and hours of time.<br /> <br /> Collecting work this way allows me to give students choices in what they learn and to be more flexible with due dates, and grading and feedback become immensely easier. When having a classroom discussion, it’s important to give every student a chance to participate and have their voice heard. This is nearly impossible with a verbal discussion. Having students respond to discussion prompts in a <a href="https://goo.gl/AAtYwR" target="_blank">spreadsheet</a> not only allows me to hear from every student, but allows the entire class to hear from every student.<br /> <br /> <b>What are the three best tips you can suggest for teachers that are using Google Docs? </b><br /> First, give feedback via comments to students before they submit their work. I highly recommend learning the keyboard shortcuts for inserting a comment (Control Alt M) and closing a comment (Control Enter) as this significantly speeds up the feedback process.<br /> <br /> Second, a kid’s best day is when they can teach you something. Don’t be afraid to try something you do not know, embrace and celebrate help from your students. Challenge them to teach you something new about using Google Docs.<br /> <br /> And third, if you use Google Slides or Google Sheets as a collaborative document with all of your students, this gives you only one document that you have to assess. Look for opportunities to do collaborative activities using Sheets and Slides.<br /> <iframe allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/lgN5RAKvAbQ" width="640"></iframe> <b>You have a big family and a ton of extracurricular activities—do you also use Google Docs to take care of things outside of school? </b><br /> I use Google Docs for everything. Woe to anyone standing next to me in the grocery line or driving me in a taxi—I will tell you all about Google Docs and how it will change your life. I have a passion for helping find creative solutions to whatever problem someone has—and educator or not, more often than not the solution is a Google Doc. I used to make wedding cakes and created a massive <a href="https://goo.gl/yt9g7L" target="_blank">spreadsheet</a> that calculates the number of servings, the supplies I need, how much to charge, creates the invoice and more. Really, what can you not do with Google Docs?<br /> <br /> <b>Do you have any handy docs to share?</b><br /> Teachers may be interested in creating rubrics with Google Sheets. This <a href="https://goo.gl/Zwbf4e" target="_blank">template</a> allows you to create a rubric on the second tab and set the percentages for each category. Insert your class roster on the first tab and use the “Create Rubrics” menu to create a copy of the rubric for each student in your class. This makes it easy to assess students using a rubric. <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </noscript> </div> </div> <div class='share'> <span class='gplus-share social-wrapper' data-href='https://plus.google.com/share?url=https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html'> <img alt='Share on Google+' height='24' src='https://www.gstatic.com/images/branding/google_plus/2x/ic_w_post_gplus_black_24dp.png' width='24'/> </span> <span class='twitter-custom social-wrapper' data-href='http://twitter.com/share?text=Google Docs Blog:Meet Alice Keeler: Google Certified Teacher, Author, and "Queen of Spreadsheets"&url=https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html&via=googledocs'> <img alt='Share on Twitter' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_twitter_black_24dp.png' width='24'/> </span> <span class='fb-custom social-wrapper' data-href='https://www.facebook.com/sharer.php?u=https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html'> <img alt='Share on Facebook' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_facebook_black_24dp.png' width='24'/> </span> </div> <div class='comment-container'> <i class='comment-img material-icons'>  </i> <span class='cmt_count_iframe_holder' data-count='0' data-onclick='' data-post-url='https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html' data-url='https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html' style='color: #4184F3;'></span> </div> <div class='post-footer'> <div class='cmt_iframe_holder' data-href='https://docs.googleblog.com/2015/06/meet-alice-keeler-google-certified.html' data-viewtype='FILTERED_POSTMOD'></div> <a href='https://plus.google.com/112374322230920073195' rel='author' style='display:none;'> Google </a> <div class='label-footer'> <span class='labels-caption'> Labels: </span> <span class='labels'> <a class='label' href='https://docs.googleblog.com/search/label/docs' rel='tag'> docs </a> , <a class='label' href='https://docs.googleblog.com/search/label/Google%20Docs%20Blog' rel='tag'> Google Docs Blog </a> , <a class='label' href='https://docs.googleblog.com/search/label/google%20for%20edu' rel='tag'> google for edu </a> , <a class='label' href='https://docs.googleblog.com/search/label/mygoogledocs' rel='tag'> mygoogledocs </a> , <a class='label' href='https://docs.googleblog.com/search/label/sheets' rel='tag'> sheets </a> , <a class='label' href='https://docs.googleblog.com/search/label/slides' rel='tag'> slides </a> , <a class='label' href='https://docs.googleblog.com/search/label/teachers' rel='tag'> teachers </a> </span> </div> </div> </div> <div class='post' data-id='7268082285446268439' itemscope='' itemtype='http://schema.org/BlogPosting'> <h2 class='title' itemprop='name'> <a href='https://docs.googleblog.com/2015/01/updated-mobile-apps.html' itemprop='url' title='Updated mobile apps for Docs, Sheets and Slides'> Updated mobile apps for Docs, Sheets and Slides </a> </h2> <div class='post-header'> <div class='published'> <span class='publishdate' itemprop='datePublished'> January 21, 2015 </span> </div> </div> <div class='post-body'> <div class='post-content' itemprop='articleBody'> <script type='text/template'> With Google Docs we want to help you work better, everywhere you are. So today’s Android and iOS updates for <a href="//www.google.com/docs/about/" target="_blank">Docs</a>, <a href="//www.google.com/sheets/about/" target="_blank">Sheets</a> and <a href="//www.google.com/slides/about/" target="_blank">Slides</a> make it easier to get things done while you’re on the go.  <br /> <br /> <b>Doing, not just viewing </b><br /> You’ve asked for more editing tools on mobile, so today’s improvements include real-time spell-checking in documents, hiding rows and columns in spreadsheets, and grouping shapes in presentations.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihssFlAbGIx_CR-e1rzPyhibPAzq8aUAa8fuHof0RyNx6hNPeT32x0H4EF6zZ-7NOwJup_H1jDnkSdRM3-qTE_g_22CnMWL_c6GoonlyvS-3OW-ejqDBF8sgay7TNtUozCwyco/s1600/test4.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihssFlAbGIx_CR-e1rzPyhibPAzq8aUAa8fuHof0RyNx6hNPeT32x0H4EF6zZ-7NOwJup_H1jDnkSdRM3-qTE_g_22CnMWL_c6GoonlyvS-3OW-ejqDBF8sgay7TNtUozCwyco/s1600/test4.gif" width="225" /></a></div> <b>Keeping your content safe </b><br /> Online security is <a href="https://www.google.com/safetycenter/" target="_blank">really important</a>, so we offer functionality like <a href="//www.google.com/intl/en/landing/2step/" target="_blank">two-step verification</a> to protect your Google account. Starting today, Google Docs supports Touch ID on iOS, so you can unlock Docs, Sheets and Slides with your unique fingerprint.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBPq3izFtbC4BUPd-onASdZC6_eQvgqifT7tn9JQ5FWwsg1u_tbyK8dDVkz8QhFhPdvfLmYi3uUxZLsRSkuntB53i9vdF3t402TcNUJbc0nzIaNBHJXquUx9TIAV9CzFGqb2SW/s1600/touchID_slides.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBPq3izFtbC4BUPd-onASdZC6_eQvgqifT7tn9JQ5FWwsg1u_tbyK8dDVkz8QhFhPdvfLmYi3uUxZLsRSkuntB53i9vdF3t402TcNUJbc0nzIaNBHJXquUx9TIAV9CzFGqb2SW/s1600/touchID_slides.png" width="225" /></a></div> <b>Making everything more accessible</b><br /> If you’re blind or have low vision, we have improved support and performance for <a href="https://play.google.com/store/apps/details?id=com.google.android.marvin.talkback&hl=en" target="_blank">TalkBack</a> on Android and <a href="https://www.apple.com/accessibility/ios/voiceover/" target="_blank">VoiceOver</a> on iOS to create, edit, and share files in Docs, Sheets and Slides. The updated apps also respond well to screen magnification, in case you need to zoom in for a closer look.<br /> <br /> These updates are rolling out now, so look for them on <a href="https://play.google.com/store/apps/collection/promotion_3000684_new_google_docs" target="_blank">Google Play</a> and the App Store (<a href="https://itunes.apple.com/us/app/google-docs/id842842640?mt=8" target="_blank">Docs</a>, <a href="https://itunes.apple.com/us/app/google-sheets/id842849113?mt=8" target="_blank">Sheets</a>, <a href="https://itunes.apple.com/us/app/google-slides/id879478102?mt=8" target="_blank">Slides</a>), and download the new versions as they become available. For even more news and tips, you can now follow Google Docs on <a href="https://plus.google.com/112520969446868076741/about" target="_blank">Google+</a>, <a href="http://www.twitter.com/googledocs" target="_blank">Twitter</a> and <a href="https://www.facebook.com/googledocsofficial" target="_blank">Facebook</a>.<br /> <br /> Posted by Jude Flannery, Engineering Director <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </script> <noscript> With Google Docs we want to help you work better, everywhere you are. So today’s Android and iOS updates for <a href="//www.google.com/docs/about/" target="_blank">Docs</a>, <a href="//www.google.com/sheets/about/" target="_blank">Sheets</a> and <a href="//www.google.com/slides/about/" target="_blank">Slides</a> make it easier to get things done while you’re on the go.  <br /> <br /> <b>Doing, not just viewing </b><br /> You’ve asked for more editing tools on mobile, so today’s improvements include real-time spell-checking in documents, hiding rows and columns in spreadsheets, and grouping shapes in presentations.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihssFlAbGIx_CR-e1rzPyhibPAzq8aUAa8fuHof0RyNx6hNPeT32x0H4EF6zZ-7NOwJup_H1jDnkSdRM3-qTE_g_22CnMWL_c6GoonlyvS-3OW-ejqDBF8sgay7TNtUozCwyco/s1600/test4.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihssFlAbGIx_CR-e1rzPyhibPAzq8aUAa8fuHof0RyNx6hNPeT32x0H4EF6zZ-7NOwJup_H1jDnkSdRM3-qTE_g_22CnMWL_c6GoonlyvS-3OW-ejqDBF8sgay7TNtUozCwyco/s1600/test4.gif" width="225" /></a></div> <b>Keeping your content safe </b><br /> Online security is <a href="https://www.google.com/safetycenter/" target="_blank">really important</a>, so we offer functionality like <a href="//www.google.com/intl/en/landing/2step/" target="_blank">two-step verification</a> to protect your Google account. Starting today, Google Docs supports Touch ID on iOS, so you can unlock Docs, Sheets and Slides with your unique fingerprint.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBPq3izFtbC4BUPd-onASdZC6_eQvgqifT7tn9JQ5FWwsg1u_tbyK8dDVkz8QhFhPdvfLmYi3uUxZLsRSkuntB53i9vdF3t402TcNUJbc0nzIaNBHJXquUx9TIAV9CzFGqb2SW/s1600/touchID_slides.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBPq3izFtbC4BUPd-onASdZC6_eQvgqifT7tn9JQ5FWwsg1u_tbyK8dDVkz8QhFhPdvfLmYi3uUxZLsRSkuntB53i9vdF3t402TcNUJbc0nzIaNBHJXquUx9TIAV9CzFGqb2SW/s1600/touchID_slides.png" width="225" /></a></div> <b>Making everything more accessible</b><br /> If you’re blind or have low vision, we have improved support and performance for <a href="https://play.google.com/store/apps/details?id=com.google.android.marvin.talkback&hl=en" target="_blank">TalkBack</a> on Android and <a href="https://www.apple.com/accessibility/ios/voiceover/" target="_blank">VoiceOver</a> on iOS to create, edit, and share files in Docs, Sheets and Slides. The updated apps also respond well to screen magnification, in case you need to zoom in for a closer look.<br /> <br /> These updates are rolling out now, so look for them on <a href="https://play.google.com/store/apps/collection/promotion_3000684_new_google_docs" target="_blank">Google Play</a> and the App Store (<a href="https://itunes.apple.com/us/app/google-docs/id842842640?mt=8" target="_blank">Docs</a>, <a href="https://itunes.apple.com/us/app/google-sheets/id842849113?mt=8" target="_blank">Sheets</a>, <a href="https://itunes.apple.com/us/app/google-slides/id879478102?mt=8" target="_blank">Slides</a>), and download the new versions as they become available. For even more news and tips, you can now follow Google Docs on <a href="https://plus.google.com/112520969446868076741/about" target="_blank">Google+</a>, <a href="http://www.twitter.com/googledocs" target="_blank">Twitter</a> and <a href="https://www.facebook.com/googledocsofficial" target="_blank">Facebook</a>.<br /> <br /> Posted by Jude Flannery, Engineering Director <span itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <meta content='https://plus.google.com/116899029375914044550' itemprop='url'/> </span> </noscript> </div> </div> <div class='share'> <span class='gplus-share social-wrapper' data-href='https://plus.google.com/share?url=https://docs.googleblog.com/2015/01/updated-mobile-apps.html'> <img alt='Share on Google+' height='24' src='https://www.gstatic.com/images/branding/google_plus/2x/ic_w_post_gplus_black_24dp.png' width='24'/> </span> <span class='twitter-custom social-wrapper' data-href='http://twitter.com/share?text=Google Docs Blog:Updated mobile apps for Docs, Sheets and Slides&url=https://docs.googleblog.com/2015/01/updated-mobile-apps.html&via=googledocs'> <img alt='Share on Twitter' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_twitter_black_24dp.png' width='24'/> </span> <span class='fb-custom social-wrapper' data-href='https://www.facebook.com/sharer.php?u=https://docs.googleblog.com/2015/01/updated-mobile-apps.html'> <img alt='Share on Facebook' height='24' src='https://www.gstatic.com/images/icons/material/system/2x/post_facebook_black_24dp.png' width='24'/> </span> </div> <div class='comment-container'> <i class='comment-img material-icons'>  </i> <span class='cmt_count_iframe_holder' data-count='0' data-onclick='' data-post-url='https://docs.googleblog.com/2015/01/updated-mobile-apps.html' data-url='https://docs.googleblog.com/2015/01/updated-mobile-apps.html' style='color: #4184F3;'></span> </div> <div class='post-footer'> <div class='cmt_iframe_holder' data-href='https://docs.googleblog.com/2015/01/updated-mobile-apps.html' data-viewtype='FILTERED_POSTMOD'></div> <a href='https://plus.google.com/112374322230920073195' rel='author' style='display:none;'> Google </a> <div class='label-footer'> <span class='labels-caption'> Labels: </span> <span class='labels'> <a class='label' href='https://docs.googleblog.com/search/label/accessibility' rel='tag'> accessibility </a> , <a class='label' href='https://docs.googleblog.com/search/label/android' rel='tag'> android </a> , <a class='label' href='https://docs.googleblog.com/search/label/docs' rel='tag'> docs </a> , <a class='label' href='https://docs.googleblog.com/search/label/Google%20Docs%20Blog' rel='tag'> Google Docs Blog </a> , <a class='label' href='https://docs.googleblog.com/search/label/ios' rel='tag'> ios </a> , <a class='label' href='https://docs.googleblog.com/search/label/mobile' rel='tag'> mobile </a> , <a class='label' href='https://docs.googleblog.com/search/label/sheets' rel='tag'> sheets </a> , <a class='label' href='https://docs.googleblog.com/search/label/slides' rel='tag'> slides </a> </span> </div> </div> </div> <div class='blog-pager' id='blog-pager'> <a class='home-link' href='https://docs.googleblog.com/'> <i class='material-icons'>  </i> </a> <i class='material-icons disabled'>  </i> <i class='material-icons disabled'>  </i> </div> <div class='clear'></div> </div></div> </div> </div> <div class='col-right'> <div class='section' id='sidebar-top'><div class='widget HTML' data-version='1' id='HTML8'> <div class='widget-content'> <div class='searchBox'> <input type='text' title='Search This Blog' placeholder='Search blog ...' /> </div> </div> <div class='clear'></div> </div></div> <div id='aside'> <div class='section' id='sidebar'> <div class='widget Label' data-version='1' id='Label1'> <div class='tab'> <img class='sidebar-icon' src='data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAYpJREFUeNrs2aFuwzAQBmAvKRkMKRjZA4QMDJaWFgyMjuzFRg37DIUlA3uFkoGQSaWzJU+tpri5O9+l/zSfdFJlpe59yTmyVedq1PjfcZMZ70NuQnaF8w8htyE/rABtpviXkLcK88c5HhLkMBfgVan43zfFBNGMjHVGT/s55KP2pAvidbGHd+nzKt1RKSLG3rKF1iPFv6UWiPke8i7kEqGdGsI1O+LYVdqJAjgirwkKYD0ytkJBUNbAMvX8V3q9PhUsYvU1sWD8SO/sQvx2ahxOiNoJCSBCoAHYCEQAC4EKICOQASQEOmAS8RcAFxFN5hiIiugpgC3wk9hQAHH/70EBHXUN7IER5EWMiBgo2+nzOKQv9SCAeEM/OQAkhE/ncccFICB87qzQMia5FsJfOui0zMnmRvipU1ormHQuxGTxUsAcCFLxJQBLBLn4UoAFglW8BkATwS5eC6CBEBWvCShBiIvXBkgQRcVbADiI4uKtABSESvGWgB9EzHt3+tNwyO0qa9SoIYtvAQYAqDJhaWWeMecAAAAASUVORK5CYII='/> <h2> Labels </h2> <i class='material-icons arrow'>  </i> </div> <div class='widget-content list-label-widget-content'> <ul> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/accessibility'> accessibility </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/android'> android </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/collab'> collab </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/collaboration'> collaboration </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/constitute'> constitute </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/docs'> docs </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/google%20docs'> google docs </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/Google%20Docs%20Blog'> Google Docs Blog </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/Google%20Docs%20in%20the%20wild'> Google Docs in the wild </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/google%20for%20edu'> google for edu </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/ios'> ios </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/keep'> keep </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/mobile'> mobile </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/mygoogledocs'> mygoogledocs </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/nanowrimo'> nanowrimo </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/national%20constitution%20center'> national constitution center </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/presentations'> presentations </a> </li> <li> <span dir='ltr'> sheets </span> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/slides'> slides </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/teachers'> teachers </a> </li> <li> <a dir='ltr' href='https://docs.googleblog.com/search/label/writing'> writing </a> </li> </ul> <div class='clear'></div> </div> </div><div class='widget BlogArchive' data-version='1' id='BlogArchive1'> <div class='tab'> <i class='material-icons icon'>  </i> <h2> Archive </h2> <i class='material-icons arrow'>  </i> </div> <div class='widget-content'> <div id='ArchiveList'> <div id='BlogArchive1_ArchiveList'> <ul class='hierarchy'> <li class='archivedate expanded'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy toggle-open'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/'> 2016 </a> </div> <div class='items'> <ul class='hierarchy'> <li class='archivedate expanded'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy toggle-open'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/09/'> September </a> </div> <div class='items'> <ul class='posts'> <li> <a href='https://docs.googleblog.com/2016/09/ExploreinDocsSheetsSlides.html'> Explore in Docs, Sheets and Slides makes work a br... </a> </li> </ul> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/07/'> July </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/06/'> June </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/05/'> May </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/04/'> April </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/03/'> March </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/02/'> February </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2016/01/'> January </a> </div> <div class='items'> </div> </li> </ul> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/'> 2015 </a> </div> <div class='items'> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/10/'> October </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/09/'> September </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/08/'> August </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/07/'> July </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/06/'> June </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/05/'> May </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/03/'> March </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/02/'> February </a> </div> <div class='items'> </div> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <div class='intervalToggle'> <span class='new-toggle' href='javascript:void(0)'> <i class='material-icons arrow'>  </i> </span> <a class='toggle' href='javascript:void(0)' style='display: none'> <span class='zippy'> <i class='material-icons'>  </i>   </span> </a> <a class='post-count-link' href='https://docs.googleblog.com/2015/01/'> January </a> </div> <div class='items'> </div> </li> </ul> </div> </li> </ul> </div> </div> <div class='clear'></div> </div> </div><div class='widget HTML' data-version='1' id='HTML6'> <div class='widget-content'> <a href="http://googledocs.blogspot.com/atom.xml"> <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAihJREFUeNrsWa9Pw0AU7viRMDFRBAkzJDMIBIhJJhCzk7NILIqMv4AEhdz+BCY3OYssAlGBoAJREpZwAlHEBO8lr8nSvNeVbu1dyX3JlzTrXfa+u/e9d7c5joWFhYVO1Fa8PwH2gK6m+BRwAvSlAdsrgr8E1jUuMH73GTAEzrkBWymTewZlihhLmgDXIAFuHgGVQOUF7OSYM1p6PgTuA1vAZlUEvAnPdapcMY0VICECekQ0XRfYrqoHsAGNgXfAoMomRiFDEhOZkkL3S88hMaB2LwXp0bj+ps2edpToZpjfoIDQtBeU+xjoDzP2G/gCPKZ5f8WsCAFJoJgOCcFdWSTeL9YQMSvTA1h9BkI5jaiXhLpSCL/8mVZY0UpyJ9ZdOkniu1dmJ96BpzQu9w6s28gcOq9j6pwLdR8/36NK5CQKwJSMrb2MhhSglBpt4UjsrdsnNu0B3J0HCozbCc4TjyY2srEgos/4RQljCzNxl4ireQD8FOq+T+W0mTB2g7njhlR+Sy2jsXFvU658U8YTbeaGpdIu7mWkEAq5ZtIjIhFZdtfX7QHckSvB2B6zC3VdAkZk0kAQwaXTk/CzTXK3wjIExCs6ZJpTnE4uY1KV+KzFzA3KTiFPENHJkOPcsfpLhwe4btoSuvUqAR+6TOxlCE6ZfKUsJLgsqGW8OpqAGx2X+sLxrwUog+JUeQRMDBIwyXOcnlPtPnL0/UsT/8LnOxYWFhZG4leAAQAAQHEaYuzHbAAAAABJRU5ErkJggg==" class="sidebar-icon" /> <h2>Feed</h2> </a> </div> <div class='clear'></div> </div></div> <div class='section' id='sidebar-bottom'><div class='widget HTML' data-version='1' id='HTML5'> <div class='widget-content'> <div class="followgooglewrapper"> <a href="https://plus.google.com/+GoogleDocs" rel="publisher" style="text-decoration:none;display:inline-block;color:#333;text-align:center; font:13px/16px arial,sans-serif;white-space:nowrap;"> <span style="display:inline-block;font-weight:bold;vertical-align:top;margin-right:5px; margin-top:0px;">Google</span><span style="display:inline-block;vertical-align:top;margin-right:13px; margin-top:0px;">on</span> <img src="//ssl.gstatic.com/images/icons/gplus-16.png" alt="Google+" style="border:0;width:16px;height:16px;"/></a> </div>  <div class="share followgooglewrapper"> <button data-href="https://twitter.com/intent/follow?original_referer=http://googledevjp.blogspot.in/&screen_name=googledocs" onclick='sharingPopup(this);' id='twitter-share'><span class="twitter-follow">Follow @googledocs</span></button> <script> function sharingPopup (button) { var url = button.getAttribute("data-href"); window.open( url,'popUpWindow','height=500,width=500,left=10,top=10,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes'); } </script> </div>  <div class="fb-follow-button"> <a href="https://www.facebook.com/googledocsofficial" target="_blank"><img class="fb-follow" src="//3.bp.blogspot.com/-HoA5kIzCDV0/VVNMgZYYShI/AAAAAAAAHh0/7t0oglZ-RVU/s1600/fb.png">Follow</a> </div> </div> <div class='clear'></div> </div></div> </div> </div> <div style='clear:both;'></div> </div>  <div class='footer-outer loading'> <div class='footer-inner'> <div class='footer-inner-2'> <div style='width:33%;float:left;'> <div class='section' id='footer-1'><div class='widget HTML' data-version='1' id='HTML2'> <h2 class='title'> Company-wide </h2> <div class='widget-content'> <ul> <li> <a href="//googleblog.blogspot.com/" title="Official Google">Official Google Blog</a> </li> <li> <a href="//googleatwork.blogspot.com/" title="Google at Work">Google at Work Blog</a> </li> <li> <a href="//googleforstudents.blogspot.com/" title="Student">Student Blog</a> </li> </ul> </div> <div class='clear'></div> </div></div> </div> <div style='width:33%;float:left;'> <div class='section' id='footer-2'><div class='widget HTML' data-version='1' id='HTML3'> <h2 class='title'> Products </h2> <div class='widget-content'> <ul> <li> <a href="//googledrive.blogspot.com/" title="Drive">Drive Blog</a> </li> <li> <a href="//officialandroid.blogspot.com/" title="Android">Official Android Blog</a> </li> <li> <a href="//chrome.blogspot.com/" title="Chrome">Chrome Blog</a> </li> </ul> </div> <div class='clear'></div> </div></div> </div> <div style='width:33%;float:left;'> <div class='section' id='footer-3'><div class='widget HTML' data-version='1' id='HTML4'> <h2 class='title'> Developers </h2> <div class='widget-content'> <ul> <li> <a href="//googledevelopers.blogspot.com/" title="Developers">Developers Blog</a> </li> <li> <a href="//android-developers.blogspot.com/" title="Android">Android Developers Blog</a> </li> <li> <a href="//googleappsdeveloper.blogspot.com/" title="Apps Developer">Apps Developer Blog</a> </li> </ul> </div> <div class='clear'></div> </div></div> </div> <div style='clear:both;'></div> </div> </div> </div> <div class='google-footer-outer loading'> <div id='google-footer'> <a href='//www.google.com/'> <img class='google-logo-dark' height='36' src='data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALgAAABICAYAAABFoT/eAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAACLVJREFUeNrsXd+L20YQ3vOprdLqiMXFXE2qB7dcwEcTSB7ykIc+9A/PQx/yEMq1TWhNuYIpJriNr7XpmZ5IxFEvmW2EKs3Ornb1w50PxIFP0kiz387OzM6uhGAwGAxGP3Ho+f7x7ri1O7LdccPqZjSNA4dEHsLfaHcEFedJom93x9Xu2OyOFTcBo6sED3fHZHeMEELrkAHJF0B8Rr+gDFsZ5n0luLTQ95AXs4W06D/tjpR50xtM4CjD0y48YGB4rnyZxNOzyA7zBHr+nLnDaJLg0mo/ALekCasg3Z4XbM0ZdTEgnDPeHY8bIne+Qz2GvwyGNwsuyT218KWvIIBMcwGpLiipcolecjMxfBDchNyS1EvxLiOSIecp31q6IJ/C3yrIrMqMm4jhg+AxkdwbIO3aUO4KjqqMjCT3uaazMBhWBJfuxH3CtRfiXf66DhSRZWbmlMnNaILgZxrXJQO/eO3wORZwvwm4JUxuhheCjzVBYAbW1ces45YDSoZrFNOEE835M8FT6oyeEnws8Fz3QnBxFKPHBMem4GU+m6fPGb0leCTwWcM5B36MPgeZI01gudyDdw3hPeXfo8L/rmCUWnuMMdqUL2WqWeRbhf+twfVsO7YagZGNC79fw7OthEVtkiJ4jJzTd3KPwf3CRqhhiTu23AP5sl0/0xiwISQXpNwLIJK87mHF+U8ddzzdmgKlGzlPYjyxGJQouIhNT4k9AqWEFkqfguIvagTWbcq3KW1WE3xS3m8NtA9WS451xofwjKT5kkDoK/b6mDk5FfXr1lWDL4BofZEv2/SRsK/EHGlGdBdu8QNRb8HMCFwt7Yy3DDI/QP7fx5z3VLhdlJEIs4rKNuXXJXdxZPdB7kfCzWqwCO4V1LHgLjInX3tQ1KzCR52Cz+vDj1dydeRuS74rcvs2Pi6fT5H8OaaUQPQPYcWwRSGXyhhscn5dpAnEFMkuEZetbfkTAnlSuH4DxisE+aMGeJAQ3lFl7C4LJE6QWCaCd583ORQ1jYAwjFctal7nOs2ZZvicwvlZx+RHGrcoAwKUVX8uwcc/9TT65INeDOr5shL9LDRB6QTeIy3zwfdh3WOi6axLCEhSjXU7F3h6LqggUtvyJxpynwu8tDkD98fXApOxRj8zoZ9MnGveYVIVZKaGrkBXCY65BCYNN9NkjpKOyQ81Q79JgdxS+Jn3SDTEXRI7SWzaiSTB32oI3nU3BvMfM0urhOVYgwKhuiAfc4tM07wXwm1ZRoQYSl2NUwiu01fEAHVcpixd745FvVz4dzUUc0o8rwoLy8ZSwU6CyFx1RP5II9+1bFPEFs9HWbNLiimDXE+vCm7u1CS47cofzD3aEhVY57mxRo5zlqdt+RFC1JUH2S7bcVXg4liTMakaBZZVxiTICRoivcn1sEUBlk24JmaC6kxUbYmWoqvyfck2xZGGnDFYa9MMzkYQ1ijkCX6qidybrgePiQ0QIQqoi6qRLeqQfIoRsEHaQJLBdHOnLGetSdm/IPcymJuS1PAnbQPH0MOw/39C1vL11DiLOqIsbDI8QcHvGiLnySi2qUXBicaqUSxN5LEB0g7Jt3ENXJLPJ5S1tnaZBoWbpRqrmjRE7qHmpSmNHdQcYrEUadoh+TbBnc9ri7iycI1kzPeNcLDIvbiqXpez9Tmdq6zGREPuzECBoxrPMiI2WtvyNwhJba2wy3JZ6ky5dD1lSvmZS3e4SPA1wcf1VTFHKX+cGwZzdUYcqpvUtvwrD/InDttVlyZeAKlNN5MKbAiurHhKIPlUuJvlTCCiDjSKSCsUmCFWbGLZwCESfK07JB8LvMYWVtw0D00JEHV8Mq2HkqPbE0oHLvvK2g0o8ETg+4cfwTlZDT9JDoWygu4uQQE/ivIvtcnfPkaCqhiupz7jWOAzqL/vjtcdkv9G4MVMt+EaylfuImiPAXEUjRF3pjjaHiPPZ6If9TGGAO4ZY0am6jOCb+DQ+ZCqLkIpOIPrdNfIjnFPY6nyFut7TS/fanrziOBOKMupKw94WaLMtuVnSFt9CPrWWdJE6PeltCX432DEBoh+5Dv8RRhdis8YAv9uyq4/JAwtlEApgBe9Cw9xDD3tdk4Jn0MDfiHwPHcRPxBePCMER3GuIx7kGlv9fkZ4V9lolx2Uv4X7hEj7qJ3LDoAMGbTRMRibu4L2xQ8bgt8AyU+Q+x7nYrvDnH4iuO5LxKsYwPVbkPMvKF9Zky9wXzRfVWizi62r9X5VHf55h+WHhDjGBZ4WRhyTr6z5SlCoLMxLSpBZFsQ9F80uQFbF/6aFWi+Ev51vzzsuX+msyzuQXXjUz8zEBy+zpq9yweXAoxJW4JbYrDS6gYDqGHxPl+TKeiBfxj9/EBIElPYeOA4y8/qRQfknjvSzgRgtq0Pw/M1eQeMdOSb2Bnrhr6Led+1vcp2x7oTFHMnedFW+Ivlty062BUt74oHgSj+vHepnhunn0JJAMtBZgDI/qmGtMujRv8DDpo47zBJ8UtPOuAR/7rKn8t9AJ0tBdmBAmJ/Fu71yxp4I3qh+DhyRqbi5Y1ShVPlSb8X7bRNcfgZFl+WRGYo7uecrWq1r8X5bhmzP5OdlDwsGRm1suSxkg5rYm7ConyGQ3Zl+DgSD8V/kPwrWBMG9YcBtyShBnTLdTiHgttw7qAW7cqh/ZnmPKr/6ignOaKsdyxbsToT5UkPsW00bJjijDXficcX/JsLs6w2BwGtherdckH3w/kNXRPVI0OqJQoHX42/66IMfMj/2huRjxIidgKV/W0JS+bsstDoTeAHcrI8E5zTh/sDkqxL5rZup55/3USlswfcHf4IrQplVDgW9XFlOqnwr6pVPMMEZTuC60EttvdzbLbaZ4PsFVa3nohhO+vW+yn/ZB2fUhpysmQrzBcTSai9EszuZMcEZ1lCFVrp9zGXhm69iLyY4oxFIa178lPe12I/P2DAYDAaDwWAwGAwGg8FgMBgMBoPBYDD2Cf8IMADDRGoQTe+E9AAAAABJRU5ErkJggg==' style='margin-top: -16px;' width='92'/> </a> <ul> <li> <a href='//www.google.com/'> Google </a> </li> <li> <a href='//www.google.com/policies/privacy/'> Privacy </a> </li> <li> <a href='//www.google.com/policies/terms/'> Terms </a> </li> </ul> </div> </div> <script type='text/javascript'> //<![CDATA[ // Social sharing popups. var postEl = document.getElementsByClassName('social-wrapper'); var postCount = postEl.length; for(i=0; i<postCount;i++){ postEl[i].addEventListener("click", function(event){ var postUrl = this.getAttribute("data-href"); window.open( postUrl,'popUpWindow','height=500,width=500,left=10,top=10,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes'); });} //]]> </script> <script type='text/javascript'> //<![CDATA[ var BreakpointHandler = function() { this.initted = false; this.isHomePage = false; this.isMobile = false; }; BreakpointHandler.prototype.finalizeSummary = function(summaryHtml, lastNode) { // Use $.trim for IE8 compatibility summaryHtml = $.trim(summaryHtml).replace(/(<br>|\s)+$/,''); if (lastNode.nodeType == 3) { var lastChar = summaryHtml.slice(-1); if (!lastChar.match(/[.”"?]/)) { if (!lastChar.match(/[A-Za-z]/)) { summaryHtml = summaryHtml.slice(0, -1); } summaryHtml += ' ...'; } } else if (lastNode.nodeType == 1 && (lastNode.nodeName == 'I' || lastNode.nodeName == 'A')) { summaryHtml += ' ...'; } return summaryHtml; }; BreakpointHandler.prototype.generateSummaryFromContent = function(content, numWords) { var seenWords = 0; var summaryHtml = ''; for (var i=0; i < content.childNodes.length; i++) { var node = content.childNodes[i]; var nodeText; if (node.nodeType == 1) { if (node.hasAttribute('data-about-pullquote')) { continue; } nodeText = node.textContent; if (nodeText === undefined) { // innerText for IE8 nodeText = node.innerText; } if (node.nodeName == 'DIV' || node.nodeName == 'B') { // Don't end early if we haven't seen enough words. if (seenWords < 10) { continue; } if (i > 0) { summaryHtml = this.finalizeSummary(summaryHtml, content.childNodes[i-1]); } break; } summaryHtml += node.outerHTML; } else if (node.nodeType == 3) { nodeText = node.nodeValue; summaryHtml += nodeText + ' '; } var words = nodeText.match(/\S+\s*/g); if (!words) { continue; } var remain = numWords - seenWords; if (words.length >= remain) { summaryHtml = this.finalizeSummary(summaryHtml, node); break; } seenWords += words.length; } return summaryHtml; }; BreakpointHandler.prototype.detect = function() { var match, pl = /\+/g, search = /([^&=]+)=?([^&]*)/g, decode = function (s) { return decodeURIComponent(s.replace(pl, " ")); }, query = window.location.search.substring(1); var urlParams = {}; while (match = search.exec(query)) urlParams[decode(match[1])] = decode(match[2]); this.isListPage = $('html').hasClass('list-page'); this.isMobile = urlParams['m'] === '1'; this.isHomePage = window.location.pathname == '/'; }; BreakpointHandler.prototype.initContent = function() { var self = this; $('.post').each(function(index) { var body = $(this).children('.post-body')[0]; var content = $(body).children('.post-content')[0]; $(content).addClass('post-original'); var data = $(content).children('script').html(); data = self.rewriteForSSL(data); // If exists, extract specified editor's preview. var match = data.match(/([\s\S]+?)<div data-is-preview.+?>([\s\S]+)<\/div>/m); if (match) { data = match[1]; } // Prevent big images from loading when they aren't needed. // This must be done as a pre-injection step, since image loading can't be // canceled once embedded into the DOM. if (self.isListPage && self.isMobile) { data = data.replace(/<(img|iframe) .+?>/g, ''); } // Insert template to be rendered as nodes. content.innerHTML = data; if (self.isListPage) { var summary = document.createElement('div'); $(summary).addClass('post-content'); $(summary).addClass('post-summary'); body.insertBefore(summary, content); if (match) { // Use provided summary. summary.innerHTML = match[2]; } else { // Generate a summary. // Summary generation relies on DOM, so it must occur after content is // inserted into the page. summary.innerHTML = self.generateSummaryFromContent(content, 30); } // Add read more link to summary. var titleAnchor = $(this).find('.title a')[0]; var link = titleAnchor.cloneNode(true); link.innerHTML = 'Read More'; $(link).addClass('read-more'); summary.appendChild(link); } }); // Firefox does not allow for proper styling of BR. if (navigator.userAgent.indexOf('Firefox') > -1) { $('.post-content br').replaceWith('<span class="space"></span>'); } $('.loading').removeClass('loading'); }; BreakpointHandler.prototype.process = function() { if (!this.initted) { var makeInsecureImageRegex = function(hosts) { var whitelist = hosts.join('|').replace(/\./g,'\\.'); // Normal image tags, plus input images (yes, this is possible!) return new RegExp('(<(img|input)[^>]+?src=("|\'))http:\/\/(' + whitelist +')', 'g'); }; this.sslImageRegex = makeInsecureImageRegex(BreakpointHandler.KNOWN_HTTPS_HOSTS); this.sslImageCurrentDomainRegex = makeInsecureImageRegex([window.location.hostname]); this.detect(); this.initContent(); this.initted = true; } }; BreakpointHandler.KNOWN_HTTPS_HOSTS = [ "www.google.org", "www.google.com", "services.google.com", "blogger.com", "draft.blogger.com", "www.blogger.com", "photos1.blogger.com", "photos2.blogger.com", "photos3.blogger.com", "blogblog.com", "img1.blogblog.com", "img2.blogblog.com", "www.blogblog.com", "www1.blogblog.com", "www2.blogblog.com", "0.bp.blogspot.com", "1.bp.blogspot.com", "2.bp.blogspot.com", "3.bp.blogspot.com", "4.bp.blogspot.com", "lh3.googleusercontent.com", "lh4.googleusercontent.com", "lh5.googleusercontent.com", "lh6.googleusercontent.com", "themes.googleusercontent.com", ]; BreakpointHandler.prototype.rewriteForSSL = function(html) { // Handle HTTP -> HTTPS source replacement of images, movies, and other embedded content. return html.replace(this.sslImageRegex, '$1https://$4') .replace(this.sslImageCurrentDomainRegex, '$1//$4') .replace(/(<(embed|iframe)[^>]+?src=("|'))http:\/\/([^"']*?(youtube|picasaweb\.google)\.com)/g, '$1https://$4') // Slideshow SWF takes a image host, so we need to rewrite that parameter. .replace(/(<embed[^>]+?feed=http(?=[^s]))/g, '$1s'); }; $(document).ready(function() { var handler = new BreakpointHandler(); handler.process(); // Top-level navigation. $(".BlogArchive .tab").click(function(ev) { ev.preventDefault(); $(this).parent().toggleClass('active'); $(this).siblings().slideToggle(300); }); $(".Label .tab").click(function(ev) { ev.preventDefault(); $(this).parent().toggleClass('active'); $(this).siblings().slideToggle(300); }); // Blog archive year expansion. $('.BlogArchive .intervalToggle').click(function(ev) { ev.preventDefault(); if ($(this).parent().hasClass('collapsed')) { $(this).parent().removeClass('collapsed'); $(this).parent().addClass('expanded'); } else { $(this).parent().removeClass('expanded'); $(this).parent().addClass('collapsed'); } }); // Reverse order of months. $('.BlogArchive .intervalToggle + div').each(function(_, items) { var year = $(this); year.children().each(function(_, month) { year.prepend(month); }); }); // Set anchors to open in new tab. $('.post-content img').parent().each(function(_, node) { if (node.nodeName == 'A') { $(this).attr('target', '_blank'); } }); // Process search requests. $('.searchBox input').on("keypress", function(ev) { if (ev.which == 13) { window.location.href = 'https://www.google.com/search?q=site%3A' + window.location.hostname + '%20' + encodeURIComponent ($(this).val()); } }); }); //]]> </script> <script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script> <script type='text/javascript'> window['__wavt'] = 'AOuZoY7b3vQSjjtskFpCubzSebSGKOaYMQ:1732376245992';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d35192255','//docs.googleblog.com/search/label/sheets','35192255'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '35192255', 'title': 'Google Docs Blog', 'url': 'https://docs.googleblog.com/search/label/sheets', 'canonicalUrl': 'https://docs.googleblog.com/search/label/sheets', 'homepageUrl': 'https://docs.googleblog.com/', 'searchUrl': 'https://docs.googleblog.com/search', 'canonicalHomepageUrl': 'https://docs.googleblog.com/', 'blogspotFaviconUrl': 'https://docs.googleblog.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-34322147-32', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Google Docs Blog - Atom\x22 href\x3d\x22https://docs.googleblog.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Google Docs Blog - RSS\x22 href\x3d\x22https://docs.googleblog.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Google Docs Blog - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/35192255/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'searchLabel': 'sheets', 'pageName': 'sheets', 'pageTitle': 'Google Docs Blog: sheets'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': false, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Google Docs Blog', 'description': 'The official source for news, updates and tips about Docs, Sheets, Slides, Forms, and Keep.', 'url': 'https://docs.googleblog.com/search/label/sheets', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'sheets', 'resultsMessage': 'Showing posts with the label sheets', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3esheets\x3c/span\x3e'}}}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3esheets\x3c/b\x3e. \x3ca href\x3d\x22https://docs.googleblog.com/\x22\x3eShow all posts\x3c/a\x3e'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML8', 'sidebar-top', document.getElementById('HTML8'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'sidebar', document.getElementById('Label1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive1', 'sidebar', document.getElementById('BlogArchive1'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML6', 'sidebar', document.getElementById('HTML6'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML5', 'sidebar-bottom', document.getElementById('HTML5'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'footer-1', document.getElementById('HTML2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'footer-2', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML4', 'footer-3', document.getElementById('HTML4'), {}, 'displayModeFull')); </script> </body> </html>

CINXE.COM

Google Docs Blog: sheets