How to Navigate Cells, Rows & Columns in Excel

Learn basic navigation of cells, rows and columns in this Howcast Excel tutorial with expert Shir Moscovitz.

Transcript

Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.

In this video we are going to talk about basic navigation within the different CELLS, ROWS and COLUMNS of this WORKSHEET. So how do we select CELLS to begin with? Well, we can use the mouse simply by clicking over and selecting one cell at a time. We can also use the keyboard's directional keys to go through the WORKSHEET just like that. If you want to select multiple CELLS at a time, we can use the mouse to "Click-n-Drag" and then let go. We get all these CELLS highlighted. With the keyboard, we can start from one spot, press and hold the SHIFT key and then use the directional arrows to select additional CELLS. If you want to expand the selection, we can now go to the left or we can contract the selection like so and it always goes around the initial selection point which is shown right over here.

If you wanted to select CELLS that were not adjacent to each other - the way we do that is first select the CELL you want to start with, press and hold the CTRL key on the keyboard and then click additional CELLS as you desire. From that point we can easily change formatting to all those CELLS at a time. It's best used for Formatting as opposed to Copy and Pasting. So don't try and Copy and Paste those non-adjacent CELLS.

If you wanted to then select an entire COLUMN, you simply cover the mouse over the COLUMN until you see this down arrow and then you click. The whole COLUMN is now selected. Same with the ROWS except the arrow is pointing to the right. A little keyboard shortcut for this is if you want to press and hold the CTRL key and then hit the SPACE bar, you get the entire COLUMN. If you want to press and hold the SHFT key and then press the SPACE bar, you'll get the entire ROW.

Another trick is to select this entire chunk of data at once. You could do it with the mouse by starting at the top left, clicking and dragging until the bottom right and then letting go. Or you could click anywhere inside of the chunk of data and hit CTRL and A on the keyboard which brings you this whole selection. If you want to expand this selection even further, you hit CTRL+A again to get all of the CELLS in this WORKSHEET. Another way to do that is to click right over here to the top left.

And that's how to select all the different CELLS, COLUMNS and ROWS inside a WORKSHEET.

Popular Categories