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

Talents Tips: Keyboard Shortcuts

Keyboard shortcuts by Peter Talent

Save Time

Essential shortcuts can increase your productivity and speed at which you work. Below are some important PC shortcuts.

Delete with assurance
Backspace can be both helpful and troublesome. Deleting a word or two is straight forward, but anything longer may turn a simple deletion into a difficult operation in stopping the curser before it removes a whole paragraph.
Ctrl + backspace allows you to delete an entire word at a time, or a whole sentence quickly.

keyboard-image-1

S.O.S.
From time to time programs crash, and freeze. You can avoid having to shutdown your computer by recovering documents with this three-button combo.

keyboard-image-2
Ctrl+Shift+Escape will open your computer’s Task Manager, allowing you to end theproblem program and continue on.
Learn to Quick-Pick
Alternating between different programs? Don’t let your mouse slow you down. This quick action shortcut allows you to seamlessly work across all of your essential programs without having to use the mouse. keyboard-image-3Holding Alt+Tab brings up the index of currently opened programs, and pressing Tab again allows you to cycle between them.

Changing to the desktop?

You might have more than a few different windows open on your computer. If you need quick access to a file/folder that’s currently on your desktop. keyboard-image-4jpg

Win+D Is the shortcut for you to quickly clear your screen and go to the Desktop screen that you need.

Using the snap key board.
This is a good useful keyboard combination for doing research, or writing. If you’re concurrently working in different windows.
WIN+left/right arrow keys makes the currently selected window “snap” to one half of the screen or the other. Apply left and right positioning to two windows and enjoy a perfect split screen setup.

keyboard-image-5

Peter Talent will be teaching a number of fantastic I.T. courses for Continuing Education this coming term including Become a Proficient User of MS Office 2013 and a Beginners Guide to Intermediate Level Database Use. To view a full listing of our I.T. courses click here https://goo.gl/DYbuBw