How do I change the left and right margins of footers (Excel 03)? Excel seems to only allow distance from bottom of page as a margin, so I now have footer...

Hi, I have developed a check list survey using Excel, however, my problem is that I want to lock certain cells that contains questions such that other users...

How do I create a macro which will allow me to insert a row on top. Eg I have data in C3..H10. Row C11..H11 is blank but cells are formatted (general,...

Hi, I have a an Excel File with data that is shared by different departments. All data is stored on the first worksheet. I then set up Custom Views so that...

Look, this is my first time to post in this group, and I can tell I'm already waaay out of my depth compared to most of you, but there used to be a product...

I have many dates that I need to sychronize the year on. For example: 1/1/2001, 1/1/2002, 1/1/2005 all need to say 1/1/2005. It's a long list of different...

The font size in me Excel worksheets is too large and I cannot find an answer in either help or the knowledge base as to how to change it.

When in Excel, I CAN send an excel spreadsheet as an attachment (file, send to, mail receipient as attachment). I can NOT send only a single sheet out of the...

I would like to keep row 1 on the screen at all times (column A through whatever column can fit on the screen display - column O in my example) without it...

When Excel merges cells, it keeps only the upper-left-most contents and deletes the others. It would be nice to have the option (maybe a toggle button in the...

I'm currently working with this array formula... =SUM(IF(G4:BJ4C4,C4,G4:BJ4))*0.09615 How do i change this so that G4:BJ4 refers to every 5th cell staring...

I am trying to save an Excel spreadsheet as a .csv file. My problem is that to import this file into a specific database, it needs both comma...

When I use V-lookup, I often have numerous results that appear as "#N/A". I would like to be able to delete all of the "#N/A" values, or replace them with a...

Is there an easy way to convert a string which is either "Monday" thru "Sunday" into a number to work with? In particular, I want to add a 1 if the cell...

I'm creating an Excel checklist for other users and I have added context to each item on the list using the "comments" function. I have an issue regarding the...

Imagine two files, Book1.xls and Book2.xls. Each file has tabs labeled 1,2,3. When making cell A1 in Book1 equal to cell A1 in Book2, it will look like...

I would like to be able to protect or lock certain cells of a worksheet. I only want our directors to be able to access these cells. How do I do that?

If I have two columns in an Excel spreadsheet, Column A contains a list of numbers. Column B needs to reflect a numerical range that the first column falls...

I have a workbook with over 1000 sheets. 25 of these are numbers unit 1, unit 2, etc... Each one of these is followed by 50 sheets with...

how do i do to make Excel to generate random numbers to 30 persons?, but one detail, no repeated numbers! i tried the "=Randbetween(1;30)" but i couldn't avoid...