Latest Blog Posts

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 Create a Bar Chart in Excel with Multiple Bars (3 Ways)

  Method 1 - Using the Insert Chart Feature to Create a Bar Chart with Multiple Bars Step 1 - Inserting a 3-D Clustered Bar Chart We ...

How to Combine Text and Numbers in Excel and Keep Formatting

Method 1 - Using the TEXT Function with the Ampersand Operator We have a dataset containing the Text and Number column. We are going to combine text ...

How to Make a Simple Bar Graph in Excel (With Easy Steps)

In this article, we will describe how to make a simple Bar graph in Excel. We will describe the step-by-step procedure to insert a simple Bar graph ...

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 ...

[Fixed!] Excel File Too Large for No Reason (10 Possible Solutions)

Fix 1 - Check for Hidden Worksheets Increasing the Excel File Size For example, let’s take a look at a workbook with a hidden sheet. The sheet tabs ...

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 Create an Excel Chart with Data from Different Columns (3 Methods)

Dataset Overview We've created a dataset called Training Session Dataset for the Year 2021. It features headers labeled as Name, Training Session ...

How to Add Comma in Excel Between Names (4 Suitable Ways)

If you are searching for the solution or some special tricks to how to add comma in Excel between names then you have landed in the right place. ...

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 Ignore Blank Series in Legend of Excel Chart

Excel is a very powerful software. We can perform numerous operations on our datasets with many different Excel tools and features. Using various ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo