WebDummies – Easy to do Easy to do

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 …

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 …

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 …

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 …

Just a look at increasing the height or the width or decreasing the width and height of columns and rows. What about hiding a column or hiding multiple columns or rows. I do not want people to see this data. I do not want everybody that goes into the worksheet …

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 …

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 …

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 …

So I want to show off one more item here and this is something. that I use all the time when I am dealing with calculations inside of Excel. And for that matter there is other scenarios outside of calculations that I use this for as well. It is a …

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 …