STL – Blog

If you need to make a copy of a worksheet, rather than copying and pasting you could…

1. Right click on the worksheet tab
2. Select Move or Copy from the list and a dialogue box will appear.
3. Select where you want the sheet to be positioned
4. Click in the check box beside Create a copy
5. Click OK

 

If you are printing a worksheet that will be more than one page, you may have a little difficulty understanding data on certain pages because the column and/or row headings are not visible.

Should you wish to see the column / row headings on every printed out page…

1. On the Page Layout ribbon, in the Page Setup group, select Print Titles.
2. Click on the Sheet tab and then in the space next to Rows to repeat at top. On the actual worksheet select the rows (highlight the row numbers) you want to appear on each hard copy. (Fig 1. below has rows 1, 2 & 3 selected).
3. Click in the space next to Columns to repeat at left and again, on the worksheet itself, select the columns(highlight the column letters) you want to appear on each hard copy. (Fig 1. below has columnA selected).

 

Figure 1. Rows 1, 2 & 3 and column A, will be printed on each sheet.

Now when you print, it will be much easier to work with and understand the data on all pages of your printout.