Excel Basics

How to Change Font in Excel for All Sheets (4 Suitable Ways)

Method 1- Using Font Option from Home Tab We will change the font for the entire area of all sheets with the Font option from the Home tab: ...

How to Limit Sheet Size in Excel (3 Suitable Ways)

Method 1 - Hide Rows and Columns to Limit Sheet Size in Excel STEPS: Insert the data in an Excel sheet. We have used the range B4:F14 to ...

Determine Sheet Name Limit in Excel (with Easy Steps)

In Microsoft Excel, all the data, calculations, visualization, and analysis are stored either in a single or multiple pages. This page is called an ...

How to Remove Print Margins in Excel (3 Quick Tricks)

We will use the following dataset to demonstrate removing margins. Method 1 - Use the Print Area Tool Steps: Go to the Page Layout ...

How to Create a Table with Subcategories in Excel – 2 Methods

Method 1 - Using a Pivot Table to Create a Table with Subcategories in Excel Steps: Select a cell in the dataset. Go to the Insert tab. ...

[Fixed!] Excel Margins Disappeared (4 Possible Solutions)

In this tutorial, I am going to show you 4 possible solutions to the Excel margins disappeared problem. You can quickly use these fixes even in large ...

How to Deal with Margin Problems While Converting Excel to PDF – 2 Solutions

Solution 1 - Customizing the Margins in the Microsoft Print to PDF Option To customize the margins: Steps: Go to File > Print. ...

How to Set Limit in Excel Cell (5 Simple Ways)

In this article, we will use the following dataset containing various types of cell entries (text, date, time, number and currency) to demonstrate 5 ...

[Fixed!] Not Enough Memory to Delete Rows Error in Excel

Memory issues are fairly common while using the Microsoft Excel program. We’ll illustrate 8 possible origins of this issue and several practical ...

How to Remove HTML Tags from Text in Excel: 2 Suitable Methods

Method 1 - Remove HTML Tags Using Find and Replace Tool Steps: Select the cells (B5:B9 here) where your texts with HTML tags are present. ...

How to Delete Multiple Columns in Excel with a Condition – 3 Methods

This is the sample dataset. To delete multiple columns based on a condition (for example, with a negative Rh factor): Method 1 - Use ...

[Fixed] Excel Margins Not Printing Correctly (6 Possible Solutions)

This tutorial will present various ways to solve the issue of margins not printing correctly in Excel. We’ll use the sample dataset below to ...

How to Limit Data Range in Excel Chart (3 Handy Ways)

We have the following dataset containing the records of profits for 12 months of the year 2021. Method 1 - Using the Chart Filters Feature ...

Excel Decimal Places Problem (5 Possible Solutions)

In this tutorial, I am going to show you 5 possible solutions to the Excel decimal places problem. You can quickly use these fixes even in large ...

How to Update Charts in PowerPoint from Excel Automatically

If you are working for a company or organization, presenting your business ideas and thoughts about various projects and their updates is very common ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo