Excel - Manage drop-down lists Tutorial

In this video, you will learn how to manage drop-down lists in Excel.
The video covers various techniques such as hiding and unhiding columns or rows, password protecting worksheets, locking specific cells, editing and deleting dropdown list options, and managing named ranges.
This knowledge will help you effectively organize and control data in your Excel spreadsheets.

6:12
1539 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Drop-down lists

In this video, you will learn about drop-down lists in Microsoft 365. The video covers how to create drop-down lists in Excel to limit the entries people can make in a cell.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.

0:55
1302 views

Excel - Password protect workbooks and worksheets in detail

In this video, you will learn about password protecting workbooks and worksheets in detail.
The video covers how to change the default protection for cells, lock specific cells in a worksheet, and protect the worksheet using a password.
This will help you secure your workbook and prevent unauthorized changes.
Additionally, the video explains how to protect the structure of the workbook to prevent deletion, moving, hiding, or renaming of worksheets.
It also demonstrates how to protect the entire workbook with a password, requiring it for any changes.
Finally, the video shows how to remove the password and change it if needed.
By following these steps, you can effectively password protect your workbooks and worksheets in Microsoft 365.

6:00
1520 views

Excel - Password protect workbooks and worksheets

In this video, you will learn how to password protect workbooks and worksheets in Microsoft Excel.
The video covers the steps to encrypt a workbook with a password, requiring others to enter the password to open it.
It also demonstrates how to protect a worksheet with a password, preventing changes to cells or charts.
This will help you secure sensitive data and control access to your Excel files.
Remember to store your password in a safe place as there is no way to recover it if forgotten.
Stay tuned for the next video on preventing the deletion of password-protected worksheets.

2:27
1470 views

Excel - Drop-down list settings

In this video, you will learn about drop-down list settings in Microsoft 365. The video covers how to use drop-down lists in Excel and SharePoint to create interactive forms and improve data entry efficiency.
This will help you create more organized and user-friendly spreadsheets and websites.

4:14
1584 views

Excel - Freeze panes in detail

In this video, you will learn about freezing panes in detail.
The video covers how to freeze specific rows and columns in Excel to keep them visible while scrolling.
It demonstrates selecting the cell below the rows and columns you want to freeze and clicking the Freeze Panes button.
This will help you maintain context while navigating through your spreadsheet.
Additionally, the video shows how to repeat specific rows on every printed page.
By following these steps, you can effectively freeze panes in Excel and improve your workflow.

3:30
1503 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

220 vues

ALL COURSES