The WRAPCOLS FUNCTION

[vc_row][vc_column][vc_column_text]

WRAPCOLS Function

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.

 

Example1

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:F2,3)

 

Example2

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:G2,3,”x”)

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/office_imza_son.gif” image_size=”full” link=”https://peakup.org/global/office-training/” target=”_blank”][/vc_column][/vc_row]

OFFICE INSIDER – WHAT HAPPENED IN SEPTEMBER?

NEW FEATURES/FIXES

 

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’de duyarlılık etiketlerini gösteren ekran görüntüsü.

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.

Learn moreOutlook'taki sesle dikte özelliğinin (@bahsetme) ekran görüntüsü.

Notable Fixes

  • 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.

Learn more

Excel

Notable fix

  • 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. 👍🏻 

 

OFFICE INSIDER – WHAT HAPPENED IN MAY?

NEW FEATURES/FIXES

 

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 new iconWord

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 new iconOutlook

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 new iconOutlook

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 new iconWord

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.

Learn more >Şehir ve Üniversite veri türleri özelliği

 

Create content that works for everyone

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.

Learn more >  Erişilebilirlik Denetleyicisi

 

 

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. 👍🏻 

 

OFFICE INSIDER – WHAT HAPPENED IN APRIL?

NEW FEATURES/FIXES

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 April.

 

April 2021

April 30, 2021 , Version 2105 (Build 14026.20000)

Visio

AWS stencils and shapes

You can now use stencils with the latest AWS shapes to help you create diagrams and represent your AWS architecture more accurately.

AWS şekilleri

 

outlook new iconOutlook

Ensure accessibility of your content

When composing an email to large audiences or external users, for example, accessibility violations will now be brought up to your attention, through a mailtip.

To turn off this feature, select File > Options > Ease Of Access > Accessibility checker options and select the Run the accessibility checker only when I open it option.

Notable fixes
  • We fixed an issue where using High Contrast mode for extended periods of time would cause Outlook to crash.

Excel

Notable Fixes
  • We fixed an issue which could cause Excel to crash when using Paste Special with formats in certain situations.
  • We fixed an issue that cause Excel to crash when moving through comments in the Comments pane.
  • We fixed an issue that caused date formatting to be displayed incorrectly in some languages when using add-ins.
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.

word new iconWord

Notable fixes
  • We fixed an issue that caused the ability to collapse margins in a document containing multiple columns to be available.
  • We fixed an issue where text formatting remains after removing hyperlinks.
  • We fixed an issue where users would not be prompted to save documents when using a command (rather than the CTRL+S keyboard shortcut).
  • We fixed an issue where Word was unable to perform a Mail Merge with an Access database.
  • We fixed an issue where the sensitivity label disappears from a file in Word after uploading the file to SharePoint Online.
  • We fixed an issue where comments are not displayed after filtering by people.
  • We fixed an issue where Word would become unresponsive when editing fields.
  • We fixed an issue where some characters are not displayed correctly in table cells when there are comments in the document.
  • We fixed an issue where the file format changes occurred when saving documents with the AIP add-in enabled.
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
PowerPoint
Notable fixes
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
msproject new iconProject
Notable fixes
  • We fixed an issue where changes done through Planning Wizards weren’t always captured by change events.
  • We fixed an issue where users were unable to remove projects from the resource pool.

April 23, 2021 , Version 2105 (Build 14014.20002)

Excel

Import data from dynamic arrays

You can now import, shape and refresh data from dynamic arrays in the current workbook.

Notable fixes
  • We fixed an issue to support backward compatibility with older versions of Excel. The issue may cause a file that is saved in a more recent version of Excel fail to load properly in older versions of Excel due to functions such as IFERROR and XLOOKUP added to Excel since Office 2007.
  • We fixed an issue where some files would occasionally fail to open in Protected View.
  • We fixed an issue that caused the status bar to not indicate a Ready state for some users.

