In this video, I will show you how to protect a sheet in Excel but have some cells that are unprotected and can be edited.

This can be useful when you’re sharing the workbook with other people and don’t want them to make any edits in some of the cells. In this case, you can only unprotect some cells and keep rest everything protected/locked.

You can also have a password for a specific range so that only the person with the password can edit that range.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).

This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.

Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

Download Excel File: https://ift.tt/33dB3Gd
Learn how to extract top five scores and names of people with the score, including when there are ties or duplicates. Learn about Office 365 Excel Dynamic Array Functions like FILTER and SORT, lean about how the new Excel Calculation Engine Spills the results so we do not have to copy formulas, and learn about how to add Conditional Formatting to Spilled Results.

View on YouTube

In this video, I will show you how to remove line breaks in Excel (using Find and Replace).

Line Break is what makes it possible to have a new line in the same cell in Excel. In some cases, you may want to remove these line breaks and get all the data in one line only.

For example, if you have names data with the first name is one line and the last name in one line, you may want to remove the line break and get it all together in one line.

In this video, I will show you how to use Find and Replace to find all the line breaks and replace these with a blank or a comma. The trick here to tell Find and Replace to find line breaks, which you can do by using the keyboard shortcut Control + J.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

In this video, I will show you how to add a 0 (or multiple zeros) before a number in Excel.

When you add a 0 before a number in Excel, it would automatically be removed. For example, if you enter 010, Excel would remove the 0 and make it 10.

This may be needed if you have data such as zip codes or employee ids and you want to make all these of consistent length.

You can use Custom Number formatting to specify how long you want a number to be. For example, if you want all the numbers to ve five-digit long, you can make the custom format as 00000

This will make sure that your numbers are at least five-digit long.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

In this video, I will show you how to insert a row after every row in your dataset in Excel.

While you can do this easily in a small dataset, doing this manually with a huge dataset is not an option.

You can use a simple sorting technique to reshuffle the rows to make sure you get an empty row after every row in your existing dataset.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube