Printing Non-Contiguous Ranges in MS-Excel

When working with spreadsheets in MS-Excel, you might need to print specific parts of your data that are not next to each other. These are called non-contiguous ranges. Printing non-contiguous ranges requires selecting all the desired areas before sending the document to the printer. Let's break down the steps involved.

Understanding Non-Contiguous Ranges

A contiguous range is a block of cells that are all connected, like A1:C10. A non-contiguous range consists of two or more separate blocks of cells, like A1:C10 and F5:G15, or even single cells that are not adjacent.

Steps to Print Non-Contiguous Ranges in MS-Excel

The correct sequence of steps to print non-contiguous ranges involves selecting the areas first, then accessing the print menu, and finally specifying that only the selected areas should be printed. Here are the steps:

1. Select the first range to be printed (Step B): Begin by selecting the first block of cells you want to include in your printout. You can do this by clicking and dragging your mouse over the desired cells.
2. Press [ctrl] + select second range to be printed and more, if required (Step D): This is the crucial step for selecting non-contiguous areas. After selecting the first range, hold down the Ctrl key on your keyboard. While holding Ctrl, click and drag your mouse over the second range you want to print. Continue holding Ctrl and selecting any additional non-contiguous ranges or single cells needed for your printout.
3. Click the office Button and select print (Step A): Once all the desired ranges are selected, release the Ctrl key. Navigate to the print options. In older versions of Excel (like Excel 2007), this is typically done by clicking the round Office Button at the top left corner and then choosing 'Print'. In newer versions (Excel 2010 and later), you'll click the 'File' tab and then 'Print'.
4. In print what section, select selection (Step C): This is another critical step. In the Print settings dialog box or the Print preview pane, you will find a section often labeled 'Settings' or 'Print What'. Here, you must explicitly choose the option to print 'Selection' (or 'Print Selection'). This tells Excel to only print the specific ranges you highlighted, ignoring the rest of the worksheet data.
5. Click print (Step E): After confirming that 'Selection' is chosen under the print settings, click the 'Print' button to send the selected non-contiguous ranges to your printer.

Following this sequence ensures that only the specific parts of your spreadsheet you intended are included in the print job, saving paper and focusing the output on the relevant data.

Analyzing the Steps for Printing Non-Contiguous Data

Let's look at why the sequence B-D-A-C-E is the correct approach:

• Selecting ranges (B and D) must happen *before* you go to print (A). You need to tell Excel *what* you want to print first.
• Using the Ctrl key (D) is necessary to select multiple, separate areas. Without it, selecting a new range would deselect the previous one.
• Going to the print menu (A) is the next logical step after selecting.
• Specifying 'Selection' (C) is vital *within* the print options (accessed via A). If you don't choose 'Selection', Excel might print the entire active sheet or the whole workbook, depending on its default settings and what you have defined as a print area.
• Clicking print (E) is the final action to initiate the job, which happens after all selections and settings (B, D, A, C) are confirmed.

Revision Table: Excel Printing Steps

Reviewing the steps helps reinforce the process for printing specific, non-adjacent data in MS-Excel:

• Start by highlighting the first section you want to print.
• Hold down the Ctrl key while you select any other sections you need. Make sure all desired parts are highlighted.
• Go to the main menu (like 'File' or the 'Office Button') and choose the 'Print' option.
• In the print settings, look for the option to print only the 'Selection'. Choose this option.
• Finally, click the 'Print' button to get your printout.

Additional Information: Excel Printing Options

Besides printing non-contiguous selections, MS-Excel offers other printing options:

• Print Active Sheets: This option prints all the sheets that are currently selected (visible). If you select multiple sheets using Ctrl or Shift before going to Print, they will all be printed.
• Print Entire Workbook: This option prints every single worksheet within the active Excel file.
• Print Table: If your data is formatted as an Excel Table, you might see an option to print just the selected Table.
• Setting Print Area: You can define a specific range (or multiple ranges) as the permanent 'Print Area' for a sheet. Once a print area is set, selecting 'Print Active Sheets' will only print the defined print area(s) on that sheet, even if you haven't actively selected them just before printing. This setting is sticky until cleared.

Choosing 'Selection' is temporary and applies only to the ranges you have currently highlighted when you go to print. This is why it's ideal for one-off print jobs of non-contiguous data.