Fill Handle Not Working in Excel (4 Easy Fixes)

You might not even know what the Fill Handle is while it gets so much of the work done for you. Today, we’re not talking about how the Fill Handle works but about why it wouldn’t work. Details later.First, what is the Fill Handle and why would it be hard to handle? That incredibly small green box that sits on the bottom-right of the select … [Read more...]

How to Insert an Arrow in a Cell in Excel (6 Easy Ways)

The grand job of Excel is to be an analysis tool that gives a quick visual and graphic indication of data. Arrows also play a decent role in playing up to the quick visual part.Pointing to denote the relation between data (datasets, objects such as lists, charts, and graphs) and showing increase and decrease in numerical values are the prime … [Read more...]

How to Insert Bullet Points in Excel (9 Easy Ways)

Excel is not a word processor but you can still find several ways of getting a bullet point on the worksheet because despite being a spreadsheet application, you may opt for lists to be a part of the data (e.g. to-do lists, notes, footnotes).A bullet used in your Excel data can come from an external source through copy-paste or internal sources … [Read more...]

How to Copy Conditional Formatting in Excel (3 Easy Ways)

The number of convenience stores everywhere is a true indicator of how much we revel in convenience. Excel agrees with the lot of us and harbors many such conveniences with multiple methods.Sticking to that theme, today’s tutorial welcomes you to learn about copying Conditional Formatting in Excel. The highlights of this how-to are using Paste … [Read more...]

#SPILL! Error In Excel – How To Fix

#SPILL! error in Excel is most commonly experienced while using a dynamic array function. A formula that cannot fill the required cells with the calculated results creates this error.After the introduction of dynamic arrays, the formulas can often return multiple values. In such cases, the result will be "spilled" in the worksheet, and the cell … [Read more...]

Developer Tab in Excel – Add, Move, Use & Remove

The Developer tab is the home to a fair few advanced features and controls that are widely relied on by the Excel community. All the coding technology that carries out tedious work in the backend, multimedia controls that seem to perform on Excel like magic, you will find all of that under the wing of the Developer tab. But where will you find that … [Read more...]

How to Calculate PERCENTILE in Excel (Formula & Examples)

Have you ever questioned how good or bad your exam went or felt that the examiner was biased against you? Sometimes you get just a good grade even though your exam went stellar and sometimes you did alright but got the result even worse. There’s a good chance that you were graded using the percentile system which varies from the percentage system … [Read more...]

Spell Check in Excel – Shortcuts, Settings & Customizations

Imagine preparing high-profile reports and being the sole creator of a greatly discreditable spelling error in one of the headers. Huff times hundred! We suppose that is enough to make you realize the necessity of checking spellings in Excel because, unlike MS Word, you will not see any red squiggly underlines that will prompt you to fix … [Read more...]