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. How to hide/show gridlines for a […]


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


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


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


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


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


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


Change Excel Default Settings For New Workbook

February 14, 2017 2

Change Excel Default Settings For New Workbook DESCRIPTION When you create a new workbook in Excel the default font type, font size, worksheet view and number of new worksheets to display are all added. In […]