Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.
The Cells section is used when you need to insert or remove cells, rows or columns in the worksheet. There are also options to format cells to auto-fit a column which can make your report appear more professional and easier on the eye.
If you need to add new data within an existing Excel 2010 spreadsheet, you can insert new cells, columns or rows in the spreadsheet rather than going through all the trouble of moving and rearranging several individual cell ranges.
Start by selecting the drop-down arrow for the Insert button in the Cells section of the Home tab. As shown in the image to the right, you have the options to insert additional cells, rows, columns and sheets.
Let’s take a look at how that will look by using the same spreadsheet we used in the previous Styles section tutorial, Semi-annual Expenses.
First, select cell A2. Now select the Insert button drop down arrow to see our option s in the image to the right.
Select Insert Cells and the Insert dialog box will appear. In our example, we will select Entire row by selecting the radio button next to the option. Now click OK. Here is a brief description of what each option is:
Shift cells right shifts existing cells to the right to make room for the blank cells you want to insert.
Shift cells down instructs Excel to shift existing cells down. This is the default option.
Entire row inserts complete rows in the cell range. You can also select the row number on the frame before you choose the Insert button.
Entire column inserts complete columns in the cell range. You can also select the column letter on the frame before choosing the Insert button.
As you can see in the image below, a new row has been added between the title of the spreadsheet and the headings.
Take the time to discover how each option in the Insert dialog box will impact your spreadsheet. You can always select the Undo button in the top-left of your document if it isn’t a change you would like to make.
Excel makes it easy to add blank cells to your document. For additional help, review the insert options below.
· To insert a row, select the row and then select Insert Sheet Rows from the Insert button of the Cells section.
· To insert a column, select the column and then select Insert Sheet Columns from the Insert button of the Cells section.
· To insert a new sheet, select the Insert Sheet option from the Insert button of the Cells section. This will add a blank sheet to your spreadsheet (shown in the image below).
Deleting cells, rows and columns works the same as inserting. Simply select the cells, row or column you would like to delete and use the Delete button in the Cells section of the Home tab.
To delete a sheet from your spreadsheet, simply click on the sheet you would like to remove and select Delete Sheet from the drop-down menu of the Delete button.
The final button in the Cells section is Format. As you can see in the image to the right, we have several formatting options.
Let’s start with Row Height and Column Width. To adjust these, first select the row or column you would like to change, and then select the Format button. We are going to select Row Height and the Row Height dialog box will appear. As seen in the image below, our row height is 15.
Next, let’s review the AutoFit Row Height and AutoFit Column Width. As you can see in our spreadsheet below, our Title does not fit into one column – it is spread across column A and B.
We can make this look more professional, by clicking in cell A1 and selecting AutoFit Column Width from the Format button of the Cells section.
As seen above, the title completely fits in cell A1 now.
You can hide and unhide rows, columns and sheets in Excel 2010 when you don’t want part or all of the worksheet to be visible. This can be useful if there is certain information you don’t want printed in reports – hidden rows and columns do not print.
Simply select the row(s), column(s) or sheet(s) you would like to hide, and then select the Format button in Cells section of the Home tab. From the drop-down menu, select Hide & Unhide and another menu will appear. Select which option applies.
To unhide a row, column or sheet, you need to select the row, column or sheet before and after what is hidden. Then select the Format button, Hide & Unhide option, and whichever option applies in the next menu.
To name or rename your sheet, simply select Rename sheet from the Format button drop-down menu. The sheet name will become highlighted – retype the name and select Enter.
You can move or copy your entire sheet by selecting Move or Copy Sheet from the Format button menu.
The Move or Copy dialog box will appear, as shown in the image to the right. You have the option to move your sheet to a specific book as well as move the sheet within your existing book.
Make your selections and select OK.
Finally, you can change the tab color of your sheets. Select the Format button in the Cells section. From the drop-down menu, select Tab color and choose your color. You can now see the different colors of your tabs in the image below.
Once you have created your worksheet and formatted your cells, you may want to protect your sheet to prevent unwanted changes. For example, you can prevent people from editing locked cells or changing the formatting of the document.
In our example, we are going to select all of our numerical data and then select Protect Worksheet from the Format button drop-down menu.
As you can see from the image below, the Protect Sheet dialog box will appear. First, you can enter a password, which is needed to unprotect the worksheet. Below the password, you can select which options will apply to your worksheet. Select OK after you have made your selections.
This concludes the Cells tutorial.
Click next to continue to the Excel 2010 Editing tutorial.