Latest Blog Posts

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo