Google Docs continues to encroach upon Microsoft Excel territory with the addition of many stalwart Excel functions and features. Announced today, the update includes new tweaks to Google Sheets and enhanced formatting functions for images, charts, and Pivot tables.

Some of these new enhanced formatting options (via Android Police) being added to Google Sheets might not be necessary for all users, but are solid additions to arguably the best alternative to Excel.

What’s new


  • You can use guides to help you align, size, and position various objects within your sheets. Guides are also helpful in making sure multiple objects within the same sheet are in proportion to one another.

Google Sheets enhanced Guides

Multi-selecting objects

  • To select multiple charts, drawings, and images to move, resize, or delete in bulk, hold down the Control or Shift key and select.

Enhanced pivot table insertion

  • When adding a new pivot table, you’ll now have the option to either place it in a new sheet or in a custom location on an existing sheet.
    • To create a new pivot table, go to Data > Pivot Table and select a data range.
    • In the dialogue box, under Insert to, select New sheet or Existing sheet, and click Create. Note that if you select existing sheet, you’ll have to select a specific cell location for the pivot table.

Google Sheets enhanced pivot tables

Copy and paste images into Sheets

  • Recently, we made it easier to add images to your spreadsheet by inserting images into cells. Now, you can copy images from other websites and paste them directly into your sheet.
    • Simply right click on an image and hit copy, then in Sheets right click and hit Paste to insert the image over the grid.

Formula backed charts inserted from Answers

  • Now, when you use Sheets Explore to create charts, the charts you insert from the Q&A feature (Answers) will be backed by formulas. This means that charts will automatically update if the underlying data changes, ensuring you always have a fresh chart with the latest information.

The new enhanced formatting tools for Google Sheets should be available to all users now. If you’re a daily user, be sure to check them out. They might even mean you won’t have to work in Excel quite so much in future.

More on Google Docs:

FTC: We use income earning auto affiliate links. More.

Check out 9to5Google on YouTube for more news:

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel

About the Author

Damien Wilde

Damien is a UK-based video producer for 9to5Google. Find him on Twitter: @iamdamienwilde. Email:

Damien Wilde's favorite gear