Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns

Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.

Windows Update checks for updated drivers and software for your devices and install them automatically. Keeping Windows Update on is a good way to make sure your devices continues to work properly and you get the best experience with them.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.

Xbox Support offers help for Xbox, Game Pass, and billing questions. Get advice and customer service in the Xbox Support community.

If you selected the Share button, people will receive an email message inviting them to open the file. They can select the link to open the workbook. A web browser will open, and the workbook will open in Excel for the web. If they want to use the Excel desktop app to co-author, they can select Edit in Desktop App.However, they'll need a version of the Excel app that supports co-authoring.

Choose an option for the ribbon: Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.. Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.. Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select the ellipsis (...

Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.

In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...