Advanced Excel Archives - Page 36 of 63

How to Exit Full Screen in Excel – 3 Methods

Aug 12, 2024

Method 1 - Using the Context Menu to Exit Full Screen Steps: Right-click anywhere in the workbook. Select Close Full Screen. ...

How to Exit Full Screen in Excel – 3 Methods

How to Convert CSV to XML in Excel: 4 Methods

May 31, 2024

Method 1 - Opening CSV File in Excel Open the CSV file in Excel. Note down the heading of each column. This will be required to create the ...

How to Convert CSV to XML in Excel: 4 Methods

How to Add Markers to Sparklines in Excel (with Easy Steps)

Nov 11, 2025

The Sparklines feature in Excel is helpful for those who evaluate and analyze data. One can add markers to sparklines in Excel for better ...

How to Add Markers to Sparklines in Excel (with Easy Steps)

How to Make Journal Entries in Excel – 3 Steps

Aug 12, 2024

STEP 1 - Creating an Initial Balance Sheet Steps: The sample dataset showcases the starting condition of a production business. It includes: ...

How to Make Journal Entries in Excel – 3 Steps

How to Zip an Excel File (3 Easy Ways)

Jul 30, 2024

Method 1 - Using Windows Send Command to Zip an Excel File Store your Excel file in a suitable location on your computer. Select the ...

How to Draw to Scale in Excel (2 Easy Ways)

Jun 18, 2024

We'll draw a simple floor plan to scale. Method 1 - Using Border Options to Draw to Scale in Excel Step 1 - Setting Up Row Height and Column ...

How to Draw to Scale in Excel (2 Easy Ways)

How to Convert Excel to XML File (With Easy Steps)

Jul 12, 2024

Download the Practice Workbook Excel to XML.xlsx XML File.xml Convert an Excel File to XML: 6 Easy Steps We will use the sample ...

How to Convert Excel to XML File (With Easy Steps)

How to Create a Schema in Excel (with Detailed Steps)

Jun 21, 2024

Watch Video – Create a Schema in Excel Overview of XML Schema Format Definition Schema is a type of XML document format. An XML ...

How to Create a Schema in Excel (with Detailed Steps)

How to Color Alternate Row for Merged Cells in Excel

Nov 11, 2025

If you work with large data sets in Microsoft Excel, you may find it helpful to format alternate rows with a different color. This can make it easier ...

How to Color Alternate Row for Merged Cells in Excel

How to Draw Engineering Drawing in Excel (2 Suitable Examples)

Jul 18, 2024

Example 1 - Drawing a Flow Chart in Excel Let’s say we have two variables, a and b. We want to show the sum of these two variables in a flow chart. ...

How to Draw Engineering Drawing in Excel (2 Suitable Examples)

How to Draw a Floor Plan in Excel (2 Easy Methods)

Jun 8, 2024

In this article, we'll demonstrate two quick ways to draw a floor plan in Excel. Here’s an overview of the dataset we'll be using. Floor Plan - ...

How to Draw a Floor Plan in Excel (2 Easy Methods)

[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

Jul 6, 2024

Method 1 - Unprotect Workbook in Excel The track changes option becomes greyed due to various reasons. One of the reasons is that your workbook is ...

[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

How to Create a General Ledger from a General Data Journal in Excel

Aug 4, 2024

What Is a General Journal? The general journal is an accounting record of a company’s financial transactions. It is the master of all company ...

How to Create a General Ledger from a General Data Journal in Excel

How to Convert XML to XLSX Without Opening File

Nov 11, 2025

This tutorial will demonstrate how to convert XML to XLSX without opening the file. XML is a markup language. It is mainly used for giving ...

How to Convert XML to XLSX Without Opening File

Excel VBA: Show Userform in Full Screen (4 Easy Ways)

Jul 6, 2024

In this article, we discuss how to display a Userform in full screen in Excel using VBA in four different ways. We'll use the dataset below to ...