Excel Basics Archives - Page 41 of 124

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

How to Make an Excel Spreadsheet Look Like a Form

How to Insert Page Number in Excel Cell Not in Header

Jun 28, 2024

Method 1 - Inserting Page Number in Excel Cell Step 1: Open VBA Window VBA has its own separate window. You must insert the code in this window, ...

How to Insert Page Number in Excel Cell Not in Header

How to Show Only Working Area in Excel (3 Quick Tricks)

Jul 7, 2024

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample ...

How to Show Only Working Area in Excel (3 Quick Tricks)

How to Use Formula for Page Number in Excel (6 Quick Ways)

May 28, 2024

Consider the dataset shown in cells B4:E26 below. The dataset is divided into two parts - the PC Shipment Tracker (which shows the Product names, the ...

How to Use Formula for Page Number in Excel (6 Quick Ways)

How to Make a Title Page in Excel (An Ultimate Guide)

Jun 16, 2024

Steps: Insert a header and footer in your Excel sheet. Go to the Insert Menu > Text > Header & Footer. Your sheet should look ...

How to Make a Title Page in Excel (An Ultimate Guide)

How to Hide Multiple Columns in Excel: 5 Easy Methods

Jul 6, 2024

Method 1 - Using Keyboard Shortcuts to Hide Multiple Columns in Excel Steps: Select columns D and E that contain marks in Physics and ...

How to Hide Multiple Columns in Excel: 5 Easy Methods

How to Remove Bullets and Numbering in Excel – 3 Methods

Aug 2, 2024

Method 1 - Using the Find and Replace Feature to Remove Bullets Select all the cells with bullets. Press CTRL + H to open the Find and ...

How to Remove Bullets and Numbering in Excel – 3 Methods

How to Change the Background in an Excel Sheet (4 Ways)

May 14, 2024

Method 1 – Using the Page Layout Tool Steps: Go to the desired sheet. Click on the Page Layout tab. Choose Background from the Page ...

How to Change the Background in an Excel Sheet (4 Ways)

Save Excel Table as Image with High Resolution (with Easy Steps)

Jun 23, 2024

Step 1 - Create an Excel Table Create a table in excel using the CTRL+T shortcut. Step 2 - Copy the Table as Picture Select the ...

Save Excel Table as Image with High Resolution (with Easy Steps)

How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

Apr 20, 2024

Here, we have a dataset containing the First Name, Last Name, and Age of some people. Now, we will show you how to add double quotes in Excel ...

How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

How to Insert a Page Break in Excel (4 Easy Ways)

Jul 29, 2024

In this article, we will demonstrate 4 effective ways to insert page breaks in Excel. We'll use the sample dataset below to explain our methods. ...