Learn how to use microsoft excel 2010 software#

Be careful here - if your spreadsheet is more than one page wide when printed, the second page across will print what is at the top of the columns being printed.When you print out the spreadsheet, the rows you selected will be printed at the top of each page, regardless of how many pages you print.

Or, you can click OK and carry on working. The next thing you can do is click the Print Preview button to check that your selection has worked correctly.In the example below, I've also selected column A to print on every page. After opening PowerPoint 2010, the window appears and your screen will look similar to the one shown above.

Learn how to use microsoft excel 2010 software#

The PowerPoint Window You use the PowerPoint window to interact with the software by choosing commands. In this 2. You can do this by clicking on the Start Icon, All Programs > Microsoft Office> Microsoft PowerPoint. This means 'print from row 1 to row 4 inclusive. The course is also good for Excel 2010, 2013 & 2016. Note the way that the rows are recorded: $1:$4.

The last two options are essentially the same, but the last option is slightly quicker.Д®ither way, Excel will record your selection as shown below.

Just select the rows you want from the spreadsheet (assuming you can see it).

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. Note that there are a number of options that we won't be looking at in this lesson because they aren't relevant to what we're trying to achieve.Д¬lick in the box next to Rows to repeat at top.ДЄt this point you will choose which rows should repeat at the top. The Page Setup dialog box will be displayed as shown below.

In the Page Setup section of the Page Layout ribbon menu (see above), click Print Titles. The ribbon will change to the Page Layout ribbon bar.

Start by opening the spreadsheet you want to print.

Choose the rows you want to print on each page This lesson shows you how to get header rows printing at the top of every page.Д¬lick here if you are looking for a lesson on how to print header rows in 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 2010 for Windows, it is sometimes useful to print a set of rows (e.g.