Excel Basics

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

Sometimes you may need to print out your data or Excel spreadsheets. In that case, if there are gridlines then it will be easy to read the data. But, ...

How to Remove Background Color in Excel (5 Ways)

While working in Microsoft Excel we might need to change the whole background color in a spreadsheet. Sometimes we download a file and find there are ...

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

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

We must view the row headers when working with a vast dataset that has many rows in order to enter more data and grasp the dataset better when ...

How to Add Double Quotes and Comma in Excel with CONCATENATE

Adding double quotes, commas, or any other special characters to some cells in Excel is a frequent need for Excel users. It is tiring and ...

How to Make Excel Look Like a Page (with Easy Steps)

Need to learn how to make Excel look like a page? If you are looking for such unique tricks, you’ve come to the right place. Here, we will take you ...

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

Inserting images in Excel is a common task for everyone. We add an image in Excel for a different purpose. In this article, we will show four ...

How to Add Single Quotes in Excel (5 Easy Methods)

When we work on an excel worksheet, often we need to add some cells as a single quote. This single quote or an apostrophe means that the cell is a ...

How to Concatenate Single Quotes in Excel (5 Methods)

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

[Fixed!] Excel File Opens Blank Grey Screen (7 Working Solutions)

To illustrate our Solutions to the problem of Excel files opening with the screen greyed out, we'll use the following dataset. Suppose the ...

How to Show Menu Bar in Excel (2 Common Cases)

This tutorial will demonstrate how to show menu bar in Excel. The menu bar gives you easy access to many necessary commands of Excel. The main ...

Column Letter to Number Converter in Excel (5 Easy Examples)

While working in Excel, sometimes we need to determine the current or specific column number. It may be easy for a smaller worksheet to find out the ...

How to Add Watermark in Excel (2 Easy Ways)

A watermark is a logo, text, picture, or pattern. We usually superimpose it onto another image or dataset intentionally. The main purpose of a ...

How to Make Excel Look Like an Application (with Easy Steps)

Looking for ways to know how to make Excel look like an application? Then, this is the right place for you. Microsoft Excel is known worldwide for ...

How to Delete Blank Pages in Print Preview in Excel (4 Easy Ways)

When we work with Microsoft Excel, some blank, unnecessary pages are added unconsciously to the dataset. There are some techniques to delete those ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo