Managing Worksheets and Printing in Excel

When working in Microsoft Excel, you will often need to organize data across multiple worksheets and control how your spreadsheet prints. This tutorial explains how worksheet tabs work inside a workbook, how to rename or copy worksheets, and how to prepare Excel worksheets for printing using page setup, page breaks and print areas.

Workbooks, Worksheets and Spreadsheets

In Excel, the overall file is called a workbook. Inside the workbook are individual worksheets, which are the tabs where data is entered and organized. Although the terms are sometimes used interchangeably, a spreadsheet usually refers more generally to data arranged in rows and columns.

A new workbook always starts with at least one worksheet, but Excel allows you to add many more as needed.

Moving and Copying Worksheet Tabs

Worksheets can be rearranged by clicking and dragging the worksheet tab to a new position. This allows you to organize the order of worksheets in a way that makes sense for your project.

To copy a worksheet, hold the Ctrl key while dragging the tab to a new location. Excel will create a duplicate worksheet with the same contents.

You can also right-click a worksheet tab and choose Move or Copy to control where the worksheet appears.

Using Tab Colors to Organize Worksheets

Excel allows you to assign colors to worksheet tabs. This can make large workbooks easier to navigate by visually grouping related worksheets.

To change the color of a worksheet tab, right-click the tab and choose Tab Color, then select a color from the palette.

Deleting Worksheets

If a worksheet is no longer needed, it can be removed from the workbook. Right-click the worksheet tab and choose Delete, or use the Delete Sheet command from the Format menu on the Home tab.

Deleting a worksheet permanently removes its contents, so Excel will usually ask you to confirm before completing the action.

Page Setup and Page Orientation

Excel provides several tools for controlling how worksheets print. On the Page Layout tab, you can change the orientation of the printed page.

Portrait orientation prints vertically, while Landscape orientation rotates the page to provide more horizontal space. This is often useful when printing wide tables or worksheets with many columns.

Inserting Page Breaks in Excel

Page breaks control where Excel begins a new printed page.

If you select a row and insert a page break, the new page will begin above that row. If you select a column, the page break will appear to the left of that column.

The Page Break Preview view can make it easier to see how your worksheet will be divided across printed pages.

Setting the Print Area

Large worksheets often contain more information than you want to print at once. Excel allows you to define a print area, which limits printing to a selected group of cells.

To set a print area:

Select the cells you want to print
Go to the Page Layout tab
Choose Print Area → Set Print Area

You can also clear the print area later if you want to print the entire worksheet again.

Printing Gridlines and Headings

Excel worksheets normally display gridlines on the screen, but these lines do not always appear when printing. If you want gridlines or row and column headings to print, you can enable them in the Sheet Options group on the Page Layout tab.

These options can make printed worksheets easier to read.