Microsoft has updated the web version of Excel with a raft of new features and a new user interface with added functionality, bringing it closer in line with its desktop counterpart.
The tech giant has added new features to the Mac and Windows versions of the spreadsheet app over recent weeks, including introducing checkboxes and support for the ODF 1.4 file format.
But now it’s focussing on bringing the web version of Excel up to speed with its desktop cousins, promising that the new user interface will streamline a number of common tasks.
In a blog post announcing the update, Microsoft claimed it has modernized the Excel grid with “a host of powerful features designed to make your spreadsheet tasks simpler, faster, and more enjoyable.”
The first of these updates is making it easier to resize rows and columns with fewer clicks. Now, users can simply hover over the border of a row or column header and then click and hold the handles to resize it.
Web users will also get simplified insert options, enabling them to add rows and columns by hovering over the respective header and clicking the small ‘plus’ circle that appears to insert a new column or row.
In a similar vein, users can also show hidden rows and columns with a single click by hovering over the respective header and hitting the small arrow symbols that will appear.
More Excel updates ease user experience
As part of the updates, Microsoft confirmed Excel for the web will now give users the ability to freeze panes for simplified navigation in larger spreadsheets. You can now pin important headers or columns to ensure they remain visible as you scroll.
RELATED WHITEPAPER
A new drag and drop feature should help users rearrange elements of their spreadsheet more easily, allowing you to drag and drop any selected row or column into another.
The final addition included in this update is the ability to highlight important cells, rows, or columns within Excel, a quality of life feature that promises to dramatically improve the readability of larger spreadsheets on the web.
-
How AI is bringing autonomous IT to realitySponsored In addition to providing a helping hand to IT groups, AI is now taking over some tasks altogether. It’s a shift that enables IT to fulfill the longstanding quest to “do more with less”
-
Cyber attacks are getting quicker and businesses need to plan accordinglyIn-depth Without proactive patch management, businesses are vulnerable to attacks on overlooked weaknesses
-
Microsoft issues fix for Windows 11 update that bricked mouse and keyboard controls in recovery environment – here's what you need to knowNews Yet another Windows 11 update has caused chaos for users
-
Windows 10 end of life could create a major e-waste problemNews The study marks the latest Windows 10 end of life e-waste warning
-
Microsoft Office 2016 and 2019 are heading for the scrapheap next month – but there could be a lifeline for those unable to upgradeNews The tech giant has urged Office 2016 and Office 2019 users to upgrade before the deadline passes
-
UK government programmers trialed AI coding assistants from Microsoft, GitHub, and Google – here's what they foundNews Developers participating in a trial of AI coding tools from Google, Microsoft, and GitHub reported big time savings, with 58% saying they now couldn't work without them.
-
Salesforce says ‘Microsoft’s anticompetitive tying of Teams' harmed business in triumphant response to EU concessions agreementNews Microsoft has agreed to make versions of its Office solutions suite available without Teams – and at a reduced price
-
US Senator calls for Microsoft FTC probe over ‘gross cybersecurity negligence’ – Ron Wyden claims the tech giant has provided ‘dangerous, insecure software’ to the US governmentNews Ron Wyden, a Democratic senator from Oregon, has written to the chair of the FTC calling for an investigation into Microsoft's cyber practices.
-
Microsoft touts new Copilot features in Excel, but says you shouldn’t use them if you want accurate resultsNews Microsoft has warned against using new AI features in Excel for “tasks with legal, regulatory, or compliance implications” – so when can you use it?
-
A senior Microsoft exec says future Windows versions will offer more interactive, ‘multimodal’ experiencesNews With speculation over a Windows 12 reveal mounting, a senior company figure claims the new operating system will mark a step change for users
