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

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

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

To open the Start menu—which contains all your apps, settings, and files—you can do any of the following: On the center or left end of the taskbar, select the Start icon.

Unlinking and re-linking your computer to OneDrive can help solve some sync problems. You can also use these same steps to move your OneDrive to a new location, such as an external disk drive.

Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.

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.

Features with audio and video functionality.. Many features that come as part of Windows can be used to view or play video or audio content, such as the OneNote app which allows users to record or play audio, the Microsoft Edge web browser which can play internet-based media content, the Photos app, the OneDrive app, and others.

Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.