Category: Application

Posted on

Excel Training – Copying Worksheets

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).

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.

 

Posted on

How to apply sparklines in Excel 2010

Sparklines are small charts that fit into a cell in your Excel workbooks.  They act as a great visual summary of trends that use a small amount of space and allow you to make quick and effective comparisons in the blink of an eye.

sparkline image excel vba training london
Sparklines are quick visual representations of your data

Features

  • Sparklines will actively update as you add new data.
  • Sparklines are printed when you print a worksheet that contains them.
  • There are three types of Sparklines: Line, Column, and Win/Loss.
  • You can use sparklines to show trends in a series of values, identify minimum and maximum values, business cycles, customer demand over a quarter…and so much more.
  • They are located in the Insert tab
  • You can customise them using the Design tab
  • You can copy the format into other cells using the autofill handle
sparklines excel vba training london
Three styles of sparklines to chose from…


How to add a sparkline

  1. Select the cell or multiple cells where you want to create your Sparkline.

    selecting sparkline range excel vba training london
    Select your range and Excel will prompt your next action.
  2. Go to the Insert tab, and in the Sparklines group, click the type of sparkline that you want to use. Remember, there are three styles to choose from: Line, Column, or Win/Loss.
  3. Excel will give you a prompt for you to enter a Data Range you are using to create the Sparklines.
  4. Enter your data range, or click and drag to choose your data range. Then add the cell details where you want the sparkline to appear.
  5. Click OK .
  6. Excel will then show you the Sparklines in your selected cells.
  7. If you want to copy this sparkline format to other cells, use the  autofill handle.
  8. Ta da!

    sparkline applied excel vba training london
    Sparklines applied!

Sparklines are very simple to apply and can give you a quick snapshot of data – this can be great if you are asked for a quick update on trends in a meeting.  You can get more out of Excel including advanced techniques from Microsoftnet Excel VBA training https://www.stl-training.co.uk/vba-training-london.php