Microsoft Office Tutorials and References
In Depth Information
Convert a Table to a Range
Convert a Table
to a Range
If you no longer require the Excel table tools, you
can convert a table to a normal range.
Tables are extremely useful Excel features but they
can occasionally be bothersome. For example, if you
click a table cell, click the Design tab, and then click
a cell outside the table, Excel automatically switches
to the Home tab. If you then click a table cell again,
Excel automatically switches back to the Design tab.
If you are not using the table features in the Design
tab, this behavior can be annoying, but you can
prevent it from happening by converting the table to
a normal range.
Convert a Table to a Range
1 Click a cell inside the table.
2 Click the Design tab.
3 Click Convert to Range (
).
Excel asks you to confirm.
4 Click Yes .
Excel converts the table to
a normal range.
Search JabSto ::




Custom Search