Navigating Excel Table (7 Simple Techniques)

Navigating an excel table is just like navigating within a worksheet. You can use a mouse or you can use the keyboard to navigate within a table. In this post, we shall discuss how you can navigate an excel table with 7 simple techniques.


Download Practice Workbook

Download this sample file to practice by yourself.


What Is an Excel Table?

In general, a Table is a tool in Microsoft Excel which is a storage of our data in a certain manner. It represents data within a rectangular table defined and named in a particular way. We can create an excel table from the Home > Styles > Format as Table command or Insert > Tables > Table command.

In this article, we have created a table comprising the information of Sales Report of 10 different people from the USA and UK.

Navigating Excel Table


7 Simple Techniques for Navigating Excel Table

With the sample dataset that we mentioned above, we will learn to navigate the excel table with 7 simple techniques. Let’s get started.

1. Use Keyboard Shortcut to Navigate Excel Table

Keyboard shortcuts are the ultimate time saver for excel users. We can use it to navigate the table in different situations. Let’s check them out.

1.1 Select Entire Column

There are 3 ways to select an entire column in the dataset. Here they are:

  • Firstly, select the first cell of the column and then press Ctrl + Shift + Down button to select the whole column until the last value.
  • Secondly, click the first cell and press Shift selecting the last cell of the column for selecting the whole.
  • Thirdly, press Ctrl + Space twice to select the entire column including the header title.

Following any of the methods you will see this output:

Use Keyboard Shortcut to Navigate Excel Table


1.2 Select Entire Row

Just like a column, we can select an entire row as well with keyboard shortcuts.

  • First, select the first cell of the row that you want to navigate.
  • Then, just press the Shift + Space key and you will get your desired selection.

Use Keyboard Shortcut to Navigate Excel Table


1.3 Select Entire Table

It is also possible to select the entire table with keyboards. Here is the solution.

  • First, select the first cell B4 of the table.
  • Then, press Ctrl + A twice to select the table including the header.

Use Keyboard Shortcut to Navigate Excel Table

Note: You can also use the Tab key to surf over the excel table horizontally and vertically.

2. Navigate Excel Table with Mouse Cursor

We can also navigate the excel table with the help of a mouse cursor. It is not only confined to selecting an entire row, column and table, but also we can select part of the table with the mouse. Let’s see how it works.

2.1 Select Entire Column

The mouse cursor can help to locate and select columns easily.

  • First, put your cursor over that specific column from the bar.
  • Then, it will show an arrow like this:

Navigate Excel Table with Mouse Cursor

  • Following, left-click on it and it will select the whole column.


2.2 Select Entire Row

We can also select an entire row with just a click.

  • Simply hover over the row pointing with the small arrow.
  • Then, left-click and the whole row is selected.

Navigate Excel Table with Mouse Cursor


2.3 Select Entire Table

It is also possible to select an entire excel table as a part of navigation. Here are 2 ways to do it.

  • Firstly, hover your mouse over the top left corner and you will see a small diagonal arrow.
  • Now, left-click in this state twice to select the table with headers.

Navigate Excel Table with Mouse Cursor

  • Otherwise, you can simply select the first cell and then drag it to the last one to select the entire table. You will see this icon afterward.

Navigating Excel Table


2.4 Select with a Single Cell

In addition to the above methods, we can select a row, column or entire table by selecting only one cell.

  • Simply right-click on any of the cells in the dataset.
  • Then, go to Select.
  • From here, choose any of the options of selection.

Navigate Excel Table with Mouse Cursor


3. Select Name Box for Navigating Table in Excel

When you have a huge number of tables throughout your worksheet, it gets difficult to navigate them one by one. In this case, Name Box is a useful solution for navigation.

  • First, select any cell inside the excel table.
  • Then, you will see a new tab named Table Design in the Excel Ribbon.
  • In this ribbon, you will see the Table Name of that specific worksheet.

Select Name Box for Navigating Table in Excel

  • Now, just below this, you will see the Name Box with the list of tables.
  • Select any one of them according to your preference.


4. Excel Table Navigation with Table Filter

Table Filter helps you to navigate it according to categories. You can find this option by clicking the filter arrow in the headers.

Excel Table Navigation with Table Filter

To turn off this feature you can apply two of the methods below:

  • Press Ctrl + Shift + L on your keyboard and the filter will be inactive in the excel table.
  • Otherwise, go to the Table Design tab and unmark the Filter Button to turn it off.


5. Keep Column Header Visible While Scrolling

Here is a fun fact about navigation through the excel table. Whenever you have a long table, you will find the header constantly visible by scrolling downward. Here is how it looks:

Keep Column Header Visible While Scrolling


6. Table Navigating to Add Row/Column in Excel

An important part of excel table navigation is adding a total row or a new column to the dataset. It is required when you want a total result (sum, average etc.) in the row. Here we will discuss the process of adding a row and column separately.

6.1 Adding Total Row

Here are 3 different solutions to add a total row to the table.

  • Firstly, you can turn on the Total Row feature from the Table Design tab.

Table Navigating to Add Row/Column in Excel

  • Secondly, you can right-click on any cell of the excel table and select Total Row from the Table section.

  • Thirdly, press Ctrl + Shift + T and you will get the final output.


6.2 Adding New Column

Following are two solutions for adding a new column as a part of excel table navigation.

  • Firstly, insert the new column header name GDP in cell E5.

Table Navigating to Add Row/Column in Excel

  • Following, press Enter and you will see the new column is added.

  • Otherwise, right-click on any cell and select Table Columns to the Left from the Insert section.

Note: Keep in mind that, these methods are also applicable for adding a new row, but not for adding a Total Row.

7. Delete Row/Column During Excel Table Navigation

For easy navigation, you may need to remove certain rows or columns from the excel table. Here are two solutions for it.

  • Right-click on any cell and select Table Columns or Table Rows from the Delete section.

Delete Row/Column During Excel Table Navigation

  • Otherwise, select the whole row or column following any of the methods above and press Delete on your keyboard.

Conclusion

So this summarizes the ways of navigating an excel table with 7 simple techniques. Do leave your comments to let us know if this post was helpful. Keep an eye on ExcelDemy for more blogs.

Tags:

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo