How to Fix “Excel Not Printing Gridlines”?

excel not printing gridlines

Excel spreadsheet gridlines cannot be printed is an irritating problem reported by various users on the forum sites.

The problem is commonly reported by the Excel 2010 version users, however, this is not limited to this version only the other Excel version users like Excel 2013 and 2016 also reported their Excel Not Printing Gridlines.

Read more

6 Effective Reasons Why Use a VPN at Work

Defending oneself from cyber threats doesn’t have to halt at the private gadget. Making use of VPN while working has its own advantages. Whether you wish to hide browsing data from the establishment, or you wish to open services and webpages that are the local firewall has restricted, or whether the primary concern is to continue safety when operating the system from a café or home, a VPN will help achieve all of this you can read more about VPN here. Truthfully, there are several explanations to make use of VPN while working.

Read more

How To Use Excel ISERROR Function? [ 3 Easy Examples]

How To Use Excel ISERROR Function? [ 3 Easy Examples]

The Excel ISERROR function is part of the Information functions category. If the supplied value represents an error, the function will return TRUE; otherwise, it will return FALSE. #NAME?, #NUM!, #N/A,  #REF!, #VALUE!, #DIV/0!, or #NULL are all valid errors.

Read more

How To Use Maxifs In Excel?

How To Use Maxifs In Excel

Searching for some easy alternatives to evaluate maximum value from the data under the conditions in Excel?

Stop searching for it, as by using the Excel MAXIFS function you can easily perform this task.

Now the question arises, how to use MAXIFS in Excel …?

Read more

5 Hacks To Extract Images From Excel

5 Hacks To Extract Images From Excel

Today in this tutorial we will discuss different tricks to extract images from Excel. Now you all must be thinking that what’s new in this to learn because it’s so easy to copy an image from the source then paste it into the paint application and save it.

But just think for a while what if you need to extract multiple images from Excel file?

Read more

5 Tricks To Lock Cells In Excel

How To Lock Cells In Excel

Wants to prevent users from changing the data, formatting or formula contained within the cells of an Excel worksheet?

In my previous blog I have already shared some quick tricks to protect Excel workbook from editing. But if you want to restrict user from making changes into any particular cells then those fixes won’t be applicable.

Read more

4 Ways To Create Drop-Down List In Excel

4 Ways To Create Drop-Down List In Excel

Summary:

This blog summarizes the complete detail on how to create drop list in Excel using different tricks. Also learn how to add/remove item from the drop down list or steps to delete the drop-down list.

Read more

How To Create Flowchart In Excel?

How To Create Flowchart In Excel

Does your Excel worksheet densely packed with useful data but you are facing difficulty to interpret it?  Why don’t you use flowcharts to illustrate relationships between all your data points and for giving more clarity to your Excel spreadsheet.

If you don’t know how it is to be done then also you need not to get tensed as this guide will gives you the complete overview on how to create flowchart in Excel.

Before that, let’s grab some basic knowledge about Excel Flowcharts.

Read more

How To Make Excel Table Automatically Expand?

How To Make Excel Table Automatically Expand

When any new data enter in the worksheet then the Excel table automatically expand by default. But sometime the situation may arise where Excel table doesn’t expand for new data. Do you know how you can fix this issue?

If not then don’t go anywhere as our today’s topic is specifically about how to make Excel table automatically expand. Besides this we will discuss how to deal with the problematic situations where Excel table doesn’t expand for new data.

Read more

3 Ways To Create Calendar In Excel

3 Ways To Create Calendar In Excel

Summary:

The tutorial explain you how to create calendar in Excel with complete steps. Apart from this, you will also get to learn about tricks to create calendar from Excel spreadsheet data.

So without wasting any more time, let’s dive into this post….!

Read more