Add, Increase or Remove Indent in Excel
In the default settings of Excel, numbers in cells align to the right and text to the left. You may need to change…
Category: examples
Set Columns to Repeat at Left in Excel
When you use default Excel settings to print a multi-page Excel file that has row headers in the first column, readers will find…
Create Excel Chart with the If Statement
As already discussed, options for work in Excel are limitless. It is guaranteed that nobody in this world knows everything there is to…
Select Only the Visible Cells in Excel
When we work with an Excel spreadsheet, sometimes some columns are becoming too wide to fit on the screen or maybe there are…
Make X-Axis Linear in Excel
When dealing with charts in Excel, just with everything else- options are virtually limitless. You can customize your data in any way that…
Filter Rows Instead of Columns in Excel
Most people are used to doing things in a certain, predefined way in Excel. One of those things is filtering the data. But…
Change the Axis Scale in an Excel Chart
Excel’s charts are impressive, but some of the automated features in Excel may not be ideal for your specific needs. For this reason,…
Change Horizontal Axis Values in Excel
In this tutorial, I’m going to show you how to change data labels on the x-axis in Excel charts. This procedure is a…
Graph Mean and Standard Deviation in Excel
There are various mathematical functions and operations that can be performed in Excel. The Formulas Tab As seen from the Formulas tab, Excel…
Insert a Tab in Excel Cell
As already mentioned, Excel is a great tool for automatization, numbers, and reporting. It can sometimes be stressful to present the data the…