Excel Basics Archives - Page 39 of 124

How to Create Column Headers in Excel: 3 Methods

Jul 5, 2024

Method 1 - Creating Column Headers by Freezing a Row Steps: Click the View tab. Choose the frame right inside the row and column to ...

How to Create Column Headers in Excel: 3 Methods

How to Change Page Number in Excel (With Easy Steps)

Jul 15, 2024

Download the Practice Workbook Change Page Number.xlsx 2 Easy Steps to Change the Page Number in Excel We have a dataset of some Product ...

How to Change Page Number in Excel (With Easy Steps)

How to Change Column Headings in Excel (2 Ways)

Jun 19, 2024

Here's a sample dataset containing PC parts, prices, and available quantities. We'll change the column headings in the file from letters to numbers. ...

How to Change Column Headings in Excel (2 Ways)

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

Jul 4, 2024

Method 1 - Set Print Area from Page Layout Tab Select the area you want to print> go to the Page Layout tab> click Print Areas> select ...

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

Apr 25, 2024

Without gridlines, Excel sheets look empty. Here, we will discuss 5 solutions to fix missing gridlines in Excel. Fix 1 - Enable Gridlines ...

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

How to Convert Currency to Words in Excel – 2 Easy Methods

Aug 4, 2024

In the following dataset there are several amounts that you want to convert to words. Method 1 - Creating a User-Defined Function Using ...

How to Convert Currency to Words in Excel – 2 Easy Methods

How to Collapse Columns in Excel (6 Easy Ways)

Jul 7, 2024

The collapse columns feature in Excel hides the marked columns from being displayed. We will use the sample dataset below to collapse columns D, E, ...

How to Collapse Columns in Excel (6 Easy Ways)

How to Resize Checkbox in Excel (3 Easy Ways)

Jul 6, 2024

Consider the following Daily Tasks Checklist. The dataset contains Tasks and Status that contains a checkbox. We will resize the Checkbox. ...

How to Resize Checkbox in Excel (3 Easy Ways)

How to Access and Create a Custom List of Currency Symbols in Excel

Jul 25, 2024

Overview of Currency Symbols The following overview image illustrates a list of currency symbols with its corresponding currency code, currency ...

How to Access and Create a Custom List of Currency Symbols in Excel

How to Add More Gridlines in Excel – 2 Methods

Aug 13, 2024

Use the dataset below to insert a Column chart: Select the entire dataset. Go to the Insert tab. In Insert Column or Bar Chart ...

How to Add More Gridlines in Excel – 2 Methods

How to Hide Cells in Excel Until Data Entered (2 Easy Ways)

Jul 31, 2024

In this article, we will discuss how to hide cells in Excel until data is entered. We will use the dataset below, which contains some numeric and ...

How to Hide Cells in Excel Until Data Entered (2 Easy Ways)

Format Currency with 2 Decimal Places in Excel – 4 Methods

Jun 24, 2024

The following image shows an employee dataset consisting of Designation, Years of Service, and Salary. The Salary figures were converted to ...

Format Currency with 2 Decimal Places in Excel – 4 Methods

How Do I Stop 255 Character Limit in Excel (4 Ways)

Jul 3, 2024

Method 1 - Using CONCATENATE Function Steps: If we need to use a formula that involves a character length greater than 255, we will face a ...

How Do I Stop 255 Character Limit in Excel (4 Ways)

How to Hide a Part of Text in Excel Cells (2 Methods)

Jul 12, 2024

Dataset Overview Let's assume we have a dataset of 5 employees’ phone numbers. But we don’t want to show it to everyone. So, we need to hide some ...

How to Hide a Part of Text in Excel Cells (2 Methods)

How to Insert a Subtitle in Excel – 2 Methods

Aug 2, 2024

Method 1 - Using the Merge & Center feature to Insert a Subtitle in an Excel Sheet Select a blank cell on the top of your data table. ...