If you're using Word, Outlook, or Excel, you can remove all hyperlinks in a file by using a keyboard shortcut. In Word and Outlook: Press Ctrl+A to select all text. Press Ctrl+Shift+F9. In Excel: Select all cells that contain hyperlinks, or press Ctrl+A to select all cells. Right-click, and then click Remove Hyperlinks.

Tip: Instead of manually entering defined names in formulas, you can have Excel do it automatically for you.Go to Formulas > Defined Names > select Use in Formula, and then select the defined name you want to add.Excel adds the name to the formula.

In the Create New Folder dialog box, name the folder, select where to place it, and then click OK. It’s probably best to place the new folder in the Contacts folder. To make sure your folder is available as an address book, right-click the new folder, and then click Properties. Click the Outlook Address Book tab, and make sure that the check ...

On the calendar grid, double-click a meeting you've created to open it. Edit the one event in the series - make changes to this one instance. Edit series - make changes to the entire series. Edit this and all following events - make changes to this and all following instances of the event. When finished, select Save or Send.

Change part of a document to landscape. Select the content that you want on a landscape page. Go to Layout, and open the Page Setup dialog box. Select Landscape, and in the Apply to box, choose Selected text. Choose either portrait (vertical) or landscape (horizontal) orientation for all or part of your document.

On the Layout tab, in the Data section, click Convert to Text. In the Convert to Text box, under Separate text with, click the separator character you want to use in place of the column boundaries. Rows will be separated by paragraph marks. Click OK. Convert your text into a table, a table back into text, and choose separation characters and ...

REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string. These functions may not be available in all languages. REPLACE is intended for use with languages that use the single-byte character set (SBCS), whereas REPLACEB is intended for use with languages that use the double-byte character ...

Under Customize the Ribbon and under Main Tabs, select the Developer check box. After you show the tab, the Developer tab stays visible, unless you clear the check box or have to reinstall a Microsoft 365 program. The Developer tab is the place to go when you want to do or use the following: Write macros. Run macros that you previously recorded.

This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel.. Description. The COUNTA function counts the number of cells that are not empty in a range.. Syntax. COUNTA(value1, [value2], ...) The COUNTA function syntax has the following arguments:

Select Project > Properties > Change Working Time. In the For calendar list, select the (project calendar) you'd like to edit. Select the Work Weeks tab, and then select Details. Note: Use the Exceptions tab to add holidays to your schedule. Select the day (s) you want to change the working times for, and then choose whether you want them to be ...