Excel Basics Archives - Page 68 of 176

[Solved]: Page Break in Excel Not Working Error

Aug 4, 2024

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

[Solved]: Page Break in Excel Not Working Error

How to Hide Confidential Data in Excel – 5 Methods

Aug 2, 2024

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

How to Hide Confidential Data in Excel – 5 Methods

How to Print Gridlines with Fill Color in Excel (4 Useful Ways)

Nov 11, 2025

Gridlines are a classical feature of spreadsheets. In Excel, gridlines help the user to distinguish between cells and navigate within the rows and ...

How to Print Gridlines with Fill Color in Excel (4 Useful Ways)

How to Print Titles in Excel Except for Last Page (2 Easy Macros)

Nov 11, 2025

Printing titles on every page in Excel is much easier as there is a built-in command in Excel to do that. But if we want to print titles on every ...

How to Print Titles in Excel Except for Last Page (2 Easy Macros)

Excel Gridlines are Not Showing by Default – 3 Solutions

Aug 12, 2024

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

Excel Gridlines are Not Showing by Default – 3 Solutions

How to Make Excel Open Faster (16 Possible Ways)

Jul 29, 2024

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 Excel Open Faster (16 Possible Ways)

How to Hide Selected Columns in Excel (5 Useful Examples)

Nov 11, 2025

Excel is the most widely used tool for dealing with massive datasets. When we work in a group and share any Excel files, we often need to hide and ...

How to Hide Selected Columns in Excel (5 Useful Examples)

How to make Gridlines visible in Excel – 5 Solutions

Aug 15, 2024

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 make Gridlines visible in Excel – 5 Solutions

How to Start Page Numbers at Different Number in Excel

Jul 12, 2024

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

How to Start Page Numbers at Different Number in Excel

Excel Hide Columns Based on Cell Value without Macro

Nov 11, 2025

Looking for ways to know how Excel hides columns based on cell value without a macro? Sometimes, we want to hide columns based on cell value. We can ...

Excel Hide Columns Based on Cell Value without Macro

How to Convert Numbers to Words in Excel Without VBA

Apr 30, 2024

This guide will use the following dataset: Step 1: Build a Formula to Convert From Numbers to Words The following formula is huge but it ...

How to Convert Numbers to Words in Excel Without VBA

How to Add Primary Major Vertical Gridlines in Excel (2 Ways)

Aug 4, 2024

What Are Major Gridlines? Major gridlines divide the chart axis into major units. Major gridlines are vertical or horizontal lines that represent ...

How to Add Primary Major Vertical Gridlines in Excel (2 Ways)

How to Hide Blank Cells in Excel (5 Easy Methods)

May 13, 2024

We will use a dataset containing information about some sellers' sales amounts. The dataset has some blank cells. As we can’t hide the blank cells ...

How to Hide Blank Cells in Excel (5 Easy Methods)

How to Unhide Columns in Excel All at Once (4 Quick Ways)

Jun 14, 2024

Take a look below for an example of a dataset where a number of columns are hidden. If you want to unhide columns simultaneously, you can use three ...

How to Unhide Columns in Excel All at Once (4 Quick Ways)

How to Make an Excel Spreadsheet Look Like a Form

Jun 10, 2024

Step 1 - Enable Form by Customizing Quick Access Toolbar First we need to customize the quick access toolbar so that the Form tab will appear in it. ...