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

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

WORKBOOKS & WORKSHEETS

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

WORKBOOKS & WORKSHEETS

View Multiple Workbooks

January 5, 2017 0

This tutorial will show you how to quickly navigate between active workbooks or display multiple active workbooks on the same screen. In this example we have two active workbooks: Book1 and Book2. View Side by […]