Latest Blog Posts

How Do I Stop Excel from Opening in Full Screen (4 Easy 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 Do I Stop 255 Character Limit in Excel (4 Ways)

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 to Add Gridlines to a Graph in Excel (2 Ways)

You may have created graph in Excel on the basis of some gathered dataset, changed the axis label of the graph, or edited the legends of it. But ...

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

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

Difference Between Accounting and Currency Format in Excel

The article will show you the difference between Accounting and Currency format in Excel. These two number formats seem similar to each other, ...

How to Remove Data Bars in Excel (3 Simple Ways)

While working in Microsoft Excel we need to highlight cells or highlight data inside a chart. Sometimes, we use data bar rules of conditional ...

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 Insert a Subtitle in Excel – 2 Methods

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

How to Hide Unused Cells in Excel (3 Quick Ways)

Excel has a large built-in spreadsheet to input data. However, most of the time, many of the cells remain unused. To prevent the entry of any scatter ...

How to Add Gridlines in Excel After Highlighting (3 Easy Methods)

Excel worksheets and workbooks display gridlines by default. But, the gridlines disappear as soon as we highlight the cells. And many times, this is ...

How to Hide Extra Cells in Excel (with Quick Steps)

If you are searching for a solution or some special tricks to hide extra cells in Excel then you have landed in the right place. Often you want to ...

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

Method 1 - Removing Irrelevant Worksheets/Data Steps: We arranged our desired Excel file. Check how many worksheets it contains and ...

How to Check Character Limit in Excel (With Easy Steps)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, ...

How to Change Gridlines in Excel (4 Suitable Ways)

An Excel gridline is the faint gray edge around each cell in the worksheet. In addition to making it easier to read the data, these gridlines help ...

How to Hide Chart Data in Excel – 6 Steps

The sample dataset contains information on sales amounts in three months. To hide the sales amount for February:   STEP 1 - Plotting a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo