Excel Online: News and Updates, Summer 2018

Published 08-07-2018 11:41 AM 15.2K Views
Regular Visitor

If it’s been a few years since you used Excel Online, get ready to be impressed. Over the past couple of years, the app has transformed from a simple report-viewing tool into a spreadsheet editor that you can use from any computer with an internet connection.


Here’s every feature that’s been added to Excel Online since March 2016. Lots of screenshots are included, so go to Excel Online, log in with your Microsoft Office account, whip up a spreadsheet and follow along.




The Excel Online interface has come a long way, making it easier for users to see, find, and work with their data. Here are the ways that you can customize the interface but couldn’t back in 2016.

Adjusting Rows and Columns

You can now adjust row height and column width from the context menu. Just right-click on a row or column label, and you’ll see the option.


Change column widthChange column width

Click “Row Height” or “Column Width,” enter a new value, and the selected row or column is adjusted.


A valuable benefit of this is, that you can now select multiple rows or columns and set them all to a specific height or width with just a few clicks.

Column Width Tooltip

If you want to resize a row or column without using the context menu, you can just grab the border and drag it to the desired size.


Microsoft recently added a great new feature for when you’re dragging a column to a new size: a tooltip that displays the column width.


Drag column witdhDrag column witdh 

If you know how wide you want the column to be, or you’d like to make different columns the same width, this makes it much easier.

Duplicate Sheet

In previous editions of Excel Online, if you wanted to duplicate a sheet, you’d have to create a new sheet and then copy and paste data from the original sheet.


Now, you can just right-click a sheet tab and select Duplicate.


Duplicate sheetDuplicate sheet 

A new sheet will appear that is an exact copy of the first. At the moment, sheets with charts, images, or shapes can’t be duplicated. We certainly hope this functionality will be added soon!


Change Sheet Tab Color

Working on spreadsheets with a large number of sheets can be difficult. Fortunately, Excel Online now lets you change the color of a sheet tab so you can find it quickly or categorize your sheets.


Just right-click on the sheet tab, mouse over Tab Color, and select the color you’d like.


Change sheet tab colorChange sheet tab color

Your sheet tab will now be highlighted with the selected color.


Change sheet tab colorChange sheet tab color


Freeze Panes

When you’re working with lots of data in the desktop version of Excel, Freeze Panes is one of the most useful tools to know. By freezing the top row, your column headings are always visible.


You can now freeze any number of columns or rows in Excel Online, too. Just click into a cell and click View > Freeze Panes > Freeze Panes to freeze everything above and to the left of it.


Freeze panesFreeze panes

You can also select View > Freeze Panes > Freeze Top Row or Freeze First Column for the most commonly used freeze pane commands.



It’s hard to call an app a spreadsheet editor when the formatting tools are limited. Over the past couple of years, Excel Online has gained several formatting options, giving it nearly as much power as the desktop app.

Changes in the Ribbon

Much of the added formatting power comes from new options in the Ribbon.


The Home tab now gives you access to a full selection of formatting options that you’ve become accustomed to in the full desktop version of Excel.


You can quickly select a number formatting options from the Number drop-down to format your number as a percentage, currency, date, or other options.


Currency and accounting formats and alignment options are also available from the same part of the Home tab.


Many of Excel’s text-formatting options are also easily available at the click of a button. For example, additional typeface formatting options like double-underline and strikethrough are easily accessible in the Font area.


More number formats are available from the number formatting drop-down in the center of the Home tab.


More number formatsMore number formats

A full selection of border types, merging and unmerging, increasing and decreasing indentation, font size, and other formatting options are available for both numbers and text as well.


Additionally, Microsoft added the Most Recently Used split button to the Borders, Fill Color, and Font Color buttons in Excel Online.


MRU split buttonsMRU split buttons

When you set a color or a border from these buttons Excel Online will now remember it, so you can just click the button to apply it somewhere else.

Shapes and Pictures

When Excel Online was a simple spreadsheet viewer, there was no way to insert shapes or pictures into a spreadsheet. The new version of Excel Online changes that.


The Insert tab now prominently features buttons for inserting pictures and shapes - and the menu of shapes contains just about any shape you could ever need.


Insert shapesInsert shapes

It’s easy to click and drag the image or shape into place, and the rotation handle lets you rotate it into any orientation you’d like. Also, you can now change the shape and border color, and dimensions (width and length).


Rotate shapeRotate shape

Conditional Formatting

By changing the format of a subset of cells, conditional formatting makes it easy to highlight the cells you want based on what they contain.


Conditional formatting tools are now prominently displayed in the Home tab.


Conditional formattingConditional formatting

Just select the data you want to format, click Conditional Formatting, and select the formatting you’d like to apply. Here’s what it looks like when we apply Highlight Cells Rules > Above Average.


Highlight cells above averageHighlight cells above average


Excel has long been a data-analysis powerhouse, and Excel Online has caught up with its desktop-based older brother when it comes to analysis capabilities. From the most basic to the more complex, Excel Online can handle your data-analysis requests.


When you have a lot of data, being able to effectively filter it down to the information you want to see is crucial. The Data tab now hosts a Filter button that enables column-based filtering, just like in the desktop version of Excel.



The in-spreadsheet dropdown doesn’t contain individual-value filtering, but if you click Filter, you’ll see the familiar options for viewing only certain values.


Filter optionsFilter options 

Pivot Tables

Long considered one of Excel’s most powerful data-analysis features, pivot tables give you powerful summaries of your data.


Before Excel Online supported pivot tables, the desktop version of Excel was considered to be vastly superior - but now that you can insert a pivot table from the Insert tab with just a few clicks, the web-based version is gaining ground.


Insert pivot tableInsert pivot table

Browser-based pivot tables are just as powerful as their offline brethren.


Pivot tables can’t currently be used over data model connections, but if you’re just using a standard spreadsheet in Excel Online, you can use them to gain powerful insights into your data.


Beyond pivot tables, Excel Online now gives you the power to work more effectively with regular tables as well.


When having a table in your spreadsheet, you can include additional rows or columns in your table by right-clicking.


Insert columns in a tableInsert columns in a table

The context menu also lets you delete rows and columns with a single click.


Another new feature is the ability to navigate through the table by pressing the Tab key on your keyboard, so you can navigate to the cells you want faster than ever without using your mouse.



Perhaps the most useful feature that Excel Online brings to the table is collaboration. Instead of emailing files back and forth with other Office users, you can have an entire group of people working on a document in real time.

From Viewing to Editing

Making the change from a spreadsheet viewer to editor required Microsoft to make some big changes in the backend functionality of the app.


For example, previous versions of Excel Online couldn’t open protected workbooks. The latest version has no problem opening or editing these protected files.


Previous versions also couldn’t edit files that contained cropped images—which made it difficult to collaborate with people on files that included images.


Now, however, Excel Online has no problem editing files with cropped images.


The same is true of files that contain grouped shapes or images.


Excel Online has also seen some additional performance upgrades. You can now work with Excel files of up to 30MB if you have OneDrive for Business. That’s three times the previous limit, giving you much more flexibility with your files.


And Excel Online has been upgraded with more power, so page load times will be lower and you’ll see improved interactivity from the app itself.


Silent Reopen

Your Excel Online session can end while you still have your file open. And in previous versions of Excel Online, you’d have to wait until your browser reconnected to the service to start working on the spreadsheet.


Now, however, you can start working on the file while your browser reestablishes the connection. It might not seem like much, but it eliminates a potentially annoying wait when you’re trying to get work done.

Real-Time Coauthoring

With the Share button, you can share your Excel Online spreadsheet with other users, and everyone can edit the document at the same time.


Share buttonShare button

From here, you can choose who you’ll invite to your spreadsheet and select if they’ll be able to edit it or view it only.


Invitation settingsInvitation settings

You can also tick an option that forces the invited to log in to their Office account before they can view or edit the spreadsheet.


When you’ve shared your file, you’ll see who’s editing, which cell they have selected, and the exact changes that they make.


See who’s editingSee who’s editing

You can also leave comments to each other and chat while you’re editing right in Excel Online.


And with a built-in Skype messenger, you can chat with your contacts in the same window as your spreadsheet:


Built-in Skype messengerBuilt-in Skype messenger


In addition to the features above, Microsoft has made numerous small changes that improve user experience in Excel Online. Some of them might seem very minor, but they all add up to create a better spreadsheet editing app.

Drag Scroll Beyond Viewport

In early versions of Excel Online, if you clicked on a cell and dragged the selection to the bottom (or right side) of the viewport, the selection would stop there—you couldn’t scroll.


Now, you can click and drag to scroll and select as many cells as you want.


A new print dialog can be accessed from the File tab of the Ribbon. This dialog gives you more options to help you get a better print of your spreadsheet.


Print dialog boxPrint dialog box

Choose what you print, how you print it, and what you print it on with ease.

Excel Surveys

Excel Online now includes the ability to create online forms that you can use to collect and analyze survey information. Just go to the Home Tab, click Survey, and select New Survey.


Excel surveysExcel surveys

Then enter your survey questions.


Edit Excel surveyEdit Excel survey

After that, you can share your survey and all results will be immediately imported into Excel Online, so you can analyze and share them.


The Accessibility Checker tells you when users with disabilities might find your document hard to read and how you can fix the issues. There are improved screen reader support and a new high-contrast mode for visually impaired users, too.


Excel Online also has the same “Tell me what you want to do” feature that desktop versions have, making it easier for people who aren’t familiar with Excel to find what they want. And with improved keyboard shortcuts for getting around the app, it’s more accessible for everyone.



The browser-based version of Excel is a great spreadsheet editor, and it’s come a long way from the days when it was simply a viewing tool. Today, you can use it for many of the things that earlier was only possible from the desktop version of Excel.


It’s now super easy for the people who create spreadsheets to share them with those who need to read and use them. With a few clicks, documents can be shared in view or edit mode, and users can communicate with real-time comments and Skype chats.


Sharing and collaboration have never been easier. And with new features and increased accessibility, Excel Online is quickly becoming almost as powerful as its desktop equivalent.


If it’s been a while since you’ve used Excel Online, it’s time to get reacquainted.



This guide is written by Kasper Langmann.
Kasper is a Microsoft Office Specialist, and co-founder of Spreadsheeto; one of the largest Excel blogs on the web.
To learn more about the tabletop version of Excel, read his more than 100 blog posts, and grow your skills with free and paid Excel training on Spreadsheeto.com.

Super Contributor

I mostly use Excel for tracking my tasks (yeah, old school here), so i liked that i can do this on my personal PC that i don't have Office on, in the browser, same as i check my mail, teams, etc. But i miss some obvious things. Like i need to be able to quickly cut and paste some rows by inserting copied row between other rows. Yet Online Excel can only paste on top of a row. Coloring options are limited and you can't color text differently or use different style in one cell in Online and if you try to edit a cell with various formats it will reset all of them.


Thanks for the helpful updates.  It would be very helpful to our organization if there was a text orientation feature in Excel Online.  This feature has almost 200 votes on uservoice.   https://excel.uservoice.com/forums/274580-excel-online/suggestions/12431940-there-is-no-text-orienta...

New Contributor

Thank you all for your helpful comments. We are working to address your asks so, stay tuned for more updates!

For example, Oleg, your first ask about <cut and paste some rows by inserting copied row between other rows> - is now live.


Enjoy Excel Online!


Very truly yours,

The Excel Online team

Super Contributor

Yeah, it works. Many thanks!

Regular Visitor

Thanks for all the positive responses to this article :)

I'm super excited myself to see how Excel Online will blow us away even more in the future.

If you guys and girls want to learn more about the desktop version of Excel, please sign up for my free online training at https://spreadsheeto.com/



Occasional Visitor

Good morning gentlemen,

I'm asking your help regarding Excel 2016 and a very strange problem faced from yesterday in a "normal" spreadsheet with data, formulas and cross-relations among different cells.

 I'm getting a number of #NUM flags in different cells, according to the attached screenshot

Screenshot 2018-10-11 10.40.06.png 

