Select the Review tab, and then select Unprotect Sheet.If the Unprotect Sheet button is unavailable, turn off the Shared Workbook feature first.. If you don't want the formulas hidden when the sheet is protected in the future, right-click the cells, and select Format Cells.On the Protection tab, clear the Hidden check box.

Important: If your organization is using OneDrive for Business and SharePoint for meeting recordings, the IT admin should turn on Allow transcription in the Teams meeting policy and encourage users to start transcription in every meeting. This will make captions and transcriptions available in post-meeting recordings.

Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:

Country/region. Microsoft Store sales support. Technical or download support. Egypt +20 2 353 3333. Technical support. South Africa. 0800 167 344. Technical support

If your account has been hacked, use our sign-in helper tool below to help guide you to the right solutions. The tool will ask for your email address or phone number, and either show appropriate self-help, or offer the chance to talk to an agent.

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.

Set your default printer. For quicker printing, set a printer as the default printer. This process is different slightly among Windows 7, Windows 8, and Windows 10.

To switch the keyboard layout you're using in Windows 10, press and hold the Windows key and then repeatedly press the Spacebar to cycle through all your installed keyboards. (If this doesn't do anything, it means you have only one installed.)

To add a page number Click or tap where you want the number, select Page Number and choose a style. You may need to edit for better formatting. For more info, see Add page numbers to a header or footer in Word.

Description. The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: