Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

If you need an extra column in a particular place, or you need a few rows, or you need to color something in a particular way, or perhaps change the overall look and feel of the whole thing not only for its own sake but also to make what you've done appealing to other people, you've come to the right place. This tutorial demonstrates some of the basic formatting techniques you can use to get you started.

Get over 70 hours of Microsoft Office 2013 training here course here: http://bit.ly/office-2013-training

Stay in touch:
StreamSKill.com: http://streamskill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Hello again. In this section, we’re going to start to look at formatting of our workbooks and worksheets. We’re going to try to make them look good for one thing, partly to help to make our point, to present what we’re trying to do clearly, but also to make what we’re doing more interesting so that people won’t be just put off by a very blank, boring sheet of black numbers on a white background or something like that.

But as part of that we also need to know how to change what we’re doing as we go along. If you need an extra column in a particular place or you need a few rows or you need to color something in a particular way or perhaps either change the overall look and feel of the whole thing or perhaps make it match something else you’ve done in Office 2013 not only for its own sake but also to make what we’ve done as appealing as we can to other people.

Now, in order to demonstrate some of this basic formatting, let’s start with this simple list of expenses that we had earlier on. And the first thing I want to do is I want to have an additional row before the expenses that are currently there. So the expenses start on Row 2. I’d like two blank rows before that.

So what I’m going to do is I’m going to select Row 2, and then there are a number of options. One of the options is on the Home tab in the Cells Group the first Command at the top there, Insert has a drop down next to it, and one of the commands there is Insert Sheet Rows. Now that command will cause the same number of rows as I have selected, which is one row to be inserted above the currently selected row. So if I click on Insert Sheet Rows now, I will get one new blank sheet row.

Now, if I instead of that I indeed selected two rows and done exactly the same thing I would have got two blank rows. But I only wanted one so let me Undo that and I’ve got my one blank row. Now that’s one of the ways of inserting a blank row. If I’d selected that row and done a right click the Contextual Menu would have also given me an Insert option and in fact we’re going to insert an additional column now so I’ll use that approach on the column. So let’s suppose I want another blank column before Column B. If I right click on Column B and say Insert Excel knows that as I’ve got a column selected, I must want a column inserted. So it knows to insert a column rather than a row. Click on Insert and I get a new blank column.

Now one of the things that I need to point out here is that as you insert columns and rows on a worksheet Excel, automatically renames and renumbers what’s there. Now as you’ll see quite a bit later on in the course, once we start using formulae to do arithmetic and statistical analysis and so on, on the numbers in a worksheet Excel has to do quite a lot of work to keep up to date with us inserting rows, inserting columns, deleting cells, and so on. So it’s quite a complicated job that it has to do. But you can trust Excel to do that correctly because as you insert and delete rows, columns, and cells Excel will keep track of everything even though the names of things do tend to change.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.