Excel

Hi Helen

Thanks for your question.

One way to create a range is to highlight a block of cells and from the Insert menu choose Name > Define then enter a name for the block of cells selected.

In addition if you highlight any group of cells Excel will attempt to apply a function to those cells (such as sum) even if that range has no name. To see this in action highlight some cells containing numerical data and look at the right side of the status bar which runs along the bottom of the screen. By default Excel will sum the selected cells for you.

If the status bar is not visible you can switch it on by going to the View menu and making sure the Status item is selected (it should have a tick beside it - it it doesn't simply select it)

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew