The FILTER function allows you to filter a range of data based on criteria you define.

Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Download printer drivers. If your printer isn't responding, you may need to remove it and reinstall it so Windows can download and install the proper drivers.

Invisible digital signatures in Word, Excel, or PowerPoint. An invisible digital signature, like a visible digital signature line, assures the authenticity, integrity, and origin of a document.

Enable this setting to give participants more discretion over how they want to be presented in a meeting. Allow attendance report. Attendance reports contain meeting attendance details, including how long attendees stayed, and how long your meeting lasted, and more.. Turn on the Allow attendance reporttoggle to generate, view, and download attendance reports.

The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.

注: [アカウント] が表示されない場合、または既にファイルまたはドキュメントを開いている場合は、メニューから [ファイル] を選び、左側の一覧から [アカウント] または [サポート] を選択します。 [製品情報] の下に、Office 製品の名前と、場合によっては完全なバージョン番号が表示されます。

Use rules to automatically perform specific actions on email that arrives in your inbox. For example, you can create rules that will change the importance level of messages as they come in, automatically move them to other folders, or delete them based on certain criteria.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...