Skip to main content

Posts

Showing posts from April, 2016

New Article

How to SUM by matching partial text in Excel

Remove Table Format from worksheet

Table formatting is a auto table designing tool in MS Excel. But it is hard maintain for a large database due to heavy graphics. Image 1: Auto table designing format used To remove this design follow the below steps: Step 1: Click anywhere in the table. Step 2: Select Convert to Range from Tools group under Design menu. Step 3: Click on Yes while a question will appear Do you want to convert the table to a normal range? Image 1: Confirmation message of changing the table format to range Step 4: Click on Yes and you have done. I mage 2: Removed auto table designing format