outlook new iconOutlook

Notable fixes
  • We fixed an issue that caused name resolution to fail when sending on behalf of another user and resolving against an address book that is not the Global Address List.
word new iconWord
Notable fixes
  • We fixed a issue where placeholder text was clipped in comments when using right-to-left languages.
Office 
Notable fixes
  • We fixed an issue where hyperlinks including digits would be broken when composing a message in Outlook in a right-to-left language.
  • We fixed an issue where some Scalable Vector Graphics (SVG) did not render correctly.

April 16, 2021 , Version 2105 (Build 14007.20002)

Excel

Notable fixes
  • We fixed an issue that caused Excel to crash when using 32 bit Office on 64 bit Windows.
  • We fixed an issue that caused Narrator to incorrectly read the properties of two buttons on the Header/Footer tab in the Page Setup dialog box.
PowerPoint
Notable fixes
  • We fixed an issue related to linked pictures.

April 9, 2021 , Version 2105 (Build 14002.20000)

Excel

Accessibility ribbon

Find all of the tools you need to create accessible content in one place – the Accessibility ribbon!

word new iconWord
Proofing for selected text within the Document

With these changes you can now review spelling, grammar and other intelligent writing suggestions for just the selected text. Additionally you can also review suggestions for the whole document.

April 2, 2021 , Version 2104 (Build 13926.20000)

outlook new iconOutlook

Turn on shared calendar improvements

For shared calendars in Office 365, Outlook can update these calendars using the REST API. Turn on the preview for faster and more reliable updates to shared calendars.

word new iconWord
Notable fixes
  • We fixed an issue that prevented specific policies from being honored.
  • We fixed an issue in auto save.
  • We made a fix in Application.OnTime where it might not trigger correctly.
Access
Notable fixes
  • We fixed an issue when an external application requests an accessibility interface, it will prevent us from shutting down until they release their reference.
We compiled all the new features and fixes in April 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 April. 👍🏻 

 

 

OFFICE INSIDER – WHAT HAPPENED IN FEBRUARY?

NEW FEATURES/FIXES

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 February.

 

February 2021

February 26  , Version 2013 (Build 13819.20006)

word new iconWord, PowerPoint

Notable fix

  • We fixed a graphics issue related to unresponsiveness that may occur when loading EMF images.

Excel

Notable fixes

  • We fixed an issue that prevented users from exporting an Excel workbook to PDF.
  • We fixed an issue where some formatting could be lost when copying a sheet while coauthoring.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused users to see attachments getting duplicated when removing DRM protection.
  • We fixed an issue with alignment of multiple comments.
  • We fixed an issue in Read Aloud task pane keyboard shortcuts.

OneNote

Notable fixes

  • We fixed an issue that updates OneDrive places to now be filtered out as appropriate per the group policy setting.

Project

Notable fixes

  • We fixed an issue where task splits may be wrongly created when saving a project from Project web app to a local file. This would happen if a task calendar with non-standard working times was being used.
  • We fixed an issue where if the indicator column is not in the first column spot, when you cut a summary task you aren’t warned that the subtasks will also be removed.
  • We fixed an issue where if a user selected the Add Yourself to a Task function on their Timesheet, the correctly resource availability units may not be used on the created assignment.

February 19 , Version 2013 (Build 13811.20002)

Word

Notable fixes

  • We fixed an issue in Read Aloud task pane keyboard shortcuts.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused users to see attachments getting duplicated when removing DRM protection.

Project

Notable fixes

  • We fixed an issue where if the indicator column is not in the first column spot, when you cut a summary task you aren’t warned that the subtasks will also be removed.
  • We fixed an issue where if a user selected the Add Yourself to a Task function on their Timesheet, the correctly resource availability units may not be used on the created assignment.

February 12 , Version 2103 (Build 13806.20000)

Word, outlook new iconOutlook

Dictation available in more languages

Dictation is available in more languages so more speakers can use speech-to-text. The feature supports seven new languages: Hindi, Russian, Polish, Portuguese (Portugal), Korean, Thai, and Chinese (Taiwan).

outlook new iconOutlook

Faster suggestions

Microsoft Search will provide more faster, more relevant suggestions when adding people to the To, CC, and BCC lines.

Excel

Notable fixes

  • We fixed an issue where Excel would sometimes close unexpectedly when trying to show the Data Types card due to a not being able to retrieve an image.

PowerPoint

Notable fixes

  • We fixed an issue with looping animations and audio bookmarks.

word new iconWord

Notable fixes

  • We fixed an issue in AutoSave.
  • We fixed an issue in resolving conflicts while in coauthoring.

Project

Notable fixes

  • We fixed an issue where Project may close unexpectedly if you are running JAWS and go to the task information dialog.
  • We fixed an issue where a task that are 100% complete may revert back to 99% complete.

February 5 , Version 2102 (Build 13801.20004)

Access

New Feature

You will now see selected tabs clearer in Access.

Excel

Notable fixes

  • We fixed an issue where Excel would stop responding after selecting a data series in a chart.
  • We fixed an issue where pressing Enter with certain keyboards on Android would add a new line rather than moving to the next cell.
  • We fixed an issue related to pictures retaining their aspect ratio during a crop operation.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused mails to be sent as digitally signed after the user unchecked that option.

PowerPoint

Notable fixes

  • We fixed an issue related to pictures retaining their aspect ratio during a crop operation.

word new iconWord

Notable fixes

  • We fixed an issue related to pictures retaining their aspect ratio during a crop operation.
  • We fixed an issue which the comment may be truncated with links.
  • We fixed an issue with conflict mode when coauthoring.
  • We fixed an issue in saving to SharePoint Online
  • We fixed an issue in exporting Word document to PDF.

Office Suite

Notable fixes

  • We fixed an issue where Office would in some circumstances present sensitivity labels for one signed-in account when it should present sensitivity labels for a different signed-in account.

 

We compiled all the new features and fixes in February 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 February. 👍🏻 

 

OFFICE INSIDER – WHAT HAPPENED IN JANUARY?

NEW FEATURES/FIXES

 

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 January.

 

January 29 , Version 2102 (Build 13721.20008)

Excel

Notable fixes

  • We fixed a problem where Excel would unexpectedly quit when you added a Name in the Define Name dialog.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused the encryption icon to fail to display for emails sent using the Encrypt Only option.

msproject new iconProject

Notable fixes

  • We fixed an issue where projects with long Cyrillic names could not be opened through Project Center.

 

 

January 22, 2021 , Version 2102 (Build 13714.20000)

Excel, PowerPoint, word new iconWord, outlook new iconOutlook

Government customers: Apply sensitivity labels to your documents and emails

Sensitivity labeling features are now available for customers in the GCC and GCC-H environments.

Learn more >

Excel

Notable fixes

  • We fixed an issue where certain charts using discontinuous ranges of cells would not load when files are re-opened.
  • We fixed an issue where Excel would fail to launch or crash unexpectedly if certain Windows Security exploit protection settings (SimExec, CallerCheck) are in use.

PowerPoint

Notable fixes

  • We fixed an issue related to displaying emojis with color.

word new iconWord

Notable fixes

  • We fixed an issue that prevented real-time typing and presence from being restored after loosing internet connectivity for a period of time.
  • We fixed an issue with coauthoring.

January 15, 2021 , Version 2101 (Build 13707.20008)

outlook new iconOutlook

Share emails in Teams

You can now share emails into your Microsoft Teams chats and channels.

Visio

Premium content library now available

The premium content library is now available in Visio. Easily insert icons and Scalable Vector Graphics (SVG) files into your Microsoft Visio documents. Once they’re in place, rotate, color, and resize them with no loss of image quality. This feature is already available in other Microsoft Office apps like PowerPoint and Word.

