Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Wednesday, 21 September 2011

Merge cells vertically in Google spreadsheets

Posted on 10:05 by Unknown
There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting today, we’ve extended the merge functionality to let you create vertical merges across several rows of data.

In the spirit of the NFL season, let’s say you want to host a football tournament for your friends. To make it easier for them to cast their votes on the winning team, you organize the NFL teams by conference and division in a Google spreadsheet. Using vertical merges, you can assign headers to sets of rows. Simply select the set of cells you’d like to merge, then click on the down arrow next to the merge icon, and select Merge vertically.


In the NFL spreadsheet, you’ll see that some of the team names don’t fit on one line in the width of the cells of Column C.

To improve the formatting, select the cells across all the rows of teams in the AFC (rows 2-17) and 2 columns (C and D) and click Merge horizontally. You’ll have 16 merged cells that span 2 columns for better formatting.


After applying vertical merges to all of the conference and division headers and horizontal merges across the team names in each conference, you’re ready to share with your friends for the tournament!


To undo a merge action, select a merged cell and click Unmerge in the drop-down menu.

We hope you enjoy customizing the formatting of your spreadsheets with this feature. Let us know what you think in the comments.

Posted by: Jakov Krolo, Software Engineer Intern
Email ThisBlogThis!Share to XShare to Facebook
Posted in googlenew, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • We launched Table of Contents, too
    I'm writing this from the Phoenix Sky Harbor airport, just 5 minutes before I hop on a plane back to Google in California. I spent the d...
  • Custom Maps in the New Google Maps
    The new version of Google Maps constantly brings back features from the classic Google Maps, which shows that it's almost ready to becom...
  • Google Maps Easter Egg for Christmas
    The Pegman icon from the new Google Maps looks different: it now has a Santa hat. The classic Google Maps still shows the standard icon. Che...
  • Speakout gears up
    Posted by: Jen We now have lots of schools participating in our Global Warming Student Speakout from each of the locations listed below. We...
  • The New Google+ Photo Editor
    Google+ had a photo editor that used Flash , worked in any desktop browser and it was powered by Picnik. Google changed this and switched to...
  • Google Tests New Desktop Sign-in Page
    Back in August, Google changed the sign-in page for mobile devices. A few readers report that they see the updated sign-in page in the desk...
  • A Google Reader Puzzle From 2007
    Back in 2007, Google accidentally made public an internal video about Google Reader. The video included a lot of useful information about ...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ▼  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ▼  September (10)
      • Visualize your data with charts in Google Sites
      • Trying on the new Dynamic Views from Blogger
      • This week in Docs: Import/export and paste special...
      • Merge cells vertically in Google spreadsheets
      • +1 button in Google Sites
      • Improved Accessibility in Google Docs and Sites
      • This week in Docs: Format painter, Google Fusion T...
      • Comment-only access in Google documents
      • What Happened Wednesday
      • Tips & Tricks: Using the new Subtotal function in ...
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ►  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile