In this video, I will show you how to find and select all the cells that have a bold text formatting applied to it.

You can do this easily using the Find and Replace dialog box. There is an option in the Find and Replace dialog box which allows you to select the formatting from a cell and then finds all the cells that have the same formatting.

You can use this to select the cell with bold font formatting and then find all the cells that have bold text.

Once you have selected these, you can easily highlight these, change the formatting, or delete the cells/rows.

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 open specific Excel files when you start Excel.

You can specify a folder so that whenever you start Excel, it will automatically open all the files in that folder.

You can read more about this here: https://ift.tt/2MxbQkI

You can also modify the files in this folder, and Excel would automatically consider these files when you open Excel the next time. You can also add new files to this folder, and Excel would open these files when you start Excel the next time.

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 six examples to compare two columns in Excel for matches and differences.

You can read more about this here: https://ift.tt/2BJshHp

The following examples are covered in this video:
— Compare two columns based on row values
— Compare and highlight values that are in both the columns (using conditional formatting)
— Compare and highlight values that are in one column and not in the other column
— Find names that are in column 1 and not in column 2 (using VLOOKUP)
— Pull matching data point
— Pull matching data point when there is a partial match

Based on your dataset, you may need to change or adjust the method. However, the basic principles would remain the same.

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 #ExcelTutorial

View on YouTube

In this video, I will show you a couple of ways to transpose data in Excel.

The following methods of transposing data are covered in this video:
— Transpose using Paste Special
— Using the TRANSPOSE function
— Transpose using Find and Replace and Paste Special

When you use Paste Special to transpose the data, it will give you the static result. This means that when you change the original dataset, it will not update the resulting transposed data.

If you want to have the transposed data linked, you need to use the Transpose function or the Find and Replace technique I cover in the video.

One issue that I don’t like about the TRANSPOSE function is that you need to select the range which is of the same size as the expected result.

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