Extendoffice.com how to use, tutorial

How to save received distribution list or contact group in

Details: Easily add contact group members from emails' senders or recipients in Outlook. Normally, we can copy a sender or a recipient from an email, and then add it as a contact group member with Add Members > From Address Book, and it seems no way to add multiple emails' multiple senders or recipients into a contact group in bulk.But, with the excellent Add to Groups feature of Kutools for Outlook

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/2094-outlook-save-received-distribution-list-contact-group.html Go Now

› Get more:  How To UseGo Now

How to save Outlook folder to disk, hard drive or desktop?

Details: How to save Outlook folder to disk, hard drive or desktop? In many cases, you need to save your Outlook folder to disk, hard drive or desktop in order to import this folder information into another Outlook account or for other usage.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/2093-outlook-save-folder.html Go Now

› Get more:  How To UseGo Now

How to sort without first row in Excel? - ExtendOffice

Details: Sort without first row by unselecting the first row. The easiest way to sort excluding first row must be unselecting the first row. Please select the column data from the second row data to the end of the data, or you can select the data of second row then press Ctrl + Shift + keys simultaneously to quickly select the data range from the second row to the end.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2042-excel-sort-without-first-row.html Go Now

› Get more:  How To UseGo Now

How to send a schedule recurring email in Outlook?

Details: Send a schedule recurring email in Outlook with VBA code. This tutorial is divided into four parts, you will succeed to send a schedule recurring email after finish these parts.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/1567-outlook-send-schedule-recurring-email.html Go Now

› Get more:  TutorialGo Now

How to lock and protect selected cells in Excel?

Details: How to lock and protect selected cells from editing in Excel? It's easy to lock and protect the whole worksheet or workbook with clicking the Protect Sheet button or Protect Workbook button under Review tab. However, sometimes you may need to lock and protect only specific cells or selections in a sheet.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/866-excel-lock-protect-cells.html Go Now

› Get more:  How To UseGo Now

How to flip the first and last name in cells in Excel?

Details: Flip the first and last name in a column with a function. We can use one of Excel's formulas to flip the first and last name quickly in a column with following steps:

› Verified 3 days ago

› Url: https://www.extendoffice.com/documents/excel/824-excel-flip-first-last-name.html Go Now

› Get more:  How To UseGo Now

How to change the default browser in Outlook?

Details: Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier! Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features; BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/outlook/1509-outlook-change-default-browser.html Go Now

› Get more:  How To UseGo Now

How to show or restore ribbon in Outlook?

Details: Show or restore Ribbon in Outlook 2013. In Outlook 2013, there is a little difference in showing Ribbon, please do as follows. 1. Please click the Ribbon Display Options button. See screenshot:

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/outlook/1739-outlook-show-restore-ribbon.html Go Now

› Get more:  How To UseGo Now

How To Remove First, Last X Characters Or Certain Position

Details: and press Enter key to get the first result. See screenshot: Note: In the above formula:. A4 is the cell value that you want to remove characters;; The number 2 means the number of characters you want to remove from the beginning of the text string.; 2.Then, select the cell C4 and drag the fill handle down to the cells where you want to apply this formula, and all the first 2 characters have

› Verified 3 days ago

› Url: https://www.extendoffice.com/documents/excel/560-excel-remove-character-from-string.html Go Now

› Get more:  How To UseGo Now

How to remove divide by zero errors (#DIV/0!) in Excel?

Details: How to remove divide by zero errors (#DIV/0!) in Excel? For example, we need to calculate the average price for each fruit by the formula of =D2/(C2-B2) as below screen shot shown. However, #DIV/0! errors come out when the value in Q2 column is equal to the value in Q1 column.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2921-excel-remove-divide-by-zero-errors.html Go Now

› Get more:  How To UseGo Now

How to add best fit line/curve and formula in Excel?

Details: In most cases, you may get multiple sets of experiment data. You can show these sets of data in a scatter chart simultaneously, and then use an amazing chart tool – Add Trend Lines to Multiple Series provided by Kutools for Excel – to add the best fit line/curve and formula in Excel. Kutools for Excel - Includes more than 300 handy tools for Excel.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2642-excel-best-fit-line-curve-function.html Go Now

› Get more:  How To UseGo Now

How to auto populate other cells when selecting values in

Details: Drop down list auto populate with VLOOKUP function. Please do as follows to auto populate other cells when selecting in drop down list. 1. Select a blank cell that you want to auto populate the corresponding value.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2400-excel-drop-down-list-auto-populate.html Go Now

› Get more:  How To UseGo Now

How to find out old email messages in Outlook?

Details: How to find out old email messages in Outlook? Normally messages are arranged and grouped by date, and the messages that you received one month ago will be grouped in the Older group. However, it is tough to find out email messages that are older than specified time, for example messages older than 3 months.

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/outlook/1474-outlook-find-old-emails.html Go Now

› Get more:  How To UseGo Now

How to lock and protect formulas in Excel?

Details: Useful guide, however, I don't think if this is responding to my need. to explain a bit of my need I wanted to lock cells with formulas and formats but I want the formulas to generate what they are supposed to do. i.e.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/935-excel-lock-protect-formulas.html Go Now

› Get more:  GuideGo Now

How to bulk add contacts to contact group in Outlook?

Details: Bulk add contacts to contact group in Outlook<> Please do as follows to bulk add contacts to contact group in Outlook. 1. Shift to the Contacts or People view and create a new contact group by clicking New Contact Group under Home tab in Outlook 2010 and 2013.. In Outlook 2007, click the drop-down icon in the New button, and select Distribution List in the drop-down menu.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/2305-outlook-bulk-add-contacts-to-group.html Go Now

› Get more:  How To UseGo Now

How to create hyperlink in a cell to another sheet in the

Details: Kutools for Excel’s Filename List utility can batch add multiple hyperlinks to all files or one type of files in a certain folder, such as create hyperlinks to all workbooks, to all word documents, to all text files, etc.. Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/958-excel-hyperlink-to-sheet.html Go Now

› Get more:  How To UseGo Now

How to keep formula cell reference constant in Excel?

Details: Let's see how to use this feature to easily keep formula cell reference constant in Excel. 1. After installing Kutools for Excel, please click Kutools > More > Convert Refers to activate the Convert Formula References feature.. 2.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2500-excel-constant-cell-value-reference.html Go Now

› Get more:  How to useGo Now

How to Countif by date/month/year and date range in Excel?

Details: Easily count by Fiscal year, half year, week number, or day of week in Excel. The PivotTable Special Time Grouping feature, provided by Kutools for Excel, is able to add a helper column to calculate the fiscal year, half year, week number, or day of week based on the specified date column, and let you easily count, sum, or average columns based on the calculated results in a new Pivot Table.

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/excel/2501-excel-countif-by-month-date-range-year.html Go Now

› Get more:  How To UseGo Now

How to edit contact group/distribution list in Outlook?

Details: Tip: Easily add contact group members from emails' senders or recipients in Outlook. Normally, we can copy a sender or a recipient from an email, and then add it as a contact group member with Add Members > From Address Book, and it seems no way to add multiple emails' multiple senders or recipients into a contact group in bulk.But, with the excellent Add to Groups feature of Kutools for

› Verified 3 days ago

› Url: https://www.extendoffice.com/documents/outlook/1668-outlook-edit-contact-group-distribution-list.html Go Now

› Get more:  How To UseGo Now

How to delete drop down list in Excel? - ExtendOffice

Details: Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future. More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words. Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/1746-excel-delete-drop-down-list.html Go Now

› Get more:  How To UseGo Now

How to format date, currency and number during mail merge

Details: How to format date, currency and number during mail merge in Word? Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/word/1003-word-mail-merge-date-currency-and-number-format.html Go Now

› Get more:  How To UseGo Now

How to show multiple grand totals in pivot table?

Details: 6.After showing the subtotals at bottom in the pivot table, you can select multiple function for your subtotals. Right click the Total label cell, and choose Field Settings from the context menu, see screenshot:. 7.In the Field Settings dialog box, under Subtotals &Filters tab, please check Custom, and then select the multiple functions that you need in the Select one or more functions list

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2023-how-to-show-multiple-grand-totals-in-pivot-table.html Go Now

› Get more:  How To UseGo Now

How to split comma separated values into rows or columns

Details: Quickly split comma separated values into rows or columns with Kutools for Excel. T he Split Cells utility of Kutools for Excel can help you split comma separated values into rows or columns easily.. 1. Select the cells you need to split, and then click Kutools > Merge & Split > Split Cells.See screenshot:

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/excel/3341-excel-split-comma-separated-values.html Go Now

› Get more:  How To UseGo Now

How to export an Outlook email to PDF file?

Details: How to export an Outlook email to PDF file? As you know, Microsoft Outlook does not support to convert an email to PDF file directly. Usually you can apply the Adobe Acrobat software to do this job. However, if you have not installed the Adobe Acrobat, or other three-party add-ins, how to export emails to PDF files?Here I will introduce two workarounds to export an email to PDF file without

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/3532-outlook-export-email-to-pdf.html Go Now

› Get more:  How To UseGo Now

Outlook: Show calendar as busy, free, tentative, and out

Details: Outlook: Show calendar as busy, free, tentative, and out of office. As an exchange user in Microsoft Outlook, you can set permission for others to view the Free/Busy information in your calendar. Therefore, other users can pick up free time for group schedules, such as meeting.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/1528-outlook-show-calendar-busy-free-out-of-office.html Go Now

› Get more:  How To UseGo Now

How to change positive numbers to negative in Excel?

Details: If you have installed Kutools for Excel, you can change positive numbers to negative as follows:. 1.Select the range you want to change. 2.Click Kutools > Content > Change Sign of Values, see screenshot:. 3.And in the Change Sign of Values dialog box, select Change all positive values to negative option.. 4.Then click OK or Apply.And all of the positive numbers have been converted to negative

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/677-excel-change-positive-numbers-to-negative.html Go Now

› Get more:  How To UseGo Now

How to vlookup to return blank or specific value instead

Details: And then press Enter key, you will get a blank cell instead of the 0, see screenshot:. Notes:. 1. In the above formula, D2 is the criterion which you want to return its relative value, A2:B10 is the data range you use, the number 2 indicates which column that the matched value is returned. 2. If you want to return a specific text instead of the 0 value, you can apply this formula: =IF(LEN

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/excel/2447-excel-vlookup-blank-instead-of-0-n-a.html Go Now

› Get more:  How To UseGo Now

How to count unique values in pivot table?

Details: Count unique values in pivot table with Value Field Settings in Excel 2013 and later versions. In Excel 2013 and later versions, a new Distinct Count function has been added in the pivot table, you can apply this feature to quickly and easily solve this task.. 1.Select your data range and click Insert > PivotTable, in the Create PivotTable dialog box, choose a new worksheet or existing

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2127-excel-pivot-table-count-unique-values.html Go Now

› Get more:  How To UseGo Now

How to extract actual addresses from hyperlinks in Excel?

Details: If you have installed Kutools for Excel, please do as follows:. 1.Select the range which contains the hyperlinks need extracting. 2.Click Kutools > Link > Convert Hyperlinks, see screenshot:. 3.In the Convert Hyperlinks dialog box, select Hyperlinks addresses replace cell contents option, and click button from Result range to specify a cell to put the result.. 4.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/1177-excel-extract-hyperlink-from-cell.html Go Now

› Get more:  How To UseGo Now

How to restore deleted meetings/contacts in Outlook?

Details: Restore permanently deleted meetings or contacts with Recover Deleted Items . As you know, if you have permanently deleted a meeting or contact in Microsoft Outlook, you won’t find out the deleted meeting or contact in the Deleted Items folder.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/2185-outlook-restore-deleted-meetings-contacts.html Go Now

› Get more:  How To UseGo Now

How to VLOOKUP and return zero instead of #N/A in Excel?

Details: Return zero instead of #N/A when using VLOOKUP. To return zero instead of #N/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2628-excel-vlookup-return-instead-of-n-a.html Go Now

› Get more:  How To UseGo Now

How to keep column header viewing when scrolling in Excel?

Details: Keep column header viewing when scrolling with Freeze Panes. To keep the column headers viewing means to freeze the top row of the worksheet. Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row.See screenshot:

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2903-excel-view-column-headers-scrolling.html Go Now

› Get more:  How To UseGo Now

How to quickly convert numbers to English words in Excel?

Details: How to quickly convert numbers to English words in Excel? If you have a column of numeric values in a worksheet, and now you need to convent them to their equivalent English words or English currency words as following screenshot shown.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/1446-excel-convert-change-numbers-to-words.html Go Now

› Get more:  How To UseGo Now

How to prevent email from going to junk in Outlook?

Details: Mark email and email sender as Not Junk in Outlook. If a normal email has already been filtered to the junk email folder, you can mark this email and it’s sender as Not Junk to prevent it from going to junk folder in the future.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/1828-outlook-prevent-email-from-going-to-junk-folder.html Go Now

› Get more:  How To UseGo Now

How to vlookup return value in adjacent or next cell in Excel?

Details: Vlookup return value in adjacent cell in Excel. For example, you have two columns as shown in following screenshot. To vlookup the largest weight in column A and return the adjacent cell value of column B, please do as follows.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2622-excel-vlookup-return-value-adjacent-next-cell.html Go Now

› Get more:  How To UseGo Now

How to insert attachments in the body of email message in

Details: Move attachments from the Message header to the message body. Sometimes you might have inserted attachments already, which showed in the Attached: box above the body of composing email message. In this condition, you can also change the message format, and make the attachments appear in the message body.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/outlook/1346-outlook-attachment-in-body-of-email.html Go Now

› Get more:  How To UseGo Now

How To Group Date By Month, Year, half year or other

Details: Group date by half year, week number or other specific dates in pivot table. With the above method, you can group date by month, year, quarter quickly, but, sometimes, you may want to group date by specific date, such as fiscal year, half year, week number and so on.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2193-excel-group-by-month-year-quarter.html Go Now

› Get more:  How To UseGo Now

How to stop auto formatting number to date in Excel?

Details: Convert text date/number string to standard date. When you copy date from other sources to Excel, the date maybe change to text format, or for convinient, you may type date as number string directly, such as 20160504.In thses case, you may want to convert thses nonstandard dates to the standard date formatting mm/dd/yyyy.Here with Kutools for Excel--a handy tool, its Convert to Date utility

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/1810-excel-stop-auto-formatting-to-date.html Go Now

› Get more:  How To UseGo Now

How to add or remove strikethrough in Excel?

Details: Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future. More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words. Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2230-excel-add-strikethrough.html Go Now

› Get more:  How To UseGo Now

How to convert all footnotes to endnotes in Word?

Details: This method will guide you to convert all footnotes to endnotes in a Word document. Please do as follows: 1. Open the document you will convert all footnotes to endnotes, and click the anchor at bottom-right corner of Footnotes group on the References tab. See screenshot:

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/word/4534-word-convert-footnotes-to-endnotes.html Go Now

› Get more:  GuideGo Now

How to create a drop down list calendar (date picker) in

Details: Easily create a drop down list calendar with a cool tool. As the above method has Excel version restrictions, here highly recommended the Date Picker utility of Kutools for Excel.With this feature, you can easily pick up a date from a popping up drop down calendar when clicking on a date cell.

› Verified 1 days ago

› Url: https://www.extendoffice.com/documents/excel/2437-excel-drop-down-list-calendar.html Go Now

› Get more:  How To UseGo Now

How to change orientation of one page in word?

Details: Change orientation of one page in Margins. 1: Select the entire page that you want to change the orientation, then click Page Layout> Margins and select Custom Margins.. 2: In the Page Setup window, select the orientation you need in Oriention section, and choose Selected text in Apply to.Click OK.. Note:. 1. If you want to change the page apply section, you can click in a section (or select

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/word/980-word-change-orientation-of-one-page.html Go Now

› Get more:  How To UseGo Now

How to limit characters length in a cell in Excel?

Details: 1.Select the range that you will limit date entries with specify character length. 2.Click the Data validation in the Data Tools group under Data tab.. 3.In the Data Validation dialog box, select the Text Length item from the Allow: drop down box. See the following screen shot:

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/952-excel-cell-character-limit.html Go Now

› Get more:  How To UseGo Now

How to combine duplicate rows and sum the values in Excel?

Details: After installing Kutools for Excel, please do as follows:. 1. Select the range you need and click Kutools > Merge & Split > Advanced Combine Rows.See screenshot: 2.In the Advanced Combine Rows dialog, check My data has headers if your range have headers, and select column name which you want to combine the duplicates and click Primary Key, see screenshot:. 3.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/1268-excel-combine-duplicate-rows-and-sum.html Go Now

› Get more:  How To UseGo Now

How to convert birthdate to age quickly in Excel?

Details: The DATEDIF formula used to give the Years and Months in a YY.MM format is understandable. However, each of the 2 components of this formula is a separate number, integer.

› Verified 3 days ago

› Url: https://www.extendoffice.com/documents/excel/853-excel-convert-birthdate-to-age.html Go Now

› Get more:  How To UseGo Now

How to find all combinations that equal a given sum in Excel?

Details: Find cells combination that equal a given sum with Solver Add-in. If you are confused with above method, Excel contains a Solver Add-in feature, by using this add-in, you can also identify the numbers which total amount equals a given value.. 1. First, you need to activate this Solver add-in, please go to File > Options, in the Excel Options dialog box, click Add-Ins from the left pane, and

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/3557-excel-find-all-combinations-that-equal-given-sum.html Go Now

› Get more:  How To UseGo Now

How to disable update links message when open a workbook?

Details: With the Edit Links feature in Excel, we can set an option to suppress the "Update Links" message displayed any more. 1.Click Data > Edit Links, see screenshot:. 2.In the Edit Links dialog box, click Startup Prompt button at the bottom, see screenshot:. 3.And then in the popped out Startup Prompt dialog, you can choose Don’t display the alert and don’t update automatic links or Don’t

› Verified 3 days ago

› Url: https://www.extendoffice.com/documents/excel/2099-excel-disable-update-links-prompt.html Go Now

› Get more:  How To UseGo Now

How to move entire row to another sheet based on cell

Details: Move entire row to another sheet based on cell value with Kutools for Excel. If you are newbie in VBA code. Here I introduce the Select Specific Cells utility of Kutools for Excel.With this utility, you can easily select all rows based on a certain cell value or different cell values in a worksheet, and the copy the selected rows to the destination worksheet as you need.

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/3723-excel-move-row-to-another-sheet-based-on-cell-value.html Go Now

› Get more:  How To UseGo Now

How to count if cell contains text or part of text in Excel?

Details: Tip: Besides the above formula, here introduce an awesome feature to easily solve this problem.With the Select Specific Cells utility of Kutools for Excel, you can quickly count if cell contains text or part of text with clicks.You can even countif with OR or And condition as you need with this feature. Please do as follows. Before using the Kutools for Excel, you need to take minutes to free

› Verified 2 days ago

› Url: https://www.extendoffice.com/documents/excel/2874-excel-count-if-cell-contains-text.html Go Now

› Get more:  How To UseGo Now

Related topics