Excel Basics Archives - Page 71 of 176

[Fixed!] Excel File Opens Blank Grey Screen (7 Working Solutions)

Jun 18, 2024

To illustrate our Solutions to the problem of Excel files opening with the screen greyed out, we'll use the following dataset. Suppose the ...

[Fixed!] Excel File Opens Blank Grey Screen (7 Working Solutions)

How to Show Menu Bar in Excel (2 Common Cases)

Aug 4, 2024

Case 1 - Showing the Menu Bar in Excel Displaying the Collapsed Ribbon In case the Excel Ribbon is collapsed, we can display it on the window ...

How to Show Menu Bar in Excel (2 Common Cases)

How to Change Worksheet Tab Color in Excel (3 Handy Ways)

Nov 11, 2025

In many cases, we may need to add or change the worksheet tab color in Excel. This helps you identify any worksheet very easily. Also, adding or ...

How to Change Worksheet Tab Color in Excel (3 Handy Ways)

Column Letter to Number Converter in Excel (5 Easy Examples)

Aug 2, 2024

Example 1 - Using COLUMN Function In the given sample dataset, we will use the COLUMN function for two conditions. The first condition is for ...

Column Letter to Number Converter in Excel (5 Easy Examples)

How to Add Watermark in Excel (2 Easy Ways)

Aug 2, 2024

We've used an Excel workbook with multiple worksheets that contain the same dataset. The dataset contains the Categories, Countries, Quantities, and ...

How to Add Watermark in Excel (2 Easy Ways)

How to Make Excel Look Like an Application – 4 Steps

Jul 6, 2024

Step 1 - Creating a Dataset in Different Sheets Open a new Excel File. Add two sheets: Sheet1 and Sheet2. Enter data ...

How to Make Excel Look Like an Application – 4 Steps

How to Delete Blank Pages in the Print Preview in Excel – 4 Methods

Aug 14, 2024

Method 1 - Set the Print Area in the Page Layout Tab Steps: Select the area to print. Click the Page Layout tab. Select Set Print Area. ...

How to Delete Blank Pages in the Print Preview in Excel – 4 Methods

How to Add Single Quotes in Excel for Numbers (3 Easy Methods)

Nov 11, 2025

This article illustrates how to add single quotes in Excel for numbers. You may need to wrap some numbers in your dataset in single quotes. This ...

How to Add Single Quotes in Excel for Numbers (3 Easy Methods)

How to Add Barcode Font in Excel (Installation and Application)

Jun 23, 2024

What Are Excel Barcode Fonts? Generally, barcodes look like black bars and white spaces and store machine-readable information. Different ...

How to Add Barcode Font in Excel (Installation and Application)

How to Repeat Column Headings on Each Page in Excel – 3 Methods

Aug 7, 2024

This is a large dataset showcasing months and the corresponding sales amount in different countries. There is no column heading in the print ...

How to Repeat Column Headings on Each Page in Excel – 3 Methods

How to Align Checkboxes in Excel (2 Easy Ways)

Jun 18, 2024

A checkbox is an interactive tool in Excel that lets you select or deselect an option. Checkboxes can be used to make dynamic charts, dashboards, and ...

How to Align Checkboxes in Excel (2 Easy Ways)

How to Save Excel Chart as High Resolution Image (6 Easy Ways)

Jun 13, 2024

In this article, we will demonstrate 6 easy ways to save an Excel chart as a high resolution image. To illustrate the methods, we will use the ...

How to Save Excel Chart as High Resolution Image (6 Easy Ways)

How to Convert Percentage to Whole Number in Excel (4 Methods)

Jul 17, 2024

This article will demonstrate how to convert a percentage to a whole number in Excel. About Percentage and Whole Numbers Percentage refers to ...

How to Convert Percentage to Whole Number in Excel (4 Methods)

How to Remove Column1 and Column2 in Excel (4 Easy Methods)

Jul 15, 2024

We’ll use a sample dataset as an example in Excel. We have Column1 (Names) in Column B, Column2 (Working Hours) in Column C, and Column3 (Daily Pay) ...

How to Remove Column1 and Column2 in Excel (4 Easy Methods)

How to Create Trend Charts in Excel (4 Methods)

Jul 10, 2024

Overview of Trend Charts in Excel A trend chart illustrates the overall pattern of data over time. The trendline ...