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 as well as rows.
You can easily sort your Excel data by text, numbers, date and time, or by cell and font color on one or more columns as well as rows.
Forgot password for your excel sheet? No problem, here's an easy trick to remove the password protection from your excel sheet.
In Excel, you can divide in a cell, cells, columns of cells, a range of cells by a constant number, and by using the QUOTIENT function.
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.
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 easily create drop down lists to enter data on a worksheet or workbook.
Ensure certain cells remain visible as you scroll through the data in an Excel sheet by freezing either the top row or the first column or multiple rows and columns together.
Find and remove duplicate data in your Excel sheet using these simple steps.
Learn how to protect cells in Excel files, so people can't change certain cells or data.
Create a formula for multiplying cells, ranges, or entire columns. Multiply in Excel by using the multiplication symbol (*) or the PRODUCT function.
Easily subtract data in0between cells, columns, and rows in Excel using the '-' and '=' operators in various formulas.
Organize a spreadsheet full of data into a chart/graph in Excel and improve your visuals and reporting using the instructions on this page.
This tutorial explains various methods of merging/combining two or more cells in Excel. It also demonstrates different techniques to combine data from multiple cells without losing data using the Ampersand (&) operator or the CONCAT function.