In this session i'm going to talk about rows and columns. In excel it's very often the case that before you do something you need to select the thing that you want to do something .To first so, in this case we're going to start by selecting rows and columns. we are going to look at ways of doing this with the mouse and the keyboard including some shortcuts.
The most intuitive way of selecting a column
Go up to selecting a column d and click the column. It's then selected if you want to select several columns hold the mouse key down and drag it works exactly the same for rows click a row or hold the mouse key down. Select as many or as few rows as you like and once you've made a selection. you will then have various alternatives on actions. That you can perform on the column or the row the second way to select rows and columns is using the keyboard let's just say that the active cell is cell d5.
How To Work With Rows And Columns ? If i want to select an entire row shift spacebar. If i then want to change the size of that selection i can hold the shift keyand use the up arrow or the down arrow. To select if i want to select various number of rows alternatively to select various rows select some cells shift spacebar. Selected the entire row for all of those cells that, select exactly the same for columns except this time. It's ctrl spacebar and again i could select several cells control spacebar.
Now to cover the insertion and deletion of entire columns and rows firstly select an entire column right click the mouse and click on insert. If i want to delete that with the same column highlighted right click delete. It can do the same on the ribbon with insert and delete although on the ribbon. Now you have some options with the drop down. You can also use a shortcut key ctrl plus and control minus. If you want to insert more than one column highlight two columns.
How To Work With Rows And Columns Use Shortcut Keys
Use the control plus to keep this quick and you'll see that inserted two columns and control minus to remove the rule is that, we're always going to insert the columns to the left of the selection and with rows it'll always be above the selection. So, just taking a quick look with rows which work exactly the same. Select two rows right click insert. This time just use delete from the ribbon what happens if we don't have entire rows or columns selected.
We just have a range for example c6 to e6 if i then right click and go to insert. Excel will ask me if I want to move these cells down is it just these three cells that, i want to insert or do i want to insert an entire row. So, for example: Entire row will get the same effect ctrl z to undo insert this time shift cells down and i've shifted the cells down so this can be very useful. If we just want to shift part of the table down without moving everything in that row down.
Use Ribbon To edit
Selecting another range this time using the ribbon, if i click on insert the dialog box hasn't come up. It's just automatically inserted those rows so you just need to be a little bit careful, when we're using the ribbon ctrl z to undo using the ribbon. If we look at this drop down we can see that there are also options to insert entire rows and entire columns.
The same goes for delete we've been talking a lot about inserting and deleting but the delete key on the keyboard. Just quite simply deletes the contents of sales.So, here a highlighted range hit the delete key. Those contents are cleared now i want to take a look at column width. If you want to set the column width. Click on the column letter and hovering off to the right you will see a vertical line with arrows pointing left and right you can use this vertical slider to change the column width up or down alternatively. If you want to set the column width for the widest cell in the column. just double click when you've got this vertical black line with the left and right arrows. Excel will optimize the column width.
How To Optimize Column With Shortcut Keys
If you just want to optimize the column width for say the titles. Highlight the titles and use this shortcut or not such shortcut alt h o I. Excel has optimized so that you can read the titles but there may be sales, where you've got too much space or too little space to be able to see, exactly what you want to see it works exactly the same with rows here. To select several rows and this time, we get the horizontal black line with arrows on down and we can drag up all down to set the row height. You will probably find yourself fiddling around less with rows than columns.
Because, if you keep the same font normally you won't need to change the row height another way to set row height and column width is to use the ribbon with several cells selected. Let's just go up to format click on the down arrow and we can see we have options. For example: Row height here escape .We also have auto fit row height. So, for example: If you change the row height here manually go back into format. it can then auto fit row height .
How To Hide & Unhide Row & Column
It will reset it to the correct row height ,there are similarly options for column width and to also fit column width as well. To look at the various ways to hide and unhide rows and columns. Firstly, select several cells then shift space to select the entire row right click hide to unhide. Select the rows above and drag the mouse to the row below. Then right click unhide, we can do the same thing with the ribbon but this time we don't even need to select the entire rows .we can just select some cells and go up to format on the ribbon and hide and unhide.
How To Work With Rows And Columns ? Hide rose again, if we select cells above and below. We can go to format hide and unhide unhide rows. This time let's select several rows and the shortcut key is control nine. So, the rows are now hidden to unhide, we have a shortcut key control shift and then we have the rows unhidden. It works much the same with columns you can use the ribbon. You can use right click so let's highlight a couple of columns and we'll just right click and hide those columns again.
How To Work With Rows And Columns ? You need to select the columns either side of the hidden ones to unhide them right click unhide we also have the ribbon option format i do not hide hide columns and i'm just going to ctrl z to undo this quickly the final option that we have is to use shortcut keys this time it is control zero to hide in this version of excel we need to use ribbon based shortcuts to unhide alt o c u finally i'm going to show you grouping and ungrouping this is really just another way to hide and unhide rows and columns firstly i'm just going to bring this data together it'll make it easier to show this so control minus to get rid of those two columns i'm now going to highlight most of the columns here.
How To Work With Rows And Columns Form Group With Ribbon
To click on group in the ribbon we now have these columns grouped so we can click on this minus to hide all those and click on the plus to reveal them again we can have layers of grouping so I’m going to select a subset of those columns and click on group again this time we have various levels of being able to see columns if I click on one it will hide everything that's grouped but if I click on two it'll show the next layer and if I click on three it'll show all the layers if we want to ungroup highlight the columns and click on ungroup and here we go I’m going to click on group again so this works the same for rows thank you.