Category
Microsoft Office
-

How to Split Cells in Excel
Learn how to split cells in Excel into multiple columns using Text to Columns feature, Flash Fill, or Excel formulas.
-

How to Make a Histogram in Excel
You can easily create a histogram using the Data Analysis ToolPak or the built-in histogram chart in Excel.
-

How to Unhide Rows and Columns in Excel
Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.
-

How to Sort in Excel
You can easily sort your Excel data by text, numbers, date and time, or by cell and font color on one or more columns…
-

How to Remove Password from an Excel Spreadsheet
Forgot password for your excel sheet? No problem, here’s an easy trick to remove the password protection from your excel sheet.
-

How to Divide in Excel
In Excel, you can divide in a cell, cells, columns of cells, a range of cells by a constant number, and by using the…
-

How to Wrap Text in Excel
Microsoft Excel’s Wrap Text feature can wrap text so it appears on multiple lines in a cell, even if it overflows the cell boundary.
-

How to Create a Drop Down List in Excel
Create a drop-down list of items in Excel to make data entry easier, faster and error free. With Excel’s Data Validation feature, you can…
-

How to Freeze Panes in Excel
Ensure certain cells remain visible as you scroll through the data in an Excel sheet by freezing either the top row or the first…
-

How to Remove Duplicates in Excel
Find and remove duplicate data in your Excel sheet using these simple steps.