Latest Blog Posts

How to Center Text in a Cell in Excel (3 Easy Methods)

Method 1 - Using Ribbon to Center Text in a Cell in Excel 1.1 Use Center Align Option Steps: Select the whole data table and go to the Home ...

How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)

In our daily life, we have to deal with lots of data. Microsoft Excel is an excellent place to store those data. In order to store data or create a ...

How to Change the Printing Scale So All Columns Will Print on a Single Page

The article will show you how to change the printing scale so all columns will print on a single page. Sometimes your Excel workbook can have too ...

How to Convert Time to Number in Excel (5 Easy Methods)

Suppose you have a list of time ranges. It contains the Times to Convert into Numbers. Method 1 - Using Format Cells Option to Convert ...

How to Insert Page Break Based on Cell Value with Excel VBA

We have a dataset with 3 columns: Product, Brand, and Price. We will slightly edit this data for each method. Make sure that the Developer tab is ...

How to Add Legal Paper Size in Excel

Here are the steps to add legal paper size in Excel: Open a workbook in Excel. Navigate to the Page Layout tab. Click on the Size option. ...

Why Is My Excel Sheet Printing So Small (Reasons and Solutions)

It is a frequent need for us to print Excel sheets. While printing, we face a problem very often which is our printed sheet seems smaller than the ...

Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions)

Download the Practice Workbook Fit to Page Too Small.xlsx Why Does Text in Excel Fit to Page Scale/Preview Look Too Small? We have a ...

How to Convert a Number to Military Time in Excel (2 Methods)

What Is Military Time? Military time employs a 24-hour format, consisting of four digits. The first two digits indicate the hour, while the last two ...

How to Hide Chart Series with No Data in Excel (4 Easy Methods)

Method 1 - Use of Chart Filter Steps: Select the range of cells B4 to E12. Go to the Insert tab in the ribbon. From the Charts ...

How to Fix the Trendline Option Not Showing in Excel

In the below dataset there are Employee Names and their Total Sales volume. We will insert different charts and show you the reasons and solutions ...

How to Print Avery 8160 Labels in Excel – 2 Steps

Step 1 - Creating Avery 8160 Labels from Excel Using Microsoft Word Create a dataset. Here, the dataset contains Name, City, State and Zip. ...

How to Add A3 Paper Size in Excel (2 Quick Ways)

Download Practice Workbook Adding A3 Paper Size.xlsx Method 1 - Use Page Layout Tab to Add A3 Paper Size We have a sample dataset of ...

How to Print Labels in Excel Without Word (with Easy Steps)

The usual label printing process from Microsoft Excel involves mail merging spreadsheets with Microsoft Word. But some people prefer completing all ...

How to Make Doughnut Chart with Total in Middle in Excel

Method 1 - Create a Doughnut Chart Steps: Created a dataset with an institution’s average marks in different subjects. Categorize them into the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo