If prompted, enter the password to unprotect the worksheet. Select the whole worksheet by selecting Select All. On the Home tab, select the Font Settings popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells dialog box, select the Protection tab and uncheck the Locked box and then select OK.

a1. b1. a2. b2. a4. b4. a5. b5. a6. b6. a7. b7. Because this function allows full column and row references, it returns this result: A ... a string with a comma and a space character, and the value in cell B2. Hauser, Andreas =CONCAT(B3," & ", C3) Joins three things: the string in cell B3, a string consisting of a space with ampersand and ...

Change screen orientation. Windows 11 Windows 10. Windows 11 Windows 10. Select the Start button, then type settings. Select Settings > System > Display, and choose a screen orientation from the drop-down list next to Display orientation. Change screen orientation. Use the Settings app in Windows to change screen orientation.

Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.

Find out which version of Microsoft Edge you have. Here's how: Open the new Microsoft Edge , select Settings and more at the top of the window, and then select Settings . Scroll down and select About Microsoft Edge. Note: This topic is for the new Microsoft Edge . Get help for the legacy version of Microsoft Edge .

Windows 10. In the search box on the taskbar, type device manager, then select Device Manager from the menu. Open Device Manager.

In the search box on the taskbar, enter device manager, then select Device Manager. Select a category to see names of devices, then right-click (or press and hold) the one you’d like to update. Select Search automatically for updated driver software. Select Update Driver. If Windows doesn't find a new driver, you can try looking for one on ...

Here’s the list for the new Microsoft Edge and Microsoft Edge for Mac. Windows Mac. Press this key. To do this. Ctrl + Shift + B. Show or hide the favorites bar. Alt + Shift + B. Set focus on the first item in the favorites bar. Ctrl + D.

This article applies if you’ve recently made changes to your device hardware and are trying to upgrade to Windows 11. Hardware changes might affect your upgrade eligibility, though you’ll need to take a few steps to see your updated eligibility in Settings.

The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis ...