Home Tags Excel

Tag: Excel

What to Do When You Don’t Remember Word Excel VBA Project...

You have spent some time working on a VBA project quite while ago. You locked it down with a password when you delivered it...

How To Display CSV Files with Unicode UTF-8 Encoding in Excel

CSV, comma separated values, is a common format when saving information in a tabular form. Unlike native Excel format, it is cross-platform and requires...

How To Move Chart To New Window in Excel

Here is a trick for those of you working with Excel on a daily basis, especially if you are spending a significant amount of...

Excel How To Clear All Table Header Filter At Once

Excel is excellent in data analysis and data visualization if you have a large set of data needs to be graphically visualized. Excel can...

How To Convert Excel Spreadsheet to JSON

We've covered a neat trick that leverages Google spreadsheet as a JSON back-end service API for developers who are making any REST applications. However, the use case...

Excel Tip: How To Auto-Fit All Columns Width in One Click

How many times you have to double-click the border of the column to make its width to auto-fit the content length? I had one...

Excel Tip: What’s The Easiest Way to Split One Column into...

Let's say you have a column that contains a list of people's full name and now you want to split them into 2 columns...
Advertisment ad adsense adlogger