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

Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.

Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.

Install language accessory packs after installing Microsoft Office, to add additional display, help, or proofing tools. Install the language accessory pack for your desired language.

Remove a manual page break. Go to Home and select Show/Hide .. This displays page breaks while you’re working on your document.

If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.

To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.

Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.

By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.

Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.