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. Your sheet tab will now be highlighted with the selected color. Just right-click on the sheet tab, mouse over Tab Color, and select the color you’d like.
Fortunately, Excel Online now lets you change the color of a sheet tab so you can find it quickly or categorize your sheets. Working on spreadsheets with a large number of sheets can be difficult. We certainly hope this functionality will be added soon! At the moment, sheets with charts, images, or shapes can’t be duplicated. Now, you can just right-click a sheet tab and select Duplicate.Ī new sheet will appear that is an exact copy of the first. 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. 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.
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. 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. Just right-click on a row or column label, and you’ll see the option.Ĭlick “Row Height” or “Column Width,” enter a new value, and the selected row or column is adjusted.Ī 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. You can now adjust row height and column width from the context menu. Here are the ways that you can customize the interface but couldn’t back in 2016. The Excel Online interface has come a long way, making it easier for users to see, find, and work with their data. Lots of screenshots are included, so go to Excel Online, log in with your Microsoft Office account, whip up a spreadsheet and follow along. Here’s every feature that’s been added to Excel Online since March 2016. 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. If it’s been a few years since you used Excel Online, get ready to be impressed.
0 kommentar(er)
