Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Mobile
Customize the ribbon in Office - Microsoft Support
What you can customize: You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or unhide your ribbon, and hide those commands you use less often.Also, you can export or import a customized ribbon. What you can't customize: You can't reduce the size of your ribbon, or the size of the text or the icons on the ribbon.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, InfoPath Filler 2013
Block or allow (junk email settings) - Microsoft Support
Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Change the line spacing in Word - Microsoft Support
This overrides the settings of the style you’re currently using. If you decide later to return to the original settings, go to Design > Paragraph Spacing and choose the option under Style Set.The option might be Default, as shown above, or it will show the name of style you’re currently using.. Change the line spacing in a portion of the document
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
A Data Model typically contains several tables arranged in a relationship. You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Model check box.For more information about Data Models, see Find out which data sources are used in a workbook data model, Create a Data Model in Excel, and Use multiple ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Encrypt messages by using S/MIME in Outlook on the web
Install the S/MIME control. Get a certificate, sometimes referred to as a key or digital ID. The first step to use S/MIME is to obtain a certificate from your IT administrator or helpdesk.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Create a form with Microsoft Forms - Microsoft Support
Tip: You can also format your text.Highlight a word or words in your title or questions, and then choose any of the following: Bold (keyboard shortcut - CTRL/Cmd+B), Italic (keyboard shortcut - CTRL/Cmd+I), Underline (keyboard shortcut - CTRL/Cmd+U), Font color, Font size, Numbering, or Bullets.
Applies To: Excel for the web, OneNote for the web, OneDrive (work or school), Microsoft Forms
Multiply and divide numbers in Excel - Microsoft Support
Multiply numbers in different cells by using a formula. You can use the PRODUCT function to multiply numbers, cells, and ranges.. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Excel specifications and limits - Microsoft Support
32-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. A data model’s share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016