What's New in Excel for the web
Published Apr 26 2021 10:00 AM 9,374 Views

Our Excel team strives to provide its customers with rich experiences that increase productivity in Excel for the web. Recently, we shared how we’ve continued to better navigate and manipulate your Excel files in a browser, making working in and navigating around a workbook and other interactions, faster and smoother. Today, we’re excited to introduce new features and capabilities to help you easily format your data with color and style along with a new mini toolbar, table improvements, and more. In this article, we cover:

 

  • Custom color palettes
  • Cell styles gallery
  • Draw & erase borders
  • Mini toolbar
  • Table improvements
  • New printing experience (coming soon)

 

Custom color palette

Match your brand colors or fine tune your color choices with custom color palettes:

  • Select from a wide range of color options via the more colors dialog box by simply dragging the color slider
  • Change color shade by dragging your cursor around the more colors rectangle and view your selection in the preview box
  • Input RGB values or hex values directly for easy color selection

 

Custom-color-palette.gif

 

Cell styles gallery

Keep the formatting of your data consistent so it's easy to read and understand by applying cell styles such as fonts, number formats, and cell borders and shading.

 

cell-styles.gif

 

Draw & erase borders

Highlight your data or differentiate one set of data from another by adding or removing cell borders.  Pick Draw Border to add outer borders, Draw Border Grid to add gridlines, or Erase Borders to erase them.

 Draw borders.png

 

Mini toolbar

Right click to get quick access to most common formatting commands via the new mini toolbar.

 

Mini Tool bar.png

 

Table improvements

Tables are muscle memory for many Excel users, and we want to continue bringing you a more consistent table experience across Excel on the desktop and Excel for the web, from design and styling to naming to total rows and more:

 

  • Select table design and styling options

 

Table-Improvements_table-design-and-styling-options.png

 

  • Rename a table

 

Table-Improvements_table-rename.png

 

  • Add total row

 

Table-Improvements_add-total-rowpng.png

 

  • Format any data as table

 

Table-Improvements_format-data-as-table.png

 

New printing experience (coming soon)

See what you’re printing and customize it the way you want it with the new printing experience in Excel for the web, now supporting print preview with page layout settings:

  • Set print area: active sheet, entire workbook, or current selection
  • Insert/delete page breaks

 

Print.gif

 

These are just some of the latest improvements, many more are coming soon!

 

Your feedback helps shape the future of Excel for the web. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.

 

Want to know more about Excel for the web?  See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

 

Thank you!

 

3 Comments
Version history
Last update:
‎Apr 26 2021 07:44 AM
Updated by: