Excel Basics

How to Hide Gridlines on Part of a Sheet in Excel (2 Quick Ways)

By default, Excel shows gridlines in every worksheet. But we can turn it off or hide it partially if we need to. Excel has some features that we can ...

How to Show All Text in an Excel Cell (2 Easy Ways)

Suppose we have a sample data set where some of the text is too long to fit in a single cell. We'll use various commands to help display the text ...

How to Hide Gridlines in Excel (7 Easy Methods)

By default, the Gridlines are shown as gray lines in an Excel file. Those lines help us better visualize the data. However, we may want to hide the ...

How to Mark Workbook as Final in Excel (with Easy Steps)

Do you want to know how to mark a workbook as final in Excel to signal that this is the concluding version of your worksheet? We often use this type ...

Batch QR Code Generator from Excel (with Easy Steps)

What Is a Batch QR Code? A Batch QR code is a QR code that can be used to encode multiple pieces of information. This type of QR code is typically ...

How to Mirror Table on Another Sheet in Excel (4 Easy Methods)

We often need to use the same table in multiple sheets for calculation and analysis. Copying the entire table and pasting it wherever we need is a ...

Excel is Cutting Off Columns When Printing – 8 Solutions

This is the sample dataset. When trying to print the worksheet, two columns are moved to the 2nd page. Solution 1 - Using the Page ...

How to Plot an Equation in Excel: 6 Easy Methods

Method 1 - Plotting a Linear Equation in Excel Generally, linear equations are the most common type of equation in Excel. We use them on a regular ...

How to Fill Empty Cells with Last Value in Excel: 4 Methods

Method 1 - Applying Go To Special Feature and a Formula Steps: Select the entire dataset (B4:D10) and go to Find & Select under Home tab. ...

How to Open the Insert Function Dialog Box in Excel (4 Ways)

In practical terms, Excel functions simplify our work by enabling easy calculations and automation. Yet, sometimes, it's crucial to grasp the details ...

How to Turn on Autocomplete in Excel (3 Easy Ways)

In MS Excel, users often need to enter a lot of data. Entering each data manually is a laborious task. The autocomplete feature of Excel lessens ...

How to Swap Text in Excel: 2 Easy Methods

Method  1 - Swapping Two Adjacent Cells Manually Select the cell that you want to swap. Move the cursor to the upper or lower side of the ...

[Fixed!] Excel Cutting Off Text When Printing to PDF

If you are looking for some special tricks to solve the problem of “Excel cutting off text when printing to PDF”, you've come to the right place. In ...

How to Create a Table with Merged Cells in Excel (4 Easy Methods)

One of the major drawbacks of an Excel table is that you can not create a table with merged cells. Let's assume you have a data set that consists of ...

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

If you are looking for ways to swap non-adjacent cells in Excel, this article is for you. Swapping values can be time-saving for correcting any ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo