Excel Basics

Auto Numbering in Excel After Row Insert (5 Suitable Examples)

Example 1 - Using the ROW Function Steps Select the range of cells B4:F12. Go to the Insert tab in the ribbon. From the Tables ...

How to Make Excel Easier on the Eyes (12 Quick Tips)

This tutorial will guide you on how to make Excel spreadsheets easier on the eyes and pleasing to work with. 12 Quick Tips to Make Excel ...

How to Make First Row as Header in Excel (4 Simple Methods)

Method 1 - Create First Row as Header by Freezing in Excel Steps: Click on the View tab from the ribbon. Click on the Freeze Panes. ...

How to Make a Row Header in Excel (4 Easy Ways)

Here, we have provided a sample dataset that we will use to make a header row in Excel. As you can see, it's not particularly distinct from the data. ...

How to Create a Double Row Header in Excel (3 Easy Ways)

We have the Scores on the Midterm Test. Also, Row 5 includes ID, Name, English, Maths, and Social Science column headers. In the following figures, ...

Guide to Why Excel Status Bar Not Showing Count

Solution: Change the Status Bar Option to Display the Count Value Right-click on the status bar at the bottom of the worksheet interface. ...

How to Make the Picture Background Transparent in Excel -2 Methods

Method 1. Using the Context Menu Steps: Go to the Insert tab and select Shapes in Illustrations. Select Rectangle. Draw the ...

How to Insert Picture in Excel Cell with Text: 2 Easy Methods

Method 1 - Insert Picture Using Pictures Option Steps: Go to the Insert. Go to Illustrations. Choose Pictures. Insert images from This ...

How to Remove Background in Excel (2 Practical Cases)

What Is a Background in Excel? Usually, the default background in an Excel sheet is set to rectangular cells of equal width and height separated by ...

Saving Pictures from Excel to a Folder – 3 Simple Methods

This is the sample dataset. Method 1 - Format the Excel File as a Web Page to Save Pictures to a Folder Steps: Go to the File tab on ...

How to Grey Out Unused Cells in Excel (3 Quick Methods)

Suppose you have a worksheet that contains data in cells of the B2:D12 range, and you want to grey out the remaining cells of the worksheet. Let's ...

How to Center Text in a Cell in Excel (3 Easy Methods)

Method 1 - Using Ribbon to Center Text in a Cell in Excel 1.1 Use Center Align Option Steps: Select the whole data table and go to the Home ...

How to Convert Time to Number in Excel (5 Easy Methods)

Suppose you have a list of time ranges. It contains the Times to Convert into Numbers. Method 1 - Using Format Cells Option to Convert ...

How to AutoFill in Excel with Repeated Sequential Numbers

In this article, we will demonstrate four simple approaches to Autofill a series of sequential numbers repeatedly in Excel. The dataset below has 3 ...

How to Filter Checkboxes in Excel (with Easy Steps)

In this article, we will demonstrate how to add checkboxes in Excel and then Filter them. Step 1 - Enable Developer Tab Before we delve into ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo