iFocus.Life News News - Breaking News & Top Stories - Latest World, US & Local News,Get the latest news, exclusives, sport, celebrities, showbiz, politics, business and lifestyle from The iFocus.Life,

Adding Or Deleting a Row Or a Column in Microsoft Excel 2007

103 26
In Microsoft Excel 2007, you main and core purpose is to tabulate spreadsheet for analysis of data.
During the process of setting up the spreadsheet or table, you may make mistakes such as wrong title, wrong data entered, wrong columns or wrong row selected and so on.
You need multiple functions from Microsoft Excel to solve such a problem.
One of the functions you could utilize Add function.
Say for example you are setting up a table consists of 5 different column (column A to E), you have filled up all the data needed, later to find out that you need to add a column in between of D and E.
One way to do it is to cut Column E and Paste it on Column F, it is possible when the table is small.
However, when the table size grows larger, it will become a trouble to you when you want to add columns in between of table.
Let me introduce you with Add function, follow the steps as mentioned below to add a new Column or a new Row.
First of all highlight the column on the right where you wish to new column to happen.
Say you want to add column in between of Column D and E, you will have to select Column E.
Then (Step 2) follow the path Home-- >Cells-- >Insert-- >Insert Sheet Columns, you will see a new column being added to the worksheet.
Alternatively you may use the Right Click function on the mouse, continue the first step (highlight the column), and then Right Click on the highlighted column, and select Insert.
How about Inserting Rows? The procedure would be about the same, just that all works happen vertically.
Now in Step 1, select the row below the cell you want to additional Row to happen.
Then in Step 2, follow the path Home-- >Cells-- >Insert-- >Insert Sheet Rows, you will see a new row added.
Alternatively, you can add the new row by using the Right Click function on your mouse, just Right click on the highlighted row, and then choose Insert, you will be able to add a new row.
It is that easy.
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
You might also like on "Society & Culture & Entertainment"

Leave A Reply

Your email address will not be published.