How to Sort Data Horizontally in Excel
When you have your data arranged in a horizontal table instead of a vertical table, you may need to sort your data horizontally instead of...
Category: Basics
Save Prompt Without Any Changes
Sometimes when you open an Excel file and then close it without making any changes on it. But to your surprise, Excel pops a dialog...
Updating Single Column Formulas
While working in manual calculation mode, you may need to test your formulas occasionally. When this happens, updating single column formulas instead of whole worksheet...
Change Sheet Shortcut
Here is a valuable shortcut for you. It is called Change Sheet. If you are already using Excel mostly without mouse, this shortcut will come...
Equation Tools
You can insert equations in Excel (also in other MS Office applications such as Word and PowerPoint) as symbols using Equation Tools. In this article,...
Import Text Files Into Excel
Once in a while you may encounter data in a text form. If you copy this data and paste it directly to Excel, all columns...
