Excel Topics

Excel 2013 Workbooks

Create A New Workbook The following guide will show you how to create a blank workbook. Click the File tab Select New from the left menu Click Blank workbook Add A New Blank Worksheet When [Read More >>>]

WORKBOOKS & WORKSHEETS

Organising Workbooks

Excel workbooks can accumulate very quickly and you can very easily start to lose your way so it is always good practice to be organised from the start. In this article we will provide a [Read More >>>]

Excel Topics

Hide / Show Worksheet Gridlines

The gridlines displayed in a worksheet can be very useful especially when you are designing your worksheets. There are times however when you may want to hide the gridlines. Step 1 Click the View tab. [Read More >>>]

WORKBOOKS & WORKSHEETS

Start With More Than One Worksheet

When you create a new workbook in Excel 2013 a single blank worksheet is added for you and named Sheet1. This is different from previous versions of Excel where by default you were given three [Read More >>>]

WORKBOOKS & WORKSHEETS

Worksheet Tabs

Each worksheet has a tab at the bottom of the workbook which contains the name of the worksheet. By default Excel names a new worksheet “Sheet1” if you add another this is named “Sheet2” and [Read More >>>]

WORKBOOKS & WORKSHEETS

Worksheet Basics

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 [Read More >>>]

WORKBOOKS & WORKSHEETS

View Multiple Worksheets

In this example we have two worksheets in our workbook. We want to view both worksheets on the same screen. Here are four easy steps to execute this…. Step 1 On the View tab click [Read More >>>]

WORKBOOKS & WORKSHEETS

Microsoft Excel Workbook Formats

In Excel 2007 Microsoft introduced a new file format, Office Open XML which allows other programs to easily work with Excel workbooks. Listed below is a list of the most common file formats you will [Read More >>>]

WORKBOOKS & WORKSHEETS

Pin A Workbook

A quick way of opening workbooks you use most frequently is to pin them to the Recent list that is displayed when you first start Excel 2013 or when you click FILE from the file [Read More >>>]