Learn more >

Word

Notable fixes

  • We fixed an issue where running the VBA macro ExportAsFixedFormat2 fails with an error stating “Presentation (unknown member) illegal value.”

Project

Notable fixes

  • We fixed an issue where when a cost resource was assigned to a milestone task, baseline cost didn’t rollup correctly.

January 8, 2021 , Version 2101 (Build 13704.20000)

Word, outlook new iconOutlook

Dictation updates

It’s now easier to create content with your voice with the new dictation toolbar, voice commands, and auto-punctuation support.

Excel

Notable fixes

  • We fixed an issue where Preview of embedded Excel range in PowerPoint shows incorrect size.

January 1, 2021 , Version 2101 (Build 13624.20002)

Excel, word new iconWord, PowerPoint 

Mandatory Labeling 

Admins can now require users to label their documents and emails with the new Mandatory Labeling policy. To enable this feature, admins can use the M365 Compliance Center and set up a labeling policy that “Require users to label their documents and mails.” To disable this feature, admins can remove the label policy.  

word new iconWord 

Notable fixes 

  • We fixed an issue when editing a commenting post with @mention. 
  • We fixed an issue to make Modern comments more robust. 
  • We fixed an issue with nested scrollbars in the comments pane.
  • We fixed an issue with comment drafts disappearing when creating a new Word instance. 

PowerPoint 

Notable fixes

  • We fixed an issue with Merge Shapes working with text. 

outlook new iconOutlook 

Notable fixes

  • We fixed an issue and now Outlook can take advantage of an Exchange server setting that suppresses the display of the Exchange Online Archive Mailbox to end users. 

OneNote 

Notable fixes

  • We fixed an issue that addresses a rendering issue affecting OneNote. 

 

We compiled all the new features and fixes in January 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 January. 👍🏻 

OFFICE INSIDER – WHAT HAPPENED IN DECEMBER?

NEW FEATURES/FIXES

 

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 December.

 

December 25, 2020 , Version 2101 (Build 13617.20002)

Excel, word new iconWord, PowerPoint

Notable fixes

  • We fixed an issue related to changing outline colors of SVG images.

Excel

Notable fixes

  • We fixed an issue where Excel would close unexpectedly when opening UNC files that have invalid file attributes (creation time, modified time, etc.).
  • We fixed an issue where decimal and thousands separators settings carryover when copying a chart from Excel and pasting into Word.

word new iconWord

Notable fixes

  • We fixed an issue that caused users to be unable to specify how long they wanted to allow access for when starting a mail merge from Word, resulting in them getting excess prompts.
  • We fixed an issue that caused a Outlook to close unexpectedly for users of Redemption based Add-ins.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused users to be unable to specify how long they wanted to allow access for when starting a mail merge from Word, resulting in them getting excess prompts.
  • We fixed an issue that caused a Outlook to close unexpectedly for users of Redemption based Add-ins.

December 18, 2020 , Version 2101 (Build 13610.20002)

Excel, Word, PowerPoint, Outlook

Send audit data about sensitivity labeling to M365 administrators

When users apply, change, or remove sensitivity labels on their documents and emails, Office will send up audit data to the M365 audit backend for administrators to see. This is a silent functionality (no UI) for administrator benefit. Admins can view and search the data through the Activity Explorer or Audit Logs.

Excel

Notable fixes

  • We fixed an issue that made a performance improvement when applying formatting styles to pivot tables.

word new iconWord

Notable fixes

  • We fixed an issue that occurred with animation when typing on the bottom of a comment card.
  • We fixed an issue where Word hangs when saving document to PDF with hidden text.

PowerPoint

Notable fixes

  • We have fixed an issue and now adding audio and video files will be successful.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused the start time of some calendar items to change unexpectedly when the event is copied from another appointment.
  • We fixed and issue that caused users to be unable to select more than one category to search.

