Excel Basics

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 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 ...

[Solved]: Page Break in Excel Not Working Error

We have three different data tables, each containing the names, IDs, and joining dates of employees of three different companies. We'll solve the ...

How to Hide Confidential Data in Excel – 5 Methods

The dataset contains employees' information. To hide sensitive information like phone numbers:   Method 1 - Applying Custom Cell ...

Excel Gridlines are Not Showing by Default – 3 Solutions

This is the sample dataset. There is no gridline in the Excel sheet. Solution 1 - Enabling the Show Gridlines Option Steps: Go to ...

How to Make Excel Open Faster (16 Possible Ways)

Excel is capable of processing 6.6 million formulas per second, yet sometimes it can become very slow. In this article, we will discuss some of the ...

How to make Gridlines visible in Excel – 5 Solutions

In the sample dataset gridlines are not visible: Solution 1 - Using the View Tab STEPS: Go to the View tab. In Show, check ...

How to Start Page Numbers at Different Number in Excel

We'll use the following dataset to add page numbers and have them start with a different number. Example 1 - Inserting the Page Number in ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo