Many of Excel’s text-formatting options are also easily available at the click of a button. 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.Ĭurrency and accounting formats and alignment options are also available from the same part of the Home tab.
#Microsoft office 2018 page borders full#
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. Much of the added formatting power comes from new options in the Ribbon. Over the past couple of years, Excel Online has gained several formatting options, giving it nearly as much power as the desktop app.
It’s hard to call an app a spreadsheet editor when the formatting tools are limited. You can also select View > Freeze Panes > Freeze Top Row or Freeze First Column for the most commonly used freeze pane commands. Just click into a cell and click View > Freeze Panes > Freeze Panes to freeze everything above and to the left of it. You can now freeze any number of columns or rows in Excel Online, too.
By freezing the top row, your column headings are always visible.
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)
