I have a spreadsheet, in a few columns I merged cells and put a pattern in.
The file is saved...
How do I undo the pattern?   I'm not seeing "None" as an option.
Any responses are much appreciated.

I am my own worst enemy.  I created a macro that utilizes named ranges when
it creates spreadsheets.  If my users want to create their own formula and
inadvertently use my named range, the results are incorrect.
A simple formula they'd put in such as =d3/c3, becomes ...

I need a macros to autofill rows. I am working on one now but have a few
problems. I have one spreadsheet that has a row for each employee for each
payperiod. It has the employee name, check number, date, hours worked,
vacation sick, pay etc, earnings. The hours worked may be in ...

I cant have my pics opened by MOPM, instead a lot of red checkmarks framed by
a box appears

if i create a formula linked to another file and i need to save this to
another folder and deleting the original source where i link the file is
there a way that i can maintain the same figure and won't affect it
eventhough the file that link originally was gone?

I have a sheet with data that includes totals in the bottom row.
I would like to be able to invoke automatic filtering such that
the totals change dynamically to cover only the visible rows.
I can't figure out any reasonably easy ways to do this.  Folks?

I have a small problem which I can partly solve but not fully. The scenario
is following:
I have columns formated as number with 2 decimal places however I need to
split these columns into whole number and decimal number but I need the

I'm creating a spreadsheet of my music collection and am having trouble with
the way things are sorting.
1. Data was entered as: "The Allman Brothers Band" through importing data
from another source.

How do I do the IF function formula for calculating the shipping cost for an
order
If the standard shipping cost is $8.95 and express is $14.95

I need to make a backup onto a server for every file I save.  Is there a way
I can have excel save 2 copies - one where I have access, and one in the
backup file in my server?

When I use Excel, and change column width, I get error message of "Can not
shift objects off sheet"
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I want to be able to enter an integer into a cell and have it
automatically displayed and perceived by excel as a decimal less than
1.
In other words, if I enter "456" into the cell, I want it to display as

I want to do a custom number format that will automatically mark off two
decimal places just like my adding machine does.  
Ex:  type 12345         entry becomes $123.45

my excel is extremely SLOW & constantly giving me the "not responding"
message is this typical? anything i can fix?

A user brought me a spreadsheet in which the cells had gotten out of
alignment -- that is, the cells in one column had gotten shifted upward so
those cells were no longer in line with the other cells in their row.
I know when deleting cells you can shift the other cells upward or ...