Excel 2013 – Zoom Worksheets

Excel_Zoom2

By default Excel 2013 worksheets are displayed at 100% of their normal size, but there are times when it is useful to zoom either in and show less on the screen, but make it larger, or if you have a large worksheet you can zoom out to see more of the Worksheet. The easiest way […]

Excel 2013 – Spell Checking

Microsoft Excel Spell Checking

There is nothing that will make a well structured and smart looking Workbook look bad like poor spelling. Fortunately, just like it’s cousin ‘Word’, Microsoft Excel includes a comprehensive and expandable spell checking tool to help you take all the hassle out of checking your Workbooks. To access the spell checking tool you can do […]

Excel 2013 – Find & Replace

Microsoft Excel 2013 has a very handy ‘Find & Replace’ function that is useful for both locating certain text strings within your worksheet, and optionally, replacing those strings with different strings if you need to. This functionality can be very useful if you are working on a large spreadsheet with many rows or columns. To […]

Excel Formulas Explained

Excel_Worksheet_Function

Excel formulas and calculations are the basic building blocks of any Excel Workbook, and without these things any Excel workbook or worksheet is just a collection of static tabulated data that could be created in any word processor package. A formula at its most basic basic level is a sequence of commands that that when […]

Excel 2013 – Deleting & Moving Data

Deleting Excel Data2

There are many times when you will need to either delete data or move it to a new location within the current Worksheet or Workbook. Before you read through this we recommend that you first read our tutorial on Selecting Data as this will make deleting the data a whole lot easier. One you have […]

How to Clear the Windows Print Queue

Clear Windows 8 Print Queue

If you have a glitch or communication problem when sending a document to your printer then there is a good chance that the failed document will become stuck in your print queue. Turning the printer off and on again generally has no effect because your Windows system is suffering from a print spooler error. The […]

Excel 2013 – Selecting Data

Excel_Select_Block_Cells

Once you have some data in your spreadsheet you will need to know how to select it before you can do anything useful with it such as formatting, deleting, copying, moving etc. As with all things to do with Excel, there is more than one way to select your data, and which option you choose […]

Recovering Microsoft Office Documents

How to Set Up Auto Save In Microsoft Office 2013

As any regular user of any program in the Microsoft Office 2013 suite will testify it’s very easy to accidentally close a document without having first saved, and in the process lose what can potentially be hours of work. Of course we all talk the talk telling people to save, save, save as frequently as […]