How to Convert Tables to Range in Microsoft Excel 2016

by Ali December 14, 2017 at 8:13 am

In this article, I will show how to convert tables to range in Microsoft Excel 2016 so stick with us until the end. If you know already much about tables then good but if, you do not know then click here to collect some information about tables in Microsoft Excel 2016. Reminding one thing that tables are a perfect feature for organizing data or information with a great filtering and sorting options. Sometimes we do not really need the sorting or filtering options so in that case, you do not need to copy the data of the table and paste it on another page, you can convert the table to the range or simple Excel cells. After you convert the table into range, you will not be able to use filters option. One of the benefits of converting the table into range is that the formatting or the design will not fade away.

You do not have to worry about the data; it will not bring any changes to the data. If you are interested to learn this then follow the steps in the following heading. You can watch the video tutorial if you are not interested in reading.

How to Convert Tables to Range in Microsoft Excel 2016

I have told much about converting the table to range in the first paragraph. Without wasting more time let’s move through the steps.

Step1. First, insert a table and then click on any part of the table. You will see another tab by the name of Table tools (Design). Most of the time the tab will appear automatically after you click on any part of the table. If you do not have an idea of where the tab will appear then look at the following picture.

How to convert tables to range in Microsoft Excel 2016
Convert To range

Step2. In the same tab find, the tools group and then click on the option (Convert to the range). After you click, you will see the changes in the table. The filtering option will disappear that existed in the first row.

They were the two easy steps of how to convert tables to range in Microsoft Excel 2016; I hope you have learned something from this article.

Conclusion (How to Convert Tables to Range in Microsoft)

Whenever you want to transfer tables data to a simple Excel range then you do not need to copy and paste it, you can convert the table to the range. It will be more comfortable rather than copying and pasting. In addition, the table’s formatting will remain. Share your ideas about converting the table to range in the comment section. Feel free to ask your questions regarding this article and Microsoft Excel. We will be happy solving your problems. Do not forget to watch the following video and make sure to visit our YouTube channel.

Share

Add Comment