How do I make the cells apear on the printed page? HELP!

Hi I have a column where formula produce values where the text is conditionally coloured according to its value, ie negative numbers are red, positive are...

Hi I have a column that contains cells with tag numbers and description, I need to extract the tag number and place this two cells to the right, ie I need to...

Hi When I highlight a range of cells AutoSum misses certain cells, even though all cells have the same format. The same applies when I change the format to...

Hi I have a column displaying worksheet names, is there a function that will automatically change the name in the cell, when the worksheet name...

If I have the following data in columns A to D: A B C D G 2 H 5 2 3 H 8 G 4 H 9 5 ...

Hi Can anyone tell me how to sum a range of numbers in column D, provided that adjacent cells in row A contain "Apples" and row C contain...

I would like to add a row above certain cells that repeat themself. For example, Column T list several company names like this. Arby's Arby's Arby's Burger...

=IF(T8="PTO NB",0,IF(T8="Leave of Absence NB",0,IF(T8="Available",0,IF(T8="Int. Proj. Available 100%",0,IF(T8="TAG",0,1))))) This formula is not returning 0...

If a cell contains the word Vice President I would like to copy the entire row it sits on to the next worksheet. Is there a way to do this as a macro...

On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions...

Hello! I am trying to copy 15 cells in a row in one document to 15 cells in a column in another document. The past link function seems to work until I...

I want to change lower case letter to UPPER case. The example in the excel assistance is not clear to me. I tried but fail to get the result I want.

I need to create a formula that will provide a result that calculates a date three years out and another date one year out with the result being the greater...

If I have a string with numbers and text (a single cell with address plus number plus complement), and I would like only to separete number string. How can I...

Hello all. Please help me with a problem I am having. I have set up a spreadsheet with 11 worksheets for keeping scores of 10 different events. Sheets 1-10 are...

I use a sheet to store different modules with start and end time in a table (tab1). In the second sheet (tab2) I want to show all modules sorted in time...

I need create a funtcion and use it in all book, in all sheet. I have the function but I don't know how use it like, =MyFunction() in something...

I need to find a way to write the amount of the numbers contained in a worksheet

I'm trying to develop a sheet that creates six random number from given list of data. I've already found the solution for that but there are some conditions...