Delivering rich, delightful experiences to our customers continues to be a top priority for our Excel team. A few weeks ago, we shared how to easily format your data with color and style, and more. Today, we bring you a set of new features and improvements to help you better analyze your data, specifically:
Text to columns
You can now split text into columns using delimiters. For example, with a few clicks, you can convert “Hello World” in one cell to “Hello” and “World” across two adjacent cells.
You can also select multiple delimiters including tab, semicolon, comma, space, and custom [delimiter] at the same time. For example, “Hello, how are you?” in one cell would split into “Hello”, “”, “how”, “are”, and “you?” across 5 cells if you selected both comma and space as delimiters.
Analyze your data with the new and improved PivotTable experience in Excel for the web including:
Sorting is fundamental in data analysis. Sorting can be more than numerical or alphabetical ordering though. In Excel for the web, you can now sort by Cell Color, Font Color, and Conditional Formatting Icon, in addition to Cell Values. Furthermore, you can sort by more than one column.
You can now directly select and interact with chart elements when formatting a chart. Double-clicking a chart element launches the format task pane while single-clicking a chart element navigates you to its corresponding formatting options. In addition, non-data chart elements can now be removed from the chart using the delete/backspace keys. You will also be able to see a preview of your selection as you hover your mouse cursor over different chart elements.
Additional keyboard shortcuts
Many users have asked for additional well-known and commonly used keyboard shortcuts in Excel for the web, and we’re thrilled to bring you:
Also coming soon are
Find the full list of keyboard shortcuts via Help > Keyboard Shortcuts.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.