Keep Leading Zeros
When you copy data to your workbook you may find that when a number has zeros at the beginning, Excel will strip these…
Category: examples
Privacy Warning Error in Excel
When you try to save your macro-enabled worksheet sometimes you may experience the following error. Privacy warning: This document contains macros, ActiveX controls,…
Group Rows and Columns
Grouping and then collapsing data in Excel can improve readability. It is especially handy when you deal with lots of data. Take a…
Degree Symbol in Excel
The degree symbol can be used in geometry or in determining geographical coordinates. This special symbol can be inserted. There are a few…
Text to Rows in Excel
There is an Excel tool that converts text to columns taking data from a single column and splitting it into multiple columns. But you won’t…
Too Many Different Cell Formats in Excel
When you use Excel 2003 you may encounter the “too many cell formats” error, just after you try to open a file. This…
Print Area
When it comes to printing, Excel will, by default, print the entire worksheet and in many cases, it will take multiple pages. But…
Page Break in Excel
What is Page Break A page break is used to determine where the printed page ends and where begins the next one, so…
Dialog Box Launcher in Excel
When you open Excel, you will find a ribbon at the top of the screen. The ribbon is divided into tabs. Each tab…
Finding and Removing Duplicates in Excel
While working in Excel, you can quickly remove duplicated values when you deal with a few cells. But when you deal with thousands…