Excel, Art & VAT…
June 30, 2016
Show all

5 Excel Hints and Tips – Beginners!

At The Office Equation, we spend hours and hours working with Excel and we still love it!

Ok – we understand that some people see Excel as something really rather dull and to be avoided like the plague – if that’s you, then read our 5 Excel Hints and Tips to see if we can convince you to give it a go:

  1. Consecutive Number List

To create a list of consecutive numbers, enter the first 1-3 numbers in the string, then highlight all three cells, hover over the bottom right corner of the last cell and drag down as far as you

listlist2

  1. Quick formatting

Formatting a cell can change the way that the data entered in that cell is displayed. For example, it can be a plain number with our without decimal places, a date, a currency, a percentage, plain text and many more. There are several ways to format but the quickest is on the ‘Home’ ribbon in Excel.

format

Highlight the cell or cells you want to format and then select from the drop down box shown above. You’ll be given different options to select – just choose the one that suits what you need and see the cells update to your chosen format.

  1. Autosum

This is something that we use daily. If you have a list of numbers and you need to add them up then use this!

autosum

Enter the number that you want to add up. Then in the cell below click on ‘Autosum’ on the ‘Home’ ribbon – Excel will automatically highlight the cells that it thinks you want you to add together. If you are happy that the highlighted cells are correct then hit ‘Enter’ and the total will appear in the Autosum cell in your spreadsheet.

  1. Print Area

How many times have you wanted to print something out of Excel but only half of it has printed on 1 page and the other half has printed on another page? There’s a quick way to fix this

Highlight the area that you want to print out. In this example we want the full list of food items.shopping

When the required area is highlighted, click on the ‘Page Layout’ ribbon, click on ‘Print Area’ then click on ‘Set Print Area’. The go to: File, Print and you should see a page with a list of options. The last option is the list is ‘No Scaling’ – click on the small down arrow on the right of the box and select the ‘Fit Sheet to One Page’ option. On the right hand side of the screen, you should be able to see the page that you are about to print. Click ‘Print’ and you will have a 1 page document containing all the information you need.

  1. Zoom

Too much data to view on 1 page? Is the text/numbers too small or too large? You can quickly change the size of the whole page you are trying to view. On the ‘View’ ribbon, click on ‘Zoom’.

zoom

A pop-up box will appear showing different percentages. You can select one of the % shown or you can select a ‘Custom’ %. The higher % will make the text/numbers larger to view. Likewise, the smaller % will make the text/numbers smaller.

 

Hopefully, you’ve found some of these tips useful. If you are still struggling, then please give us a call on 01785 532235 or email us on contact@theofficeequation.co.uk and we’ll see how we can help!

Leave a Reply