Excel Basics

How to Save Excel as PDF on One Page (3 Easy Methods)

We often need to save Excel as PDF on one page, but at that time we face troubles when positioning larger Excel Sheets. Often, they lose their ...

How to Copy Multiple Row Height in Excel (3 Quick Tricks)

Excel has no such features that can allow you to copy multiple row heights only. However, you can copy entire row formats. That is how you can manage ...

How to Insert Multiple Blank Rows in Excel (4 Easy Ways)

Sometimes, you may come across a situation where you want to deal with lots of data and as it updates with time, you may need to insert multiple ...

Excel Formula to Insert Rows between Data (2 Simple Examples)

In this article, I will discuss how you can use an Excel formula to insert rows between data. Often working with Microsoft Excel, we need to insert ...

How to Sort Alphanumeric Data in Excel (With Easy Steps)

While working with Microsoft Excel, we need to use the sorted alphanumeric data. In this article, we will demonstrate the step-by-step procedures to ...

How to Add Vertical Gridlines to Excel Chart (2 Easy Methods)

Gridlines are horizontal and vertical lines that run through your chart layout to represent axis divisions. It is beneficial to add horizontal or ...

How to Save Excel as PDF without Cutting Off (4 Suitable Ways)

Microsoft Excel is a type of software where if you alter any cell, it will change the overall dataset. It is really painful in some cases. To remove ...

How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)

If you are looking for some special tricks to save multiple Excel sheets as one PDF, you've come to the right place. In Microsoft Excel, there are ...

How to Convert Excel to PDF with All Columns (5 Suitable Ways)

Portable Document Format or PDF is a versatile file format that is easy to present or exchange documents. You may need to convert your Excel ...

[Fix:] Excel View Side by Side Not Working

Sometimes, users encounter identical Excel files or want to compare between files. In that case, Excel view side by side is very useful. However, in ...

How to Move Data from One Cell to Another in Excel (5 Ways)

When working with Excel, it is a common scenario that we need data in a specific row or column, but we have inserted the data in other rows or ...

How to Remove Gridlines in Excel Graph (5 Easy Methods)

While working with Microsoft Excel, we may use horizontal and vertical graph gridlines to enhance the content in a chart with axes simpler to ...

How to Space out Cells in Excel (2 Easy Approaches)

If you want to have more space between cell contents and the cell border, again if you want to remove space between text/numbers in a cell, then you ...

How to Move Down One Cell Using Excel VBA (with 4 Useful Applications)

If you want to move down one cell from a specific cell or an active cell in a very large dataset then it will not be feasible always. You can smartly ...

How to Make Subtotal and Grand Total in Excel (4 Methods)

Whenever you have a larger dataset and you want to compute subtotal for a specific field or some specific group and grand total covering the entire ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo