how to create repeating rows in excel 2011 for mac

Create Repeating Rows In Excel 2011 Full Advantage Of
Create Repeating Rows In Excel 2011 How To Take Advantage

One function that people rarely use is the Repeat function or REPT.

In this video, an example used is a chart of people and their sales of a certain item.

Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better.

Next to one of the cells, type in REPT( which is the repeat function.

For numbertimes, type in the cell number you are typing next to.

Click enter. The or whatever you typed in will be repeated the number of times that is in the cell number you entered in numbertimes.

All of the sales (or whatever numbers you are comparing) will be represented in a bar chart-like format.

This function can be very helpful when comparing different sets of data.

Printing from Microsoft Excel may seem like an obvious operation, with no need of further explanationjust press Command-P, Return, and head to the printer to pick up your document.

Create Repeating Rows In Excel 2011 Full Advantage Of

The reality, though, is that Excels print function is quite powerful, but you have to do a bit of digging to take full advantage of its capabilities.

Here are just a few of the options open to you when you print with Excel.

Much of the Excel print dialog (File - Print) looks familiar; it offers standard OS X print features such as Presets, PDF options, Preview, and Supplies.

Create Repeating Rows In Excel 2011 How To Take Advantage

There are some Excel-specific features, though, and heres how to take advantage of them.

You can print a Selection (which will typically be one cell, unless you intentionally selected a range before opening the Print dialog), Active Sheets, or Entire Workbook.

If you created a print range, choosing Active Sheets will show just that print range in the preview area.

What I often do, though, is scale just one dimension, by entering a really large number of pages in the other dimension.

For example, you can make sure your output is scaled to fit just the width of your paper by setting the page(s) wide box to 1, and the page(s) tall box to 999.

Click Page Setup in the Print dialog, then go to the Sheet tab.

Click in the Rows or Columns boxes in the Print Titles section, then click on the worksheet to select a row or column (hold Shift and click for multiple rows or columns).

I usually make sure the full path and file are included somewhere, just so I can be sure the version Ive printed matches the one Im looking at onscreen.

Go ahead and experiment to see what works best for your needs.

We give you the scoop on whats new, whats best and how to make the most out of the products you love.

How To Create Repeating Rows In Excel 2011 For Mac