Microsoft 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

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

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

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

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

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

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

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

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

If you print a page in Microsoft Word, the content gets centered on the printed page automatically. But that is not the case with Microsoft Excel, as Microsoft Excel, by default, prints from the top-left corner of the page.

Why does Microsoft Excel do this? It is because, like most people, you enter data into the worksheet from cell A1. As a result, Excel replicates that into the printout. However, you can change that printing orientation. This article will discuss three methods of centering worksheets horizontally.

3 Methods of centering your worksheet horizontally in Microsoft Excel:

• Center the worksheet horizontally from the Print menu
• Center the worksheet horizontally using Custom Margins
• Center the worksheet horizontally using the Page Setup launcher tool

Let us begin.

Read more