Advanced Excel Archives - Page 35 of 62

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

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

How to Open XML File in Excel for Income Tax (2 Easy Ways)

Nov 11, 2025

XML or "Extensible Markup Language" is a file format, which is mainly used for storing and transferring data. Microsoft Excel supports this file ...

How to Open XML File in Excel for Income Tax (2 Easy Ways)

How to Add Paper Size in Excel (4 Easy Ways)

Jun 25, 2024

We'll use the following dataset which contains a Sales Overview. Method 1 - Using the Page Layout Tab to Add a Paper Size in Excel Steps: ...

How to Add Paper Size in Excel (4 Easy Ways)

How to Reduce Excel File Size with Pictures (2 Easy Ways)

May 27, 2024

To reduce file size and improve performance, it's always recommended to compress images in Excel files. Here are 2 methods to do so. Method 1 ...

How to Reduce Excel File Size with Pictures (2 Easy Ways)

How to Show Full Screen with No Title Bar in Excel (3 Easy Ways)

Nov 11, 2025

While working with a large dataset, you need to show the Excel in full screen with no title bar. In Microsoft Excel, you can do this quite easily and ...