Excel Basics

How to Perform Numbering in One Cell in Excel (3 Smart Ways)

Sometimes we need to organize a set of data in a single cell to decorate our data. Numbering in Excel in One cell may be a very effective skill to ...

How to Insert Page Number in Excel Cell Not in Header

Method 1 - Inserting Page Number in Excel Cell Step 1: Open VBA Window VBA has its own separate window. You must insert the code in this window, ...

How to Show Only Working Area in Excel (3 Quick Tricks)

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample ...

How to Use Formula for Page Number in Excel (6 Quick Ways)

Consider the dataset shown in cells B4:E26 below. The dataset is divided into two parts - the PC Shipment Tracker (which shows the Product names, the ...

What Is Datasheet View in Excel?

In Microsoft Excel, we generally work in a datasheet view. This type of view helps us perform many actions in Excel. Also, it helps us understand a ...

Unhide Columns in Excel Shortcut Not Working (6 Solutions)

This article illustrates how to fix the issue if the keyboard shortcut to unhide columns in Excel is not working. Assume you have the following ...

How to Change Theme Colors in Excel (with Quick Steps)

When you make a new Excel spreadsheet, you notice that it is usually in the MS office theme color with a built-in theme color. However, there are a ...

How to Make a Title Page in Excel (An Ultimate Guide)

Steps: Insert a header and footer in your Excel sheet. Go to the Insert Menu > Text > Header & Footer. Your sheet should look ...

How to Hide Multiple Columns in Excel: 5 Easy Methods

Method 1 - Using Keyboard Shortcuts to Hide Multiple Columns in Excel Steps: Select columns D and E that contain marks in Physics and ...

How to Remove Bullets and Numbering in Excel – 3 Methods

Method 1 - Using the Find and Replace Feature to Remove Bullets Select all the cells with bullets. Press CTRL + H to open the Find and ...

How to Change the Background in an Excel Sheet (4 Ways)

Method 1 –  Using the Page Layout Tool  Steps: Go to the desired sheet. Click on the Page Layout tab. Choose Background from the Page ...

Save Excel Table as Image with High Resolution (with Easy Steps)

Step 1 - Create an Excel Table Create a table in excel using the CTRL+T shortcut. Step 2 - Copy the Table as Picture Select the ...

How to Make Flashcards in Excel (2 Suitable Ways)

Flashcard is a great way to learn something. In the physical flashcards, the problem is written on one side of the card and the solution on the ...

What Is Page Layout View in Excel? (Detailed Analysis)

This tutorial will demonstrate what is page layout view in Excel? The Excel file is best for calculating or recording large data in a properly ...

How to Align Bullet Points in Excel (2 Easy Ways)

If anyone wants to highlight a point or focus on the gist part of a piece of writing, then adding bullet points is one of the best options. In Excel, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo