Open Large CSV in Excel
Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…
Tag: medium
Switch X and Y Axis in Excel
Sometimes when you want to create a line chart, it doesn’t look the way you want. You want one set of values to…
Year Over Year Growth in Excel
When you try to calculate the growth of your company, comparing data to the previous month is not always the best idea because…
Chart Ignore Blank Cells in Excel
When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won’t…
Count Rows in Excel VBA
There are a few methods to count rows and each of them uses VBA. In this example, I’ll show two of them. Range.End…
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…