Excel - Freeze or lock panes Tutorial

In this video, you will learn how to freeze or lock panes in Microsoft 365. The video covers the process of freezing the top row or the first column to keep them visible while scrolling.
This feature is useful when you want to keep the header row or a specific column always in view.
Freezing both the top row and the first column simultaneously will also be explained in the next video.
Mastering this technique will enhance your productivity and navigation in Microsoft 365.

1:06
1350 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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
1484 views

Excel - Change the order of columns

In this video, you will learn how to change the order of columns in a table using Microsoft 365. The video demonstrates how to easily move columns to different positions within the table.
This feature is helpful when you want to rearrange columns based on your preferences or specific requirements.
By following the simple steps shown in the video, you can easily modify the column order to suit your needs.
This skill will enhance your data management and organization capabilities in Microsoft 365.

455 views

Word - Collapsible headings

In this video, you will learn about collapsible headings in Microsoft 365. The video covers how to use collapsible headings to organize your content and improve readability.
This feature allows you to collapse and expand sections of your document, making it easier to navigate and focus on specific information.
By using collapsible headings, you can create more structured and professional-looking documents.
This will help you enhance your productivity and create visually appealing documents in Microsoft 365.

3:03
1970 views

Excel - Split a column

In this video, you will learn about how to split a column using Microsoft 365. The video covers the steps to split a column in a concise and easy-to-follow manner.
This tutorial will help you enhance your skills in data manipulation and organization using Microsoft 365, improving your productivity and efficiency.

571 views

Excel - Add a conditional column

In this video, you will learn about adding a conditional column using Microsoft 365. The video covers the steps to add a conditional column in Microsoft 365 and demonstrates how to do it effectively.
This will help you enhance your data analysis and make more informed decisions based on specific conditions.

542 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

204 vues

ALL COURSES