Talents Tips: How to split the worksheet in Windows Excel 2013

Although zooming on the worksheet can help with an overall view of your data in Excel 2013, it can’t split the worksheet into two separate windows so that you can compare their data on the screen. So to split the Worksheet area into separate panes and then scroll the worksheet in each pane so that they display the parts you want to inspect.
Splitting the window
To split a worksheet into two (upper and lower) horizontal panes, you simply position the cell pointer at the cell in the worksheet where you want to split the worksheet and then click the Split button on the Ribbon’s View tab or use the short cut Alt +WS.

split-spreadsheets-iimage-1

When the worksheet window is split, Excel displays a split bar (a thin, light grey bar) along the row or column where the window split is actioned.

split-screen-image-2jpg
You can increase or decrease the size of the current window panes by using the mouse to drag the split bar up or down or left or right. You can make the panes in a workbook window disappear by double-clicking anywhere on the split bar (you can also do this by selecting View and Split again or use the short cut key Alt +WS)

Peter is running two Continuing Education courses Beginners Guide to Intermediate Database Use and a Beginners Guide to intermediate level spreedsheet use both starting in November. To book on either of these courses click here https://goo.gl/mnGn4D

Hidden Stories of Medicine

Talks to be held at the LMI in the Lecture Theatre.
114 Mount Pleasant, Liverpool. L3 5SR. 0151 709 9125 Extension 1

Doors open 6.30pm
First talk 7-7.45pm
Second talk 7.55-8.40pm
Refreshments in the Gallery 8.45-9.15pm

These talks are free of charge and open to everyone

Monday 17 October 2016

Helen McKay – 208 Field Hospital (Liverpool). The secret life of Dr James Barry 1795 – 1865

His death lead to a cover-up by the establishment for over 100 years. Born into a family of revolutionaries, he was a passionate and flamboyant doctor who became the Inspector General of Army Medical Services, but he had a secret …

Paul Dufton – Cleanliness is next to Godliness – 19th Century soap advertising with reference to Pears Soap

Wednesday 23 November

Meg Parkes – The Art of Survival: the role of medical illustration in interpreting WWII Far East captivity

Graham Kyle –Mr T W Davies, Surgeon to the Liverpool Coroner in the 1820s
A Doctor with an interesting career, including involvement in a case of body smuggling (for dissection in Edinburgh) and a spell in the Debtors’ section of Lancaster Gaol …

These talks are free to attend.