Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

You can use the Office language options to add a language, to choose the UI display language, and to set the authoring and proofing language. The language options are in the Set the Office Language Preferences section of the Office Options dialog box, which you can access by going to File > Options > Language.The display and authoring languages can be set independently.

Halten Sie die Datei oder den Ordner gedrückt (oder klicken Sie mit der rechten Maustaste darauf), wählen Sie Senden an aus (oder zeigen Sie darauf), und wählen Sie dann Komprimierter (gezippter) Ordner aus. Ein neuer ZIP-Ordner mit demselben Namen wird am gleichen Speicherort erstellt.

It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.

Windows themes A theme is a combination of pictures, colors, and sounds that help you personalize your PC. The latest versions of Windows include many exciting desktop personalization features, such as panoramic themes that extend across two side-by-side monitors, and the ability to have your theme appear on your Start screen.

Use the Xbox Accessories app to configure your controller or headset for your preferred gaming experience.

Keeping leading zeros and large numbers in Excel. Use a custom format to keep the leading zeros. If you want to resolve the issue just within the workbook because it's not used by other programs as a data source, you can use a custom or a special format to keep the leading zeros.

Get more with Copilot Pro Gain priority access to GPT during peak times for accelerated performance to generate answers, content, and AI images even faster.

Support reading and writing by using Immersive Reader to customize how word documents appear while you read and edit. Immersive Reader provides options for a comfortable and easy to process experience by allowing you to listen to the text read aloud or adjust how text appears by modifying spacing, color and more.

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.