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

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.

Note: If your data is in an Excel table, the Transpose feature isn't available.You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns.

Choose either portrait (vertical) or landscape (horizontal) orientation for all or part of your document.

To add some extra visual interest to your document, add a background color using the Page Color button. You can also add a watermark.. Add or change the background color. Go to Design > Page Color.

On the Email tab, choose your account (profile), and then choose Repair.

Windows 10 More... Less. When you connect a scanner to your device or add a new scanner to your home network, you can usually start scanning pictures and documents right away. If your scanner doesn't automatically install, here's some help to get things working.

Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells. Select unlocked cells

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.