You can then select the rows you want from the spreadsheet you have open. The Page Setup dialog box will shrink down to just one line. For example, if you want the first 4 rows to repeat, type $1:$4.Ĭlick the selection box at the end of the box. A,B,C 1,2,3).Īt this point you will choose which rows should repeat at the top. It will print the Excel column and row references (i.e. This does something different to what this lesson covers. Note there is also an option here to print Row and column headings. If you want to print one or more columns to the left side of your print out, you could also follow the instructions below to print one or more columns to the left of each page.
Print chart on excel 2011 for mac Pc#
If you're used to using the PC version of Excel, this will look familiar but different:Ĭlick in the box next to Rows to repeat at top. The Page Setup dialog box will be displayed. In the Page Setup section, click the Repeat Titles button: The ribbon will change to the Page Layout ribbon bar:
Print chart on excel 2011 for mac how to#
You will also learn how to print header columns on the left of every page in your printout.Ĭlick here if you want to print header rows in Excel 2010 for Windows. This lesson shows you how to get header rows printing at the top of every page in Microsoft Excel 2011 for Mac.
There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page.
column headings) on each page in the print out. When printing in Excel, it is sometimes useful to print a set of rows (e.g.
0 kommentar(er)
