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...
  • 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...
  • 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...
  • What's The Right Answer?
    Sometimes the same question can have multiple answers, even when you're looking for a simple fact. I've searched for [ny population]...
  • Google Quick View
    Google Search for mobile has a new feature called " Quick View ". Right now, it only shows up for Wikipedia results and it allows ...
  • Online Office Hours with Google Docs
    Cross-posted on the Google Student Blog Guest Post: Alex is a senior at Harvard University, and interned this summer on Google's marketi...
  • Give us your feedback with Product Ideas for Google Docs
    With Google Docs, we've learned that some of our most valuable insights come from our users, and we are always excited by what you have ...
  • More In-Depth Articles in Google Search
    For general queries like [ global warming ], [ love ], [ Mandela ], [ China ], Google shows some in-depth news articles at the bottom of th...
  • A completely new look for Drive on iOS
    One of the features you’ve told us you want on Drive for iOS is the ability to effortlessly browse and preview files, just like you can on A...
  • 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...

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