Change other default settings in the Normal template. You can customize the Normal template and change default settings for many aspects of a document, such as text formatting, paragraph formatting, document formatting, styles, text, pictures, AutoText entries, and keyboard shortcuts.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

In the Borders and Shading box, design your border:. Under Setting on the left, choose the border style you want.. If you want to remove a border, select None.

Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

On the Outlook status bar, if you see Disconnected, Working Offline, or Trying to connect…, then Outlook can't reach the email server to send your mail.. To fix this problem, on the ribbon, select the Send/Receive tab, then, in the Preferences group, select Work Offline to toggle between offline mode and online mode.You may need to open the message and send it again or choose Send/Receive.

After installing Office apps, you can set up your G Suite Gmail in Outlook. First, sign in to the Google Admin console and confirm your settings.. Note: Links to Google content are provided as a convenience and can change location without notice. Confirm settings in the Google Admin console

After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.

Create a document or other type of library in SharePoint to securely store files where you and your co-workers can find them easily, work on them together, and access them from any device at any time.

Sync passwords using Microsoft Autofill. Microsoft Autofill lets you save your passwords, addresses and payment info, and automatically fill them on sites you visit.