msproject new iconProject

Notable fixes

  • We fixed an issue where users open projects which have supposedly been saved with updated information, but find the updates are is missing.

December 11, 2020 , Version 2101 (Build 13604.20000)

word new iconWord

Better collaboration with modern comments 

Add comments to objects, @mention colleagues, and resolve comment threads for a better collaboration experience. The Comments pane is part of our effort to bring consistency to the reviewing experience and facilitate collaboration across Office apps and platforms. Learn more >

Notable fixes

  • We fixed a bug around deleting modern comments in a content control that is marked as not editable. 

outlook new iconOutlook

Your Outlook settings in the cloud 

Choose your Outlook for Windows settings like Automatic Replies, Focused Inbox, and Privacy, and get to them on any PC. Outlook will now store/retrieve settings from the cloud, so when you set up a new Windows device, your settings will be loaded automatically based on your Office identity. 

Notable fixes

  • We fixed an issue that caused plain text S/MIME messages to become garbled when sending. 

Excel

Notable fixes

  • We fixed an issue with switching separators after a Selection.Parent.Copy call. 
  • We fixed an issue where Excel would incorrectly show a message bar that a new version of the file is available and force the user to save their changes in a copy of the workbook or discard their changes. 

PowerPoint

Notable fixes

  • We fixed an issue with looping background videos playing back in Slide Show. 
  • We fixed an issue where font size command, added in QAT, auto completes to the nearest defined font size while updating it. 

December 4, 2020 , Version 2012 (Build 13530.20000)

Excel

LAMBDA

Do you make use of repeated calculations you wish you could define once and reuse? Have you ever looked for a function, but couldn’t find one that fits your specific needs? Or, maybe, you’ve run into this type of issue before and investigated creating VBA User Defined Functions (UDF) or JavaScript custom functions, only to discover that you need to learn a new language. 

All that changes today with the release of the LAMBDA function. 

Learn more >

Notable fix

  • We fixed an issue where a broken hyperlink to a help article in an alert in case Autosave becomes disabled.
  • We fixed an issue where editing in languages that require the use of IME would behave poorly when editing in overwrite mode.
  • We fixed an issue where Excel would close unexpectedly when copying and pasting data in formula view.

outlook new iconOutlook

Shorten appointments and events

In Jan 2019, we released the End Early feature. Now you can choose between ending early or starting late. This adds a breaks between back to back meetings and gives people time to get to their next meeting.

Learn more >

Notable fix

  • We fixed an issue that caused SmartLinks to lose their formatting when saved to drafts.

Visio

New Azure stencils and shapes

We’ve added many more stencils to help you create up-to-date Azure diagrams.

> Learn more

Word

Notable fix

  • We fixed an issue that prevented users from pasting as plain text.

Project

Notable fixes

  • We fixed an issue where opening a project with a lot of resources was taking a long time.
  • We fixed an issue where specific projects could be opened if there was an issue with the project file in a specific part of load.

 

 

We compiled all the new features and fixes in December 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 December. 👍🏻 

 

Office Insider – What Happened in November 2020?

NEW FEATURES/FIXES

 

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 November.

 

 

November 6, 2020

Excel

Unhide multiple sheets at once

By popular request, this feature helps you unhide multiple sheets at once.

Notable fixes

  • We fixed an issue where Excel terminated unexpectedly when updating.

outlook new iconOutlook

Same signature on all devices

Your signature is stored in the cloud. Create it once and use it everywhere you use Outlook for Windows.

Notable fixes

  • We fixed and issue where adding an attachment to a message opened from a zip file would fail.

 

November 13, 2020

Excel

Notable fix

  • We fixed an issue where the Insert Object command does not show the correct icon when inserting a file from OneDrive local sync folder.

word new iconWord

Notable fixes

  • We fixed an issue related to pictures becoming blurry while zooming.

  • We fixed an issue where long hyperlinks were getting truncated.

