Excel Topics

Excel 2013 Workbooks

September 11, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Organising Workbooks

July 18, 2017 0

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 […]

Excel Topics

Hide / Show Worksheet Gridlines

March 14, 2017 0

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. […]

WORKBOOKS & WORKSHEETS

Start With More Than One Worksheet

March 4, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Worksheet Tabs

March 4, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Worksheet Basics

March 2, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

View Multiple Worksheets

March 1, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Microsoft Excel Workbook Formats

February 26, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Pin A Workbook

February 25, 2017 1

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 […]