6.1 Working with Font Formatting Commands

Working with Font Formatting Commands 2

Welcome to the next section of this Excel for Beginners book, during this section we are going to move away from creating structure within the document adding content. And we are going to talk about format, making our document more presentable adding colors changing the font adding borders, just making …

Read More »

5.7 Moving and Copying an Excel Worksheet

Moving and Copying an Excel Worksheet 5

Let us talk about one more option dealing with worksheets, moving and copying sheets. We have seen renaming sheets adding sheets and deleting sheets. But what about moving the order of sheets or copying on a sheet. Maybe I need an exact duplicate of the monthly budget because this one …

Read More »

5.6. Deleting an Excel Worksheet

Deleting an Excel Worksheet 1

We are talking about deleting a worksheet from a workbook. Be very careful when deleting sheets from an Excel workbook. The reason for this is once you delete a worksheet from a workbook, There is no undo for this. Typically, if something goes wrong, When I am working instead of …

Read More »

5.5 Renaming an Excel Worksheet

Renaming an Excel Worksheet 3

In the earlier lecture we were talking about copying and pasting cutting and pasting data, I showed you how to insert a new worksheet, at the bottom of screen and the newer releases of Excel. You got a little plus sign(+), that you can get to in the earlier releases …

Read More »

5.3. Changing the Width and Height of Cells

Changing the Width and Height of Cells 10

The next topic that I want to get into is a common question that I get since I make Excel trainings. This deals with changing the width of a column and the height of a row. this shows up in various questions that I get for many different reasons. One …

Read More »

5.2. Inserting and Deleting Rows and Columns

Inserting and Deleting Rows and Columns 8

We have seen a little bit of copy and paste. what about adding additional rows and additional columns into an already built spreadsheet. If I want to introduce an additional bill into my monthly budget. You can do this a couple of ways. There are a few things that we …

Read More »

5.1 Moving and Copying Data in an Excel Worksheet

Moving and Copying Data in an Excel Worksheet 9

During this section we are going to talk about modifying Excel worksheet, modifying the spreadsheet. We will also talk a little bit about modifying the workbook structure, such as adding and deleting worksheets within the workbook. First let us talk a little bit about moving and copying content, talk about …

Read More »

4.8 Excel’s AutoSum Shortcut Key

AutoSum Shortcut Key 2

We are talking about the AutoSum I gave you a couple of ways to do it, You can do it on a single cell, Hit the AutoSum button. You could select a range of cells and use the AutoSum. That takes us back to the discussion about relative references, because …

Read More »