I already checked formulas, cells' format, cross links and anything else having a potential capability to generate a problem in Excel, without any improvement ....

Please give me help, because I made resort to all my fantasy and I need to go ahead with my work, after a full day of apparently "wasted time".

Should you need the Excel file for a better insight, please let me know.

Many thanks in advance.

Giovanni (John, in english).

Super Contributor

Instead of putting this in an unrelated blog article you should post this in Excel forum, which you can find in the Communities menu. You should get more visibility there to your issue. 

Occasional Visitor


Many thanks for your very useful contribution ...............

I solved the problem by myself, fortunately!

Occasional Visitor


J'ai un classeur excel online que j'ai incorporé dans une page de mon site avec un iframe.

Comment puis-je imprimer le résultat de cet iframe depuis mon site ?

Pourquoi ne pas pouvoir choisir au bas de l'iframe incorporé les icones qui y sont ?

Depuis excel online, je peux choisir le bouton enregistrer afin qu'il s'affiche ou pas, mais ne peut choisir les autres !

Pourquoi ne pas y ajouter un bouton imprimer ?

Merci de votre aide.


Occasional Visitor

Hi Kasper,


Just a quick question, I have office for mac.

how do i get to open an excel file with excel online whose size is over 30mo ?




Super Contributor

Based on the information i have found you can't. You can prepare it to be able to open in Power BI online, but i don't think it will allow you to open it in Excel Online. 

Occasional Visitor
EXCEL ONLINE HIT ENTER KEY AND YOU WILL LOSS MOST OF YOUR WORK!!! Hi, This question is about Excel Online 2016 free for college students. I'm asking for my daughter. Why is it if I press the ENTER key at any time, I lose most of my work? I tried adding a column of numbers then use the ENTER key after choosing the SUM option at the top to the page. They want you to use the TAB key not the enter key why??? Your work is on Auto Save so you lose most or all of your work. She said most of the class loss there work because of this problem, is there a fix for this? I never had this problem with Works. Thanks, Mike

@Mainemoose, I can't reproduce. Do you mean after that step


you press Enter and Excel Online crashes? 

New Contributor

Exel client app: Using the right number area (A numeric keypad) the dot on the keyboard  the decimal separator is a comma  as expected. 

2019-01-23 14_13_30-Map1 - Excel.png


Excel Online: Using the right number area (A numeric keypad the dot on the keyboard  the decimal separator is a dot. 


2019-01-23 14_14_45-Map.xlsx.png


Any changes on country or date locale setting did not help.

Is there any solution for this?

Super Contributor

You can try creating support ticket for that. Because it might be more complex than it seems. I once asked support to help understand why my OneDrive web version was showing US times for file changes. And they told me OneDrive was taking time zone settings from global admin profile and not from what language or time zone user picked on the first login or in the settings. And you couldn't change that retroactively for all the users. And there was no way to change it back once OneDrive was already provisioned for everyone. This can be something similar.

Occasional Visitor

Hi, can ı ask is there any hot key for changing uppercase to lowercase or opposite?

ı am asking just the hot key. ı know using formulas or flashfill methods for this but hot key.

thanks already for your help, ıf you can.



@Antuan27 , afraid it doesn't exists

Occasional Visitor


I'm a newcomer and I have a question.  I'm trying to make a sheet that has the 12 months of the year. Six on one side and six on the other.  When I put names and dates in each block, I hit the wrap text but it won't stay for the next block and it's grayed out and I can't use it.  Why won't it let me use it in each block?


Occasional Visitor

I currently keep a spreadsheet tracking tips for up to 166 drivers. The first tab lists qll of the drivers with a running tally for each one. Each driver has a separate tab to outline the runs that they receive the tips for. is there some way to freeze the first tab so that I can scroll the individual tabs to appear alongside the first tab so I can relay the individual tab totals to the first tab without scrolling from one end to the other and back for each driver?


Thank you for your valuable update.

I started using Excel Online version since November, 2019.

A lot of features have been added. Well-Done! 

Version history
Last update:
‎Aug 08 2018 08:57 AM
Updated by: