Excel Examples

How to Delete All Comments in Excel

This 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 »

How to Change Column Width and Row Height in Excel

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 »

How to Select Cells That Meet Certain Criteria in Excel

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 »

How to Filter Cells in Excel

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 »

How to Print Comments in Excel Worksheet

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 »

How to AutoSum Multiple Rows and Columns in Excel

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 »

How to Prevent Duplicate Entries in Columns in Excel

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 »

How to Concatenate Data with a Line Break in Excel

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 »

How to Lock Hidden Columns in Excel

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 »

Sidebar