How to Preview a Worksheet before Printing in MS Excel

by

Unlike MS Word, an MS Excel printout seldom looks the same as it is on the screen in front of you. 

For one, you may have a large dataset, and need to know whether everything will fit onto one page, or not, and if so, where the print margins are.

Print Preview helps you understand the layout of your printout, by providing a visual presentation of how your printed copy will look like.

Using this feature, you can customize your printout as per your requirements. You may need to scale the data, shrink the width, or hide a particular row or column to get the desired results.

2 Methods to preview a worksheet before printing in Microsoft Excel:

  • Use the Print Preview option
  • Use the Page Break Preview option

Let us begin.

Read more

How to Print the Title Row on Every Page in MS Excel

by

If you have a spreadsheet with a large number of rows, it might extend to the next page when you print it. You would’ve noticed that the header row or title gets printed only on the first page.

This is the default behavior in excel.

It is also possible to print the title row on every page while printing your worksheet. IN this tutorial will share the exact steps to achieve the same.

Easy Method for printing the title row on every page in Microsoft Excel:

Read more

How to Print Gridlines in MS Excel

by

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

by

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

by

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

by

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 Fix ‘You can’t make this change because the selection is locked’ Error in MS Word

by

You are trying to edit a document, but you cannot start editing. MS Word displays an error message “you can’t make this change because the selection is locked.”

There may be many reasons for the above message. Fortunately, it is quite easy to get rid of the problem so you can start editing the document.

We will show you six reasons why the message is displayed, and how to fix each:

  • Activate your Office Suite
  • Edit document from Print Layout
  • Disable Mark as Final
  • Disable Restrict Editing
  • Modify properties of the document
  • Create a New Document

We will use simple, step-by-step instructions.

Let’s start.

Read more

How to Create Venn Diagram in MS PowerPoint

by

Venn diagrams are useful when you want to show logical relationships between sets using a graphic. In PowerPoint it is very easy to create these kinds of diagrams.

2 Methods for creating a Venn diagram in Microsoft PowerPoint:

  • Using Basic Shapes
  • Using SmartArt

We will show you both methods in simple, step-by-step instructions.

Let us begin.

Read more

How to Print MS Word Document

by

Even in our digital age, we still need printouts of our electronic documents.

Microsoft Word has many parameters which you can change to ensure you obtain the optimum printed document.

In this article, we will share the three quick methods of printing a document, and then list the many parameters available to customize your printout.

3 Methods to print a Microsoft Word document:

  • Use the menu structure
  • Use a keyboard shortcut
  • Use the Quick Access Toolbar

Let us begin.

Read more

How to Type in Small Caps in MS Word

by

To emphasize text in a document, one might use capital letters, however this is often interpreted as equivalent to shouting. A better alternative is to use small caps when you want to emphasize text.

The difference between regular and small caps is their size. Small caps are of the same height as lowercase letters. Regular caps are larger. 

3 Ways to apply small caps in Microsoft Word:

  • Change existing text to small caps using the Fonts menu.
  • Change existing text to small caps using keyboard shortcuts.
  • Type continuously in small caps. 

We will show you the above in simple, step-by-step instructions.

Let us begin.

Read more