This article is contributed. See the original author and article here.

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!


 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.