General

Freezing Details
When I try to print a data table in which the upper row that contains the description for each column is frozen, I can't include that row in my print screen. The data table is updated daily so it's a rather lengthy spreadsheet. Is there a way that I can include the frozen section of my spreadsheet when I print ... 3 Jul 2008 13:32

Way around CUT problems...
Afternoon all I have a sheet, say Sheet 1, which has no formulas or macros; but is referenced by a whole host of other sheets in the workbook which use the data in Sheet 1 to provide the user with a load of useful stuff. If (or when) the users use 'Edit > Cut' in Sheet 1 moving data around, the formulas in ... 3 Jul 2008 10:27

How do I splti cells?
I am trying to split 1 cell down into 2 or more cells but cant remember how to do it. ... 3 Jul 2008 10:27

Excel - IF Functions
Is there any way to make a nested IF Function where one of the options is to input your own value? Or, similarly, can the false value for an IF Function be your own input? Thank you for the help...I appreciate it. ... 3 Jul 2008 10:27

loop code on cell range
Please help,I am new to code and want to do the following. I need to delete information on a worksheet which are older than a specified date and then loop the code through a range up to 500 times.The macro evaluate the date in cell a3 and if the date are older than than today less let say 30 days it should then ... 3 Jul 2008 10:27

Document Not Saved message
Received an elaborate excel spreadsheet via email. I was asked to open it change some #'s then send it back. I am unable to save the spreadsheet with or without changes. The message I receive is “Document Not Saved”. I have attempted to save it to a different location. I am an admin on the workstation. I ... 3 Jul 2008 11:28

custom currency format for Indian rupees
This is not working for negative numbers. Please help "Bob Phillips" wrote: Here is a format that you can use [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "seenu" <seenu(a)discussio... 3 Jul 2008 08:23

Comparing Text to Several Cells
I am trying to compare the word in one specific cell to the word in several other cells in a single column. The purpose is that the cell were the code is should display a specific word if the comparision is equal, if not it should display the word in the specific cell you want to compare with the column. I hav... 4 Jul 2008 12:04

Formulas
how do i create a formula to divide a number by 2 and then display it to the nearest 5 99 divided 2 = 49.5 and then have the display read 45 or 74 divided by 2 = 37 and then display 35 ... 3 Jul 2008 08:23

Sum if functions not copying text
I'm setting up a spreadsheet and wish to transfer data from the front page to another page based on a Y or N desicion halfway across the front page. It's a register system and all students' names & ID no's go on the front page along with a list of activities. Each actibity will get a Y or N desicion made depe... 3 Jul 2008 11:28