How to Change a Worksheet Structure in Excel 2010


show more Changing a worksheet's structure provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Changing a worksheet's structure

Very often you'll find the need to insert cells into an existing worksheet. So let me show you how you can do that with rows and columns and even cells right in the middle of a row and column. Well, for example, let's say we wanted a blank column between June and Total. Well let's go up here to the header for Column H and notice the mouse pointer is this down arrow. And just click with the right mouse button and from the pop-up, choose Insert and it inserts a brand-new column right before the column that you clicked.

And that's just kind of a Windows standard is new items generally go before the current item, whatever that item is. Could be row or column and so forth. And I am just going to press Ctrl+Z to undo that. Well, what if I select more than one column? Let's go over here and let's select Column B and C. And I have a few techniques to do that. Once you have both Column B and C selected, again, make sure it's this down pointing arrow on the header, right-...

Changing a worksheet's structure
Video duration: 3m 0s 6h 21m Beginner

Viewers:

Changing a worksheet's structure provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...