BoltQ

When you import data from other sources into Excel, it may not support the formatting and add unnecessary characters like dashes (-). Besides, many people habitually put a hyphen in a cell with no …

Continue Reading about How To Remove Dashes in Excel? [Declutter Sheets] →

The default layout in Excel is set to a particular dimension that may not work for everyone. This is true especially when you have a lot of data. You may need to take a final look at the spellcheck or …

Continue Reading about How To Zoom-in on Excel? [4 Easy Ways] →

The other day I created, what I thought was a brilliant table. Only for me to realize I swapped a couple of rows completely, which at first I thought to fix by flipping the axis. But soon I realized I …

Continue Reading about How To Move a Row in Excel? [Single or Multiple] →

Subtracting consecutive values in a column is a popular practice. Deriving net values by subtracting the gross is a very common phenomenon. At times we need to subtract a certain percentage of values …

Continue Reading about How To Subtract Two Columns in Excel? [4 Easy Ways] →

Strikethrough text is a text that has a line going through and on it all the way. It looks exactly how we struck some text with a pen. There are four ways to strikethrough in Excel. You can access …

Continue Reading about How To Strikethrough Text in Excel? [4 Easy Ways] →

Two of the most annoying tasks (at least for me) in Excel are to insert a cell, row, or column somewhere and to delete them. How many times have you copied the whole table from a sheet, pasted it into …

Continue Reading about How To Delete Multiple Cells in Excel? [4 Easy Ways] →

There are times when you enter the data wrongly and end up having the axis show up in a reversed manner. Then there are times when you realize it would be better to derive data if you flipped the axis …

Continue Reading about How To Switch X And Y Axis in Excel? [Complete Guide] →