Advanced Excel

How to Print Full Page of Excel Sheet in A4 Size (5 Simple Ways)

Microsoft Excel is an amazing software which importance can’t be explained in words. It is very essential part of almost every institutions. To have ...

How to Alternate Row Color Based on Group in Excel (6 Methods)

When we work on a large datasheet, we need to alternate the row color to visualize our dataset better. We can do the color-altering task as a band or ...

How to Create a Checkbook Ledger in Excel (2 Useful Examples)

Looking for ways to keep track of your transactions in a checkbook ledger? Then you’ve come to the right place. In this article, we’ll show you 2 ...

How to Add Data Markers in Excel (2 Easy Examples)

We can add data markers for visualizing and highlighting key information in our dataset. If you are curious to learn how to add data markers in ...

How to Change Marker Shape in Excel Graph (3 Easy Methods)

Excel automatically creates a shape for the marker while creating a Line, (XY) Scatter, and Radar chart. These data markers help the reader to ...

[Fixed!] Excel Spreadsheet Opening Larger Than Screen

If you are looking for some special tricks to solve the problem of  "Excel spreadsheet opening larger than screen”, you've come to the right place. ...

Excel Mapping Data from Another Sheet (6 Useful Methods)

Working in multiple worksheets is very common among regular excel users. But mapping data between those worksheets are extremely time-consuming work. ...

How Do I Stop Excel from Opening in Full Screen (4 Ways)

By default, Microsoft Excel tends to open the files in full-screen view. By your definition of the full-screen view, it may be necessary in some ...

How to Compress Excel File to Zip (2 Suitable Ways)

Sometimes we need to store a large amount of data in Excel. As a result, the size of the Excel file becomes bigger. If we need to share this file ...

How to Hide VLOOKUP Source Data in Excel (5 Easy Ways)

Often, it is desired to hide the source data in Excel. This will keep the users from accidentally or willingly editing the source data. In this ...

How to Compress Excel File to Smaller Size (7 Easy Methods)

This tutorial will demonstrate the steps to how to compress an excel file to a smaller size. When you are dealing with lots of excel files, then it ...

How to Determine What Is Causing Large Excel File Size

Excel is mainly used for creating datasheets and performing calculations without the help of a calculator. Business organizations can't think to pass ...

How to Hide Confidential Data in Excel (5 Easy Ways)

This article illustrates how to hide confidential data in excel. Excel is not super critical about protecting your data. But, there are a few ways to ...

How to Hide Columns with Button in Excel (4 Suitable Methods)

The article will show you how to hide columns in Excel with a button. Typically, it’s a common thing to hide unnecessary columns while working on the ...

How to Fit to Page in Excel (3 Easy Ways)

A worksheet's content may fill more than one page when printed, in which case the extra columns or rows must be printed on a separate sheet of paper. ...

ExcelDemy
Logo