Excel | How to videos
Professional IT Support In Witney
01993 706161 info@systems-and-solutions.co.uk

Excel

Always see the headings when scrolling

Excel is great for looking at lots of data, but when you can’t see the column or row headers, you have to scroll back and forth to check what the data means. Did you know there’s a great time saver which can lock the headers in place? Here’s how to do it.

Easily zoom in and out

When you’re looking at data in Excel, make sure you’re looking at the bigger (or smaller) picture by using the Zoom functions. This video shows you how to zoom in and out easily.

Get to the top row without scrolling

If your Excel document is very long, it can take a lot of scrolling to get back to the top. Find out how to do it quickly, without moving the mouse or endless scrolling. It’s a shortcut you’ll use over and over.

Instantly see all data in columns & rows

Sometimes in an Excel document the column sizes need to be adjusted so you can see the data clearly. Rather than trying to change all the column and row sizes manually, we show you how to do it in just a few clicks.

Speed up typing

Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process by using the clever Flash Fill feature. It’ll save you from typing out the same info multiple times. Here’s how to use it.

  • 1
  • 2
01993 706161
This email address is being protected from spambots. You need JavaScript enabled to view it.
27 Fettiplace Road Witney, OX28 5AP

Opening Hours

Sunday:   Closed all day
Monday:   0900  to 1700
Tuesday:   0900  to 1700
Wednesday:   0900  to 1700
Thursday:   0900  to 1700
Friday:  0900  to 1700
Saturday:   Closed all day

Would your business pass or fail the 57 minute data security challenge?

 
What type of user are you?
 
Contact Us
01993 706161
info@systems-and-solutions.co.uk
We use cookies to maintain login sessions, analytics and to improve your experience on our website. By continuing to use our site, you accept our use of cookies and Privacy Policy