Excel Basics

How to Center a Title in Excel (2 Quick Ways)

To center a title in Excel across the top of the spreadsheets, we can easily make the sheets look more professional. Excel provides some handy ways ...

How to Insert Page Break Between Rows in Excel

This tutorial will demonstrate how to insert a page break in excel between rows. Page breaks are very helpful in case of breaking a worksheet into ...

What Is Page Break View in Excel?

Need to learn what is page break view in Excel? If you are looking for such unique information, you’ve come to the right place. Here, we will take ...

How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

Here, we have a dataset containing the First Name, Last Name, and Age of some people. Now, we will show you how to add double quotes in Excel ...

How to Insert a Page Break in Excel (4 Easy Ways)

In this article, we will demonstrate 4 effective ways to insert page breaks in Excel. We'll use the sample dataset below to explain our methods. ...

[Fixed!] Missing Gridlines in Excel When Printing (5 Solutions)

We will describe 5 possible ways to fix missing Gridlines in Excel when printing. We'll use a sample data set named Missing Gridlines When Printing. ...

How to Remove Background Color in Excel (5 Ways)

Method 1 - Use the Fill Color Feature to Remove Background Color in Excel Steps: Select the cells you want to remove the background color. We ...

The Print Preview Doesn’t Match the Document in Excel – 7 Solutions

Solution 1 - Unable the Scale Content for A4 Paper Size Click File. Choose Options. In Excel Options, click Advanced. In ...

How to Create Different Views for Different Users in Excel

While collaborating with others on a worksheet, the updates are auto-saved. Changing in one section automatically changes the other. This goes for ...

How to Keep Row Headings in Excel When Scrolling (3 Ways)

Suppose we have a large sample data set with 4 columns and 15 rows of data. We will freeze the column and row headings to keep them visible while ...

How to Add Double Quotes and Comma in Excel with CONCATENATE Function: 2 Easy Formulas

Method 1 - Insert Double Quotes and Comma within CONCATENATE Formula Steps: Select the E5 cell. Write the following formula in the formula ...

How to Make Excel Look Like a Page: 4 Methods

Method 1 - Remove Fill Color Click the Select All button. Go to the Home tab. Select the Fill Color dropdown. Choose No Fill from the ...

How to Insert an Image in an Excel Cell as an Attachment (4 Methods)

Method 1 - Inserting an Image from Your Device Steps Select the desired cell (e.g., C5). Go to the Insert tab. Click the drop-down arrow ...

How to Add Single Quotes in Excel – 5 Methods

This is the sample dataset. To add single quotes to the city names: Method 1 - Using the CHAR Function to Add Single Quotes in Excel CHAR(39) ...

How to Concatenate Single Quotes in Excel (5 Methods)

Dataset Overview To demonstrate these methods, we’ll use a dataset containing information about employee names and departments. Our goal is to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo