Knowing how to change worksheet structure in excel is very essential as a professional excel user
Very often you’ll find the need to insert cells into an existing worksheet. So, let’s learn how to change worksheet structure in excel using rows and columns or even cells, right in the middle of a worksheet.
Look at the above table structure, let’s say you wanted a blank column between ‘June and July’. Move your mouse pointer to the header of column ‘H’ above July, you will notice your mouse pointer turns to a down arrow and just click with the right mouse button.
Immediately you click the right mouse button, select insert from the pop up and it insert a brand-new column for you.
Excel inserts a brand-new column right before the column that you clicked and that’s just kind of a windows standard. New items generally go before the current item and whatever that item is, it might be rows, column and so forth.
Two or more columns can be selected to insert more than a brand new column, make sure to select multiple columns if you intend to have more than one column inserted within a worksheet.
Right click and select insert from the pop up, excel insert multiple columns for you depending on your selection.
Adding brand new rows across the rows works the same way, all you have to do is select a number among the headers in the row, you can select multiple rows,
Have it mind brand new rows or column will be added above the first selected rows to the top and to the right of the first selected column.
Well, let’s say, you wanted to insert cells in the middle of a worksheet and it might seems a little bit hard to figure out,
Well, here’s how to go about it,
Select the number of cells you want to insert a new cell before them, right click the highlighted area and select insert from the pop up.
Now, because you are inserting cells in the middle of a worksheet, excel has to figure out which way do you want to push it, up, down, left or right.
One amazing thing about excel, it’s pretty good at guessing and it knows you probably want to shift the cells right, all you have to do is press OK.
If you want to add cells across the row, excel guesses correctly you probably want to shift the cells downward and you just have to press OK and a brand-new cell is inserted.
Most of the time, you want to insert entire new columns or rows and cells in the middle of a worksheet, now you know how to change a worksheet structure in excel and you can see the techniques are all the same and you can do it either way.
You can watch the video below for visual explanation. Thanks, sharing is caring.