Excel Basics Archives

How to Select Row in Excel (9 Methods)

Jul 6, 2024

Method 1 - Clicking on Row Number The simplest way to select a row in Excel is by clicking on the row number you want to select. Method 2 ...

Excel Picture Format: 12 Different Scenarios

May 25, 2024

Method 1 - Making Correction to an Image Get picture format, you have to select the image first in every case. Choose Picture Format ...

Excel Picture Format: 12 Different Scenarios

How to Create a Hierarchy in Excel Using Different Methods

Jun 28, 2024

What Is Hierarchy? Hierarchical Chart: The term “hierarchy” has a dual meaning. First, it refers to a specific type of ...

How to Create a Hierarchy in Excel Using Different Methods

Change Table Style in Excel (Change, Create & Remove)

Dec 26, 2023

Excel Table Styles & Formats is a powerful feature in Excel that allows you to enhance the presentation and organization of datasets in a ...

Change Table Style in Excel (Change, Create & Remove)

Find Last Value in a Range in Excel

Feb 10, 2024

Excel Find Last Value in a Range: Knowledge Hub How to Find the Last Non-Blank Cell in Row in Excel How to Find the Last Cell with Value in ...

Equation Editor in Excel (Insert, Create & Format)

Dec 24, 2023

The purpose of this article is to provide a concise and comprehensive overview of Equation Editor in Excel. First, we will discuss what the Equation ...

Equation Editor in Excel (Insert, Create & Format)

Comments in Excel (Insert, Copy, Format, Hide, Delete & Print)

Jul 6, 2024

This is an overview. Download Practice Workbook Comments in Excel.xlsx How to Insert/Add Comments in Excel 1. Insert ...

Comments in Excel (Insert, Copy, Format, Hide, Delete & Print)

How to make Excel Auto Calculate (6 Easy Methods)

May 9, 2024

The dataset, Sales of Products, has four columns: Product Name, Unit Price, Quantity, and Total Price. To calculate the total ...

How to make Excel Auto Calculate (6 Easy Methods)

How to Use Excel Calculation Options (6 Suitable Examples)

Feb 10, 2024

In this article, you’ll learn 6 suitable examples of how to use Excel Calculation Options. The examples include changing the Calculation Options ...

How to Use Excel Calculation Options (6 Suitable Examples)

Understanding Views in Excel (A Complete Guideline)

Dec 21, 2023

Excel offers various views of the worksheet to make it easy to work with the database. Different views are appropriate in different cases, where each ...

Understanding Views in Excel (A Complete Guideline)

How to Highlight in Excel – 6 Examples

Jul 6, 2024

Method 1 - Using Cell Styles to Highlight Cells Select cells >> go to the Home tab >> Styles >> select Cell Styles >> ...

How to Use Conditional Formatting Icon Sets?

Dec 21, 2023

This article will summarize all the possible cases in conditional formatting icon sets in Excel. In this Excel tutorial, you will learn about - ...

How to Adjust the Margin in Excel (Default/Custom Margins)

Jul 5, 2024

Using the Page Layout Tab STEPS: Select the worksheet you want to print. Go to the Page Layout tab, and from Page Layout, select ...

How to Adjust the Margin in Excel (Default/Custom Margins)

How to Add Quotes in Excel (Single and Double Quotes)

Jun 24, 2024

We will use the following sample dataset to insert quotes in various cells. Download the Practice Workbook Use of Quotes.xlsm ...

How to Add Quotes in Excel (Single and Double Quotes)

How to Insert Object in Excel (Ultimate Guide)

Dec 26, 2023

In this article, you will get a comprehensive guide on how to insert an object in Excel. You will learn to insert objects using Built-in features, ...