Excel Basics

How to Add Gridlines in Excel After Highlighting (3 Easy Methods)

Excel worksheets and workbooks display gridlines by default. But, the gridlines disappear as soon as we highlight the cells. And many times, this is ...

How to Hide Extra Cells in Excel (with Quick Steps)

If you are searching for a solution or some special tricks to hide extra cells in Excel then you have landed in the right place. Often you want to ...

How to Check Character Limit in Excel (With Easy Steps)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, ...

How to Change Gridlines in Excel (4 Suitable Ways)

An Excel gridline is the faint gray edge around each cell in the worksheet. In addition to making it easier to read the data, these gridlines help ...

How to Fix If Format Painter Not Working (3 Solutions)

  6 Reasons Why Your Format Painter May Not be Working If the Format Painter is not working in Excel, there are several potential reasons and ...

How to Change Alignment in Excel (5 Easy Methods)

We often face trouble while changing alignment according to our needs in Excel. If you are facing the same, this tutorial will show you 5 different ...

How to Insert Sequential Page Numbers Across Worksheets

Our sample Excel file has several Worksheets. We will insert sequential page numbers across the worksheets. Method 1 - Using Page Layout ...

How to Hide and Unhide Columns in Excel (7 Methods)

Dataset Overview To demonstrate these methods, we’ve prepared a dataset showing information about targets, sales, and profits for a set of products ...

How to Leave Cell Blank If There Is No Data in Excel (5 Ways)

The sample dataset contains the columns Product ID, Quantity, Unit Price, and Cost columns where some of the values for quantity are missing. This ...

How to Convert Text with Spaces to Number in Excel (4 Ways)

Below is a dataset with personal information in the Name, City, and Phone columns. Method 1 - Using the SUBSTITUTE Function to Convert ...

How to Remove Unused Cells in Excel (10 Methods)

Method 1 - Using the Go To Special Command Steps: Select the data range (B4:E12). Press F5 or Ctrl + G to bring up the Go To dialog box. ...

How to Insert Multiple Page Breaks in Excel – 2 Methods

This is the sample dataset. Method 1 - Utilizing the Page Layout tab to Insert Multiple Page Breaks in Excel Step 1: Choose the ...

Hide Columns with No Data in Excel – 4 Methods

This is the sample dataset. To hide all columns except for the first 3:   Method 1 - Hide Columns with No Data Using the Format ...

How to Show Only One Page in Excel Page Layout View (4 Ways)

To demonstrate how to display the page layout view on one page in Excel, we'll use the following large dataset that includes the order date, customer ...

How to Insert Page Break Between Rows 39 and 40 in Excel

Sometimes, we want to manage our data in a customized way and print them on different pages. For this reason, we insert page breaks between different ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo