Looking for help ASAP!!! Table Formatting Style keeps disappearing . . . frustrating!!

kajero

Board Regular
Joined
Jun 28, 2009
Messages
150
Can one of you gurus help me out?

I am using Excel 2010 with Windows 7 64 bit operating system.

No matter what I do, I keep losing the format style of the table when I copy paste insert rows into the table or paste rows at the end of the table. When I drag cells down to copy them, I also lose the banded effect. Everything winds up the color of the first cell I use to drag the information down.

I have tried some things that seem to work for a while but then quit again.
I select "no fill" on the table and then clear all formats. The data appears to be in a just regular old spreadsheet. I then click on the format as style button and choose table format. The format stays for a while, then all of the sudden I don't seem to have it again.

Can anyone offer any advice?

I also seem to have lost my default auto calculate. I have went to the Excel Options and selected the calculate automatically, but I cannot seem to find a place where the default is. it seems to be only for the current workbook.

Thanks for all the assistance you always provide.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Ilona29

New Member
Joined
Mar 29, 2013
Messages
6
deleting blanks

Hi everybody, I have another question
How can I delete/hide rows which contain formulas but doesn't contain any text, like they are blanks with formulas. But if something changes in the cells where the formula refers to and blanks changes with text the raws appear automaticly.
Sorry for my English and thanks in advance
 

Watch MrExcel Video

Forum statistics

Threads
1,133,529
Messages
5,659,343
Members
418,498
Latest member
nattynat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top