Excel Basics Archives

How to Mirror Image in Excel (2 Easy Methods)

Aug 14, 2022 Excel Basics

While working in Microsoft Excel, we often use images to make our reports more lucrative. But sometimes we need to rotate or flip the image according ...

How to Undo Text to Columns in Excel (3 Simple Methods)

Aug 14, 2022 Excel Basics

In this tutorial, I am going to share with you 3 simple methods on how to undo text to columns in excel. Sometimes, you may not want to split your ...

How to Draw Shapes in Excel (2 Suitable Ways)

Aug 14, 2022 Excel Basics

Sometimes we need to add different shapes to our worksheets in Microsoft Excel. This is very useful to make flow charts, decision-making charts, etc. ...

[Fixed!] Up and Down Arrows Not Working in Excel (8 Solutions)

Aug 14, 2022 Excel Basics

The up and down arrows on your keyboard are the best way to navigate between cells when you're working on an Excel spreadsheet. With these keys ...

How to Add Bullets in Excel Cell (10 Quick Ways)

Aug 14, 2022 Excel Basics

Bullets are very useful symbols to represent certain lists or tables. In Microsoft Word, we are familiar with bullets, but in Excel, it is possible ...

Excel Formula to Return Blank If Cell Value Is Negative

Aug 14, 2022 Excel Basics

Sometimes we use a formula in Microsoft Excel and the calculated result becomes negative, which is unimportant. Instead of showing negative values, ...

How to Turn Off Sheet View in Excel (with Easy Steps)

Aug 14, 2022 Excel Basics

If you are looking for how to turn off Sheet View in Excel, then you are in the right place. In our practical life, we often need to work with Excel ...

How to Flip Rows in Excel (4 Simple Methods)

Aug 13, 2022 Excel Basics

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default ...

How to Show Quick Access Toolbar in Excel (5 Easy Ways)

Aug 12, 2022 Excel Basics

If you are working with Excel and find your Quick Access Toolbar is not showing then this article will be helpful for you. In this article, I will ...

How to Draw a Line Through Text in Excel (6 Easy Ways)

Aug 14, 2022 Excel Basics

Excel is excellent for working with numbers, but formatting text values in the way you want are not always obvious. The example of strikethrough is ...

How to Insert Picture in Excel Using Formula (2 Examples)

Aug 11, 2022 Excel Basics

Inserting images in Excel is not that tough, but it will be a whole lot more convenient if users have the ability to add the images into Excel ...

How to Change Excel Sheet from Right to Left (4 Suitable Ways)

Aug 11, 2022 Excel Basics

This article illustrates how to change the excel sheet direction from right to left. The Excel sheet direction is from left to right by default. You ...

Excel Formula to Lookup Value in Table (3 Suitable Examples)

Aug 11, 2022 Excel Basics

When working with an enormous dataset, it is a very frequent need for us to find some value in the table of the dataset. Finding it manually and ...

How to Stop Autofill Formula in Excel Table (2 Suitable Ways)

Aug 11, 2022 Excel Basics

If you are searching for the solution or some special tricks to stop autofill formula in Excel table then you have landed in the right place. There ...

How to Use Format Painter to Copy Formatting in Excel (5 Ways)

Aug 14, 2022 Excel Basics

Format Painter is one of the most used tools to copy formatting in Excel. Format Painter drastically reduces a load of formatting for each cell ...