PowerPoint

Notable fix

  • We fixed a VBA issue where Slide.Shapes.AddMediaObject2 crashing with legacy video formats (MPG-1,Mpeg-2).

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused the To: field to be blank in task status reports.

msproject new iconProject

Notable fixes

  • We fixed an issue where you couldn’t delete dependencies on the deliverables if the SharePoint site the deliverable was associated with no longer existed.
  • We fixed an issue where users open projects which have supposedly been saved with updated information, but find the updates are is missing.

 

November 20, 2020

PowerPoint

Premium Content Library now has videos

Earlier this year, we released Premium Creative Content, a growing in-app library of royalty-free images, stickers, icons, and more to help M365 subscribers express themselves. We’re excited to share we’re expanding this library with videos!

Learn more >

outlook new iconOutlook

Every meeting online

Make it easier to schedule online meetings with a new setting to make all your meetings online by default.

word new iconWord

Notable fix

  • We fixed an issue where Word hangs when saving document to PDF with hidden text.

PowerPoint

Notable fix

  • We fixed an issue where an unknown coauthor’s presence indicator does not get completely refreshed when more information about the coauthor is available.

 

November 27, 2020

Excel

Notable fix

  • We fixed an issue where Power Pivot wasn’t able to correctly import a tab-delimited text file.

outlook new iconOutlook

Notable fix

  • We fixed an issue that was causing users to experience some issues when sending Outlook mail from applications other than Outlook.

PowerPoint

Notable fix

  • We fixed an issue that caused timeouts during ink analysis.
  • We fixed an issue that caused a grammatical error in the Create an Animated GIF user interface.
  • We fixed an issue where some corrupt PowerPoint files were not opening correctly, even after a document repair operation.

msproject new iconProject

Notable fix

  • We fixed an issue where users may see multiple unassigned assignments associated with a task.
  • We fixed an issue where in large projects it can be very slow to enter a task name.

 

We compiled all the new features and fixes in November 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 November. 👍🏻 

Office Insider – What Happened in October?

NEW FEATURES/FIXES

 

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 October.

 

October 02, 2020

Excel

Use the Advanced Dialog to create Data Types

Excel has a number of linked data types that you can use right away. But, you can also create your own data type from any supported data source by using Power Query. Now, the Advanced Dialog allows you to manually select the columns which combine the Data Type you are creating.

 

PowerPoint

Notable fixes

  • We fixed an issue where PowerPoint was not exporting rectangle bullet points while exporting to PDF.
  • We fixed an issue that when you were on the last slide and swiped to the next slide after pressing ‘End Session’ and before the summary shows up, the End-Session dialog was still visible on the summary page as well.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused automatically generated emails to be sent with a blank body when the subject is blank.
  • We fixed an issue where the wrong folder guid was cached for folders.
  • We fixed an issue where track changes turned on after reopening draft from read-only preview pane.
  • We fixed an issue to provide a user a way to customize justification text when overriding a policy.
  • We fixed an issue where the Save As option was not available for classic attachments.
  • We fixed an issue where when a user copy-and-pastes an email address into the recipient field with the display name, the email address wasn’t always parsed correctly and caused a warning about an invalid email address to appear.
  • We fixed an issue where online shared folders did not return parent folder name. Instead of failing, it returned an empty path which incorrectly went to the primary account.

OneNote

Notable fixes

  • We fixed an issue where a user was unable to select and copy notebook URL from textbox in OutSpace File > Info.

msproject new iconProject

Notable fixes

  • We fixed an issue where if you have custom fields with formulas and are using earned value, you may notice performance delays switching views and opening project/task details.
  • We fixed an issue where the ConsolidateProjects VBA method may file if you try to add the same project multiple times and have AttachToSources set to false.
  • We fixed an issue where if you have eventing code running and try to make changes through a Task Form view, clicking the OK button may not commit the changes.
  • We fixed an issue where Project may crash if you apply a group by to the Resource Usage or Sheet view and then insert a column.

 

October 9, 2020

Excel

Create Power Platform dataflows from queries

You can now export your queries into Power Query templates that can be used to create new Power Platform dataflows.

Notable fixes

  • We fixed an issue where Filename was not changing after a SaveAs operation with COM add-ins enabled.
  • We fixed an issue when Auto-Save fails with incorrect/misleading error message when there’s a bad measure definition in the Excel data model.
  • We fixed an issue where zooming in and out from the presentation area resulted in a gap between the zoomed selection marquee and the mouse pointer.

PowerPoint

Export animated GIF in a range

Select a range of slides when exporting to animated GIF.

Create GIFs with transparent backgrounds

We’ve begun rolling out the ability to 

export animated GIFs with a transparent background.

Learn more >

Notable fixes

  • We fixed an issue where zooming in and out from the presentation area resulted in a gap between the zoomed selection marquee and the mouse pointer.

outlook new iconOutlook

Notable fixes

  • We fixed an issue where quick print for image attachments resulted in error, “Windows can’t find this picture. Check the location, and then try again”.
  • Fixes an issue that caused some users to see Outlook to start in an Offline state until they manually chose to work online.

msproject new iconProject

Notable fixes

  • Fixed an issue where the NewVal in the ProjectBeforeTaskChagne event doesn’t have the correct value if a lag is changed within a Task Form type view.
  • Fixed an issue where if you have a task list in a project site and group the task list, you will not be able to quick edit the task list.
  • Fixed an issue where if you update an enterprise resource via CSOM, resource max units may be lost.

word new iconWord

Notable fixes

  • We fixed an issue where zooming in and out from the presentation area resulted in a gap between the zoomed selection marquee and the mouse pointer.

Office Suite

Notable fixes

  • We fixed an issue where SSO API interactive Sign-In was returning an error code.

 

October 16, 2020

Excel, Word, PowerPoint, Outlook

Paste SVG content from Office to third party apps

You can now paste SVG content from Office into third party apps that support SVG. This feature is available in Word, Excel, PowerPoint, and Outlook. We’re working on releasing it to the other Office apps shortly.

Learn more > 

PowerPoint

Notable fixes

  • We fixed an issue where In content placeholder icon next to Pictures didn’t have a tooltip.
  • We have fixed an issue where Protected view of slide show, shown by pptsx file, allows screen capture of IRM protected document.

Outlook

Notable fixes

  • We fixed an issue where starting Outlook failed while loading nickname cache.
  • We fixed an issue where users were unable to delete appointments in Calendar of Microsoft 365 Groups in Basic Auth.

October 23, 2020

PowerPoint

Presenter Coach now available on desktop

Presenter Coach helps you prepare to give more effective presentations by evaluating you pacing, pitch, use of filler words and much more. It is now available in PowerPoint on Windows Desktop in addition to PowerPoint on the Web.

Learn more >

Notable fixes

  • We fixed an issue when duplicating slideshow to secondary monitor, the slideshow may hide behind other window.

word new iconWord

Notable fixes

  • We fixed an issue in Track Changes where sometimes opening a Word document might display error dialog.
  • We fixed a print issue when sensitivity label with watermarks are applied.

outlook new iconOutlook

Notable fixes

  • We fixed an issue when pasting a URL copied from meeting location to somewhere else (such as a browser), the URL contains a semicolon at the end.

msproject new iconProject

Notable fixes

  • We fixed an issue where Project may terminate unexpectedly on opening files where resource contours were specified in a certain manner.

Access

Notable fixes

  • We fixed an issue where some users were seeing the “system resource exceeded” error when they tried to export a query from their synced OneDrive folder.
  • We fixed an issue where auto-switching between form windows was switching to another form.

 

October 30, 2020

Excel

Improved Conditional Formatting dialogs

Conditional Formatting dialogs are resizable, and you can duplicate a rule with a single click.

Notable fixes

  • We fixed an issue with Power Pivot when using a connection to an Oracle database.
  • We fixed an issue where Excel terminated unexpectedly when the process of MTR calc and Group Policy Object update (e.g. via Remote Group Policy Refresh) was triggered.
  • We fixed an issue which caused a failure in Excel on attempt to load an atomsvc file.

word new iconWord

Notable fixes

  • We fixed an issue where clicking comment hint didn’t zoom out to show comment card in view.
  • We fixed a layout issue which the line between columns might have shifted.
  • We fixed an issue where Word appears to hang when inserting an Excel workbook into a Word document.

PowerPoint

Notable fixes

  • We fixed an issue where grid lines were getting shifted from slides when closing design pane.
  • We fixed an issue where the scroll bar in the slide starts adjusting itself after stopping screen recording with selection pane opened.

Outlook

Notable fixes

  • We fixed an issue which caused Outlook to stop working sporadically when adding or saving attachments.
  • We fixed an issue where saving email templates as .OFT changed Chinese characters to question marks.
  • We fixed an issue where a mailbox owner wasn’t able to manage Shared permission for their own Calendar as the option was greyed out.
  • We fixed an issue where Outlook was not able to create a message with restricted permission.

msproject new iconProject

Notable fixes

  • We fixed an issue where resource engagements searched for a resource by name instead of GUID which would cause issues if there were multiple resources with the same name.
  • We fixed an issue where when you save a project from PWA to a local mpp file, the

Access

Notable fixes

  • We fixed an issue when using DAO from non-Office applications would cause the application to close unexpectedly.

Office

Notable fixes

  • We fixed an issue in the Office Deployment Tool where configuration was failing when using the RemoveMSI feature with the Office 2007 “Microsoft Application Error Reporting” product present.

 

 

We compiled all the new features and fixes in October 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 October. 👍🏻 

Explore the skills of Go To Special!

The function that allows you to detect all cells that contain special data like comments, formula, space, and data validation in your Excel list is the Go To Special function.

With this formula, you can select the cells with formulas at once and encrypt them with a formula; select the blank cells at once and highlight them; select the cells that contain numbers, text, or conditional formatting all together and execute the action you need.

This function is located in the Find&Select button in the Editing group in Home tab.

You can also press F5 (you might need to press the fn key as well) and choose Go To Special in the window that pops up.

Explore the skills of the Go To Special window and facilitate your work!

Let’s think about a scenario where we will fill the blanks in the Satış Bölgesi (Sales Region) column with the correct data like shown above.

First, we need to select the blank cells and then fill in the correct the quickest way possible!

How can we fill these cells easily without having to type into each of them one-by-one?

We will execute this action by using two features together.

Action Steps

  1. First, select the column that has the blank cells.
  2. The F5 shortcut (You might need to press the fn key) –> Go To Special
  3. Select Blanks in the window that pops open and click OK.

Then, we get the look below

You will see that the selected cells are gray and the cell on top is white. You can write into this cell directly. Which means that you don’t have to click to cell to be able to write. The reason why we focus on this is because the areas you want to work on are already selected, so no mouse click is needed. When you click a selected area with the mouse, it cancels the selection so you should be careful about it.

  1. We will write =G2 (the address of the cell right above it) through the keyboard directly. This way we get to say that we will use the data above to Excel. The most important point: Yes, we will write the data above but how is this formula work in the whole column?

    We move onto the fifth and last step for this action.
  2. For the =G2 action to work in all the selected areas of the column, we should press the CTRL and ENTER keys at the same time. After these steps, the Sales Region column will be filled completely.

    Other Go To Special Articles

    Take a look at this article to detect and encrypt the cells with formula by using the Go To Special window. And take a look at this article to learn which action to take to convert Blank Cells to a fixed text.