Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   copy with format I have a sheet with various formattings (background and text colored, large and small texts, borders etc.). When I copy and paste it into another sheet I get the text only and all formattings are lost. Paste special has only text and unicode. Is there any way to copy everything? Thanks Horst... 16 25.09.2006 13:19:29 sum a cell value over 75 Please help!! Excel beginner! I need to build a formula that will add any remaining value over 75 in a cell. For example: In cell A1 = 76.5 In cell A2 - I need a formula that will sum anything over 75 and enter 1.5 into cell A2. Thanks in advance for everyone's help!!... 8 25.09.2006 01:45:52 unlimited how do i set a cell to unlimited characters? so i can enter more than 1024 charaters in (i need to enter about 5000 characters in one cell) Thank you -- please can you help... its urgent... 2 25.09.2006 01:04:11 move between pages with out scrolling I am currently using a 20 page spread sheet and i am new to this the only way i can move from one page to another is to scrool down through the pages is there a way to type in a page number a cell number or even the arrows that move you through the program easier any help would be very helpful... 3 24.09.2006 23:52:08 how do I sort a worksheet based on one column? how do I sort a worksheet based on one column? How di I input a - into a text field ... 2 24.09.2006 18:08:53 New Balloon - VBA New to this I have followed the instruction to set up an help balloon, copied and pasted the example into my module box but it does not work. I do not really know where to start. I go into VBA and then Help am I supposed to do something else Thanks john -- JohnM... 4 24.09.2006 17:56:01 how do i roll dates forward in excel i am trying to create a workbook with 13 worksheets (1 for each of my 28-day pay periods). i have made the first sheet with the dates of my regular transactions etc, is it possible when creating the next sheet to have the dates roll forward by 28 days automatically. i hope i have explained myself clearly thanks Dave... 5 24.09.2006 04:13:01 Defining cell with only through 1 - 32 Hi All I want to define all the cells where the integer only goes to 32. Meaning when I enter in A1 167.700.25 and A2 152.30 and I want to subtract A1-A2 = 7.70 where the inetger goes to 100. I my case I want it to go only to 32.(1/32) Meaning if A1 110.15(.15 should be formated as actually .15*32= 0.048) so instead of 110.15 I want the cell formated so I can input 110.15 and it ... 3 23.09.2006 22:49:01 how do I make the cell expand to fit my text as I type? I merged some cells across the width of a spreadsheet and i can't get the cell to increase it's height as more text is typed in wraps around.... 3 23.09.2006 17:39:46 vba problem All Using formula to check date in a cell when opening workbook. Nb: A1 = today() if prior to 01/11/2006 ok no changes if equal to or after the 01/11/2006 then not ok and hide all sheets bar one called contact. It only works if exact match i.e. if date on sheet is 01/11/2006 If Sheets("Menu").Range("A1") = "01/11/2006" Then hide sheets and reveal contact The equal sign = being t... 6 23.09.2006 16:28:04 writing information but not having it look like a table? Hello. at the end of theis table I want to write info on how to complete a task. I don't want it to look like it is in the table. How do I go about accomplishing this? ... 5 23.09.2006 16:11:41 how to edit cell how to minimze cell in access... 2 23.09.2006 12:07:01 MS Excel formula How can I fill color in one cell related to another cell values. For example: If 10>A1>0, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I want to use this in a maintenance worksheet.... 3 23.09.2006 06:40:27 tools menu not working In excel, I am trying to use my tools tab but when I run my mousr over it i get a blue square and no commands. Any help would be appreciated... 1 23.09.2006 01:37:01 hyperlinks - macro not working to take them off the sheet I asked a question earlier, and the answer was to make a macro This explains what you need to do: http://www.techonthenet.com/excel/macros/delete_hl.php Basically you have to create a macro to remove all hyperlinks at once. The link provides detailed instructions on how to do it. If you get stuck just post another question and someone can walk you through it. Answer: You will ne... 2 23.09.2006 01:18:01 Sliding Scale Percentage via IF? Hello all, I'm trying to do a formula for a sliding scale percentage fee, for which it references the item price of an object. Ie: First $25.00 = 10%, $25.01-100 = 10% of first $25 + 7% of remaining price, $100.01-1000 = 10% of first $25, 7% of first $25.01-100, and 5% of remaining price, etc. However! The formula I cobbled together won't debug correctly - it works up to the 7% rang... 5 22.09.2006 22:58:15 data entry and saves it to sheet 2 Basically I need a simpler data entry with submit button and saves it on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as: Account Number, Company Name, Product, etc. after entering those fields I would just hit 'submit' or 'enter' then it says on Sheet 2. I really would like to impress my boss... so your help is much appreciated. :) than... 2 22.09.2006 22:40:36 Calendar day not days I am trying to figure a way in which I can add a specified number of calendar days to a date (ex: 9/21/2006 + 14 days = Calendar date). I thought it would be an easy thing to do, but when I try what is on MS help, I get the total days from 1 Jan 1900 and can't figure out how to convert it to the calendar day. Can anyone help out in figuring this formula out. Dan (Still going in circles)... 3 22.09.2006 22:16:05 data entry and saves it to sheet 2 Basically I need a simpler data entry with submit button and saves it on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as: Account Number, Company Name, Product, etc. after entering those fields I would just hit 'submit' or 'enter' then it says on Sheet 2. I really would like to impress my boss... so your help is much appreciated. :) than... 2 22.09.2006 21:21:02 Excel - Validation I'm trying to create a "drop down list" but don't know how to validate, define and/or create a source box. Trying to follow the instructions using the "help" featur, but I'm still confused. Thanks!... 2 22.09.2006 20:52:45 Apologies for triple post Sorry about the triple post - I was having trouble with usenet. Janev... 3 22.09.2006 19:56:43 I want to print labels from my excel document I think that my original document on excel is not set up right. When i go to Microsoft word to do mail merge wizard, my information to print labels is not showing up. Can anyone help me?... 2 22.09.2006 19:49:31 how do you make the cursor position have a color ? I am trying to be able to locate when my cursor is located in a spradsheet easier by coloring the highlighted cell it is at. How do I accomplish this?... 2 22.09.2006 19:15:28 Can someone without Excel open a worksheet? I was sent an Excel worksheet, and told there is a way to open this file without having Excel installed on my machine. This worksheet contains calculation formulas, so I'm wondering if a) I can get the file open somehow without buying Excel and b) if there is a way to open the file, will I be able to use the formulas and update the worksheet?... 2 22.09.2006 18:02:16 Explanation of formula components? I am a relative beginner when it comes to Excel; is there a glossary of any kind that breaks down the specific components of formulas so I can gain a better understanding of how to construct them? Thanks very much!... 2 22.09.2006 17:14:02 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>