Page 147 - Ms Excel Note and Workbook
P. 147
MICROSOFT EXCEL NOTE AND WORKBOOK
To remove a table:
It's possible to remove a table from your workbook without losing any of your data. However, this
can cause issues with certain types of formatting, including colors, fonts, and banded rows. Before
you use this option, make sure you're prepared to reformat your cells if necessary.
1. Select any cell in your table, then click the Design tab.
2. Click the Convert to Range command in the Tools group.
3. A dialog box will appear. Click Yes.
TIP
To restart your formatting
from scratch, click the
Clear command on the
Home tab. Next, choose
Clear Formats from the
menu.
4. The range will no longer be a table, but the cells will retain their data and formatting.
To restart your formatting from scratch, click the Clear command on the Home tab. Next,
choose Clear Formats from the menu.
138 | P a g e
