How to Print Gridlines in MS Excel

Gridlines are not printed on a Microsoft Excel worksheet or workbook by default. But you might want to print them to improve the readability of the data. In this tutorial, we’ll show you how you can achieve this in a few easy steps.

2 Methods for printing gridlines in Microsoft Excel:

  • Use the Page Layout menu
  • Use the keyboard shortcut

Let us begin.


Read more

How to Show and Hide Gridlines in MS Excel

The faint lines that appear between cells on a worksheet are known as gridlines. 

Depending on your type of work, gridlines can be both useful and bothersome. They are important in separating cells when working with a lot of data. Meanwhile, if you have a specific format for your document, you might want to remove them.

3 Methods to show and hide gridlines in Microsoft Excel:

  • Use the View menu
  • Use the keyboard shortcut
  • Change the background color

Let us begin.

Read more

How to Set the Print Area in MS Excel

If you don’t want to print your entire Excel sheet, you can select a specific range of cells to be printed. You can also select multiple ranges of cells. Each range can be printed on a separate page. You can keep adding to your existing print area, and you can also clear out all the print areas. 

If you want a preview, you can view all the print areas before actually printing them out. Printing pre-selected areas in Excel is not just a great feature, but also an easy one that you can do in seconds.

3 Methods to set the print area in Microsoft Excel:

  • Use Set Print Area
  • Use Add Print Area
  • Use the Page Setup dialog box

Let us begin.


Read more

How to Print an Entire Workbook in MS Excel

Even in this digitized world, we need printouts. We need hard copies of books, reports, financial statements, and more. A workbook printout can aid in many ways, including the following:

  • You will not be at the mercy of the internet connectivity to use the workbook.
  • You do not need your laptop or phone to view the workbook.
  • Once the data is ready, a workbook printout is more portable and workable to use.
  • Most people prefer using a printout rather than viewing the data online.

2 Methods to print an entire workbook in Microsoft Excel:

  • Use the Print Entire Workbook option
  • Use the Print Active Sheets option

Let us begin.

Read more

How to Change the Date Format in MS Excel

Any inconsistencies in date formats can be confusing. It could even lead to a wrong understanding of data. So, knowing how to change the date format in MS Excel can be incredibly useful. Below are a couple of methods through which you can change the date format in MS Excel.

2 Methods to change the date format in Microsoft Excel:

  • Use the Home tab
  • Use the Format Cells option
  • Use the Right-Click menu

Let us begin.

Read more

How to Strikethrough Text in MS Excel

Strikethrough refers to a horizontal line running through text without affecting its readability.

Here’s how it looks:

Hi! I am learning MS Excel.

It is a basic copy-editing symbol used to indicate the deletion of an error or removal of certain text in a work.

In this article, we will share 4 methods to cross out text in MS Excel.

4 Methods to strikethrough text in MS Excel:

  • Use a keyboard shortcut
  • Use the home tab
  • Use the Quick Access Toolbar
  • Use Conditional Formatting 

Let us begin.

Read more

How to Remove Strikethrough in MS Excel

When you have certain text formatted as strikethrough in your spreadsheet, you might want to remove it at a later point in time. Fortunately, there are several quick and easy methods in MS Excel to remove the strikethrough.

4 Methods to remove strikethrough in MS Excel:

  • Use a keyboard shortcut
  • Use the Home tab
  • Use the right-click menu
  • Remove conditional strikethrough in MS Excel using the Clear Rules option

Let us begin.

Read more

How to Find and Replace Text and Numbers in MS Excel

This article highlights different ways to find and replace text and numbers in MS Excel. It is an important function for correcting errors or making quick changes. This exercise can be time-consuming if you don’t have the right skill set. With proper skills, you can do it in minutes.

3 Methods for finding and replacing text or numbers in Microsoft Excel:

  • Use a keyboard shortcut
  • Use the Find & Select feature
  • Use the SUBSTITUTE formula

Read more

How to Calculate the Number of Days Between Two Dates in MS Excel

Want to know how many more days until your birthday? Or the age difference between you and a friend? 

Or on a more serious note, if you need to know the number of days between two project milestones, there is an easy way to calculate this in MS Excel. 

The good news is that there are several ways to calculate the number of days between two dates in MS Excel.

4 Methods to calculate the number of days between two dates in MS Excel:

  • Subtract the dates
  • Use the DATEDIF function
  • Use the DAYS function
  • Calculate the number of working days using the NETWORKDAYS function

Read more

How to Ungroup Worksheets in Excel

When you want to perform the same task on multiple worksheets in a workbook, you might have grouped them. Ungrouping is as easy as grouping them. If you’re struggling to ungroup the worksheets, you’re at the right place. 

3 Methods of ungrouping worksheets in Excel:

  • Click on any unselected sheet
  • Keyboard keys and click on the grouped worksheets
  • Select Ungroup Sheets

Let us begin.

Read more