Learn Microsoft Excel Online FreeThis post will guide you how to delete all comments in your current worksheet in Excel. How do I delete all comments from a worksheet with VBA code in Excel. Delete All Comments with Delete Command Delete All Comments with Go To Special Feature Delete All Comments with VBA Delete All Comments with Delete Command… read more »
This post will guide you how to change the column width and row height for a given range in Excel. How do I resize Row height or column height for a range with VBA Macro in Excel. Change Column Width and Row Height with Format Command Change Column Width and Row Height with VBA Change… read more »
This post will guide you how to select cells that meet certain criteria in Excel. How do I find and select cells based on specific types of data in your worksheet in Excel. Select Cells That Meet one Criteria Using Go To Command Find Cells That Meet one Criteria Using Conditional Formatting Select Cells That… read more »
This post will guide you how to filter cells in one given column in your worksheet. How do I filter cells based on certain criteria in one column in Excel. Filter Cells in One Column Assuming that you have a list of data in range A1:B5, in which contain product names and sale values. And… read more »
This post will guide you how to print comments in your Excel Worksheet. How do I print comments while print your worksheet. Print Comments When you print a worksheet, the comments are not printed by default. As the setting of comments printing is disabled. If you want to print your comments while print your worksheet,… read more »
This post will guide you how to find the maximum value in a range of cells based on single or multiple criteria in Excel. How do I calculate the Minimum value based on criteria with MIN Function in Excel. Find Max Value based on Single Criteria Find Max Value based on Multiple Criteria Find Min… read more »
This post will guide you how to AutoSum function to sum multiple rows and columns quickly in Excel. AutoSum Multiple Rows and Columns Assuming that you have a list of data in range:A1:C5, in which contain numeric values. And you want to sum those numbers at once. How to do it. You can use the… read more »
This post will guide you how to prevent duplicate entries in one or multiple columns in Excel. How do I use Data Validation feature to prevent duplicate values in columns in Excel. Prevent Duplicate Values If you want to prevent duplicate values when entering data into your cells or columns in Excel, you can use… read more »
This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can use CONCATENATE function to combine multiple cells or rows into one cell in Excel. And… read more »
This post will guide you how to lock hidden columns in Excel 2010/2/13/2016. How do I protect and lock hidden columns in Excel. Lock and Protect Hidden Columns You can try to hide the selected columns or unhide them again. But if you want to lock all hidden columns in your worksheet. How to do… read more »
