5 Things You Can Do in Excel for the Web Today That You Couldn't 12 Months Ago

Excel web version features enhancements to improve efficiency! While Excel desktop version is more powerful, the web version has also been significantly improved over the past year. This article will focus on five key improvements:

1. Easily insert rows and columns: In Excel web, just hover over the row or column header and click the " " sign that appears to insert a new row or column. There is no need to use the confusing right-click menu "insert" function anymore. This method is faster, and newly inserted rows or columns inherit the format of adjacent cells.

2. Export as CSV files: Excel now supports exporting worksheets as CSV files for easy data transfer and compatibility with other software. Click "File" > "Export" > "Download as CSV".

3. Date selector: After setting the "Short Date" or "Long Date" format for the cell, double-click the cell to pop up the date selector, which is convenient for entering dates.

4. Copy and paste improvements: Paste options are more abundant, you can choose to paste only values, formulas, formats, or links, and you can also adjust column width or transpose data. Additionally, rows or columns can now be dragged to move them, and the autofill feature is also consistent with the desktop version.

5. Shared Worksheet View: After creating a custom view, you can generate and share links to that view, making it easier to collaborate with others without sharing the entire worksheet. You can set password, access permissions, edit permissions, and link expiration time.

Microsoft is continuing to improve the web version of Excel, integrating more Copilot features in the future, strengthening integration with Microsoft Forms, and providing more tools for advanced data analysts.

The above is the detailed content of 5 Things You Can Do in Excel for the Web Today That You Couldn't 12 Months Ago. For more information, please follow other related articles on the PHP Chinese website!