Let’s say that you have a list consisting of Product Names, Stock Information and Prices. It wouldn’t be so bad to have the images of these products next to them using the IMAGE function, would it? 😊
A not-so-famous philosopher (That is no one but me😊) once said: “ Visualizing the data is just as important as preparing it.”
Excel for Microsoft 365 Excel for Microsoft 365 Mac Excel for Web
Wraps the provided row or column of values by columns after a specified number of elements to form a new array.
Syntax
=WRAPCOLS(vector, wrap_count, [pad_with])
The arguments in the syntax of WRAPCOLS are:
vector
The vector or reference to wrap
wrap_count
The maximum number of values for each column.
pad_with
The value with which to pad. The default is #N/A.
Remarks
The elements of the vector are placed into a 2-dimensional array by column. Each column has wrap_count elements. The column is padded with pad_with if there are insufficient elements to fill it. If wrap_count is greater or equal to the number of elements in vector, then the vector is simply returned as the result of the function.
Examples
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻 Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of September.
September 2021
September 24, 2021 , Version 2110 (Build 14517.20000)
Word
Notable fixes
We fixed an issue where changes failed to sync and progress was lost in both the synced file and the locally backed up file.
We fixed an issue where Word would become slow to respond while using a high CPU percentage.
We fixed an issue where AutoCorrect was not working in Modern Comments.
Excel
Notable fixes
We fixed an issue where the error ERROR_DISK_FULL would appear before maintenance would begin.
We fixed an issue where Excel’s enclosed numeric characters showed as question marks.
Project
Notable fix
We fixed an issue where the beforetaskchange event would fire twice and included incorrect information when the predecessors field changed.
Outlook
Notable fixes
We fixed an issue where the sensitivity tab was disabled in the frame-control window for some users.
We fixed an issue where search did not include items from an online archive mailbox.
Office Suite
Notable fix
We fixed an issue where a user can’t open an .xls/.ppt/.doc file in a folder that was synced from a SharePoint folder with read permission.
September 17, 2021 , Version 2110 (Build 14509.20000)
Word, Excel, PowerPoint
Apply default sensitivity labels when modifying existing files
Up until now, default sensitivity labels, configured by your administrator, were automatically applied when a file was created. Now, labels are applied whenever a document, worksheet, or presentation is either created or modified. Note that you can select a different label if one better matches the sensitivity of a given file.
Word
Notable fixes
We fixed an issue that negatively impacted the typing speed in a document when an animated GIF is playing.
We fixed an issue that caused the Save indicator to stop responding.
Excel
Notable fix
We fixed an issue that caused an insufficient memory warning to appear when copying and pasting content.
PowerPoint
Notable fix
We fixed an issue where ink would not be displayed when a PowerPoint slide was pasted in another program.
Outlook
Notable fix
We fixed an issue that negatively impacted the typing speed in a document when an animated GIF is playing.
Project
Notable fix
We fixed an issue that caused the Visual Basic Applications (VBA) OrganizerMoveItem method that is used to move custom field information from one project to another to not work properly when the Name parameter is omitted.
September 10, 2021 , Version 2110 (Build 14503.20002)
Outlook
Use your voice to send email and @mention people
In our increasingly busy world, dictating your emails in Outlook has become a very popular way to improve your efficiency. We’ve now made this feature even more powerful by adding specific voice commands, enabling you to add people to an email, mention (@name) someone in a message, and send the mail—all using only your voice. To use this feature, click the Dictate button on the Message tab for an email. Then dictate your message and try out a voice command, such as “add [name] to email” or “at mention [name],” and observe the results.
We fixed an issue where double-clicking to save an untrusted attachment would fail to save to network locations.
We fixed an issue where messages created via Send To do not get default sensitivity labels.
Word, Excel, PowerPoint
Data Loss Prevention policy tips
Additional sensitive information types configured as part of OneDrive and SharePoint data loss prevention (DLP) policies can now be detected by the app to show a policy tip. This update also brings accuracy improvements and globalization support.
We fixed an issue where automatic sensitivity labeling was not working for a few GCC-H tenants.
PowerPoint
Notable fix
We fixed an issue where using auto-save saved the file in an unexpected location; requests to save to a shared location were saved locally without notification.
Project
Notable fix
We fixed an issue where, if the decimal separator isn’t a period, enterprise resources can’t be saved when an enterprise number custom field is updated.
Office Suite
Notable fix
We fixed an issue where the ampersand character was incorrectly shown as an underline in the data types card.
September 3, 2021 , Version 2109 (Build 14430.20030)
Office Suite
Notable fix
We fixed an issue where, during the uploading of a file, the application stopped responding and the document was not syncing.
Access
Notable fix
We fixed an issue where special characters were included in error messages.
Excel
Notable fixes
We fixed a rendering issue in worksheets with Freeze Panes enabled for certain scrolling scenarios.
We fixed an issue where localized characters appeared lower than English characters in the sheet tabs.
We fixed an issue where the Find/Replace dialog only saved history for Find and not Replace (the dialog was not saving the history of what was replaced when Replace occurred).
Outlook
Notable fixes
We fixed an issue where Read Aloud neural voice regression stopped responding.
We fixed an issue that caused Room Finder to fail to load.
We fixed an issue that caused reminders to intermittently display late and show the wrong time in the dialog.
PowerPoint
Notable fix
We fixed an issue where the slide size can change during print preview.
Project
Notable fix
We fixed an issue where, when programmatically adding new tasks to a project, the tasks may not be inserted at the correct location if the new task’s summary task is collapsed.
Word
Notable fixes
We fixed an issue where Read Aloud neural voice regression stopped responding.
We fixed an issue related to crashes when calling DCompositionCreateDevice.
We fixed an issue where typing Hiragana with the Japanese input method editor (IME), with the At Mention people picker open, caused the IME to stop working.
We compiled all the new features and fixes in September in Office insider. Hope to see you in our other articles, bye bye. 🙋🏻♂️You can share this article with your friends and family to help them get information about Office insider updates released in the month of September. 👍🏻
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers. Each of those features is noted if it does not apply to Excel LTSC 2021 for commercial customers.
Co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly — in a matter of seconds.
Note: Co-authoring is not available in Excel LTSC 2021.
Better collaboration with modern comments
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
Note: Modern comments is not available in Excel LTSC 2021.
MODERN COMMENT
Know who’s in your workbook
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
WHO’S?
Visual refresh
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
NEW STYLE
Look left, look right… XLOOKUP is here!
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
Note: The Accessibility ribbon is not available in Excel LTSC 2021.
ACCESSIBILITY
Increase the reach of your content
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
ACCESSIBILITY
Performance improvements
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
SUMIF, COUNTIF, AVERAGEIF
Unhide many sheets at the same time
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, such as text, commands, help, and more.
You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻 Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of May.
May 2021
May 14, 2021 , Version 2106 (Build 14107.20000)
Word
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue where pressing key combinations such as ctrl + shift + @ would not produce the expected accented character( in this case, ‘å’).
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
We fixed an issue where copying a mail attachment to an application other than Word would fail if the filename included DBCS characters.
We fixed an issue where Word sometimes displayed a border around text that should have not been there.
Excel
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
PowerPoint
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
Outlook
Notable fixes
We fixed an issue that caused users to see actionable messages either constantly refreshing or reverting back to headers after download when running in Download Headers Only mode.
We fixed an issue that caused the people picker in Outlook to expand upwards rather than downwards for users with a perpetual license.
We fixed an issue that caused users of custom domains to see a warning message about permissions when pasting a link into an email message.
May 7, 2021 , Version 2106 (Build 14029.10000)
Excel
Notable fixes
We fixed an issue that prevented the Name Manager from opening books with a large number of hidden names.
Outlook
Notable fixes
We fixed an issue that caused users to see copies of all of their sent items appearing in their Outbox folder.
We fixed an issue that caused Outlook to close unexpectedly when using Read Aloud with other versions of Windows.
Word
Notable fixes
We fixed an issue that caused Word to close unexpectedly when using Read Aloud with other versions of Windows.
May 3, 2021 , Version 2105 (Build 14026.20052)
Excel
Linked data types: Real data for real life
We’re excited to announce brand new data types in Excel, resulting from our partnership with Wolfram. Have you ever tried to get data from the web into Excel and keep it up to date? Then, you’ll know it’s not for the faint of heart. These new linked data types and smart templates not only save you time but also make keeping data up-to-date a breeze.
We’ve heard your feedback! We’ve created a contextual Accessibility ribbon that offers one consolidated place to look for tools that make authoring accessible content easier. To try it out, open the Accessibility Checker on the Review tab and the Accessibility ribbon will open automatically.
We compiled all the new features and fixes in May in Office insider.Hope to see you in our other articles, bye bye. 🙋🏻♂️You can share this article with your friends and family to help them get information about Office insider updates released in the month of May. 👍🏻
Word
Excel
PowerPoint
