Excel の表に基づいたドロップダウン リストを編集する. ソースの一覧を Excel の表として設定する場合、一覧からアイテムを追加または削除するだけで、自動的に関連するドロップダウンが更新されます。. 項目を追加する場合は、一覧の最後に移動して、新しい項目を入力します。

Note: Excel can’t highlight duplicates in the Values area of a PivotTable report. Select Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values . In the box next to values with , pick the formatting you want to apply to the duplicate values, and then select OK .

Si tienes problemas de sonido o audio, las siguientes sugerencias pueden ayudarte. Las sugerencias se enumeran en orden, por lo que debes empezar por la primera; comprobar si se soluciona el problema y, de no ser así, continuar por la siguiente.

The easiest way to get language packs for Windows 8.1 and Windows RT is to download and install them using the Language Control Panel. Download and install additional languages to view menus, dialog boxes, and other user interface items in your preferred language.

デスクトップで Outlook からのメールに接続できない場合は、 ここに記載された手順に従うと、問題の原因になっている可能性がある Outlook 電子メール プロファイルの問題を Outlook で診断して解決できます。

Important: You shouldn’t rely on the Private feature to prevent other people from accessing the details of your appointments, contacts, or tasks. To ensure that other people can’t read the items that you marked as private, don’t grant them Reviewer (can read items) permission to your Calendar, Contacts, or Tasks folder.

Note: Some PCs don't offer the option to remove a recovery partition. If you experience this, there isn't a recovery partition on your PC that's using additional disc space. Remove the USB flash drive. This is now your Windows 8.1 recovery drive, and you'll need it if you ever need to refresh or reset your PC. Keep it in a safe place and don't ...

Looking for a long-lost app or program? There are several ways you can find what you need. Select Start , and then scroll through the alphabetical list on the left (if your Start screen is set to show as full screen, select All apps, and then scroll through the list).

In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

Select the Start button, then type settings.Select Settings > System > Display, and choose a screen orientation from the drop-down list next to Display orientation. Change screen orientation