Excel: Make Some Cells Remain The Same When Pulling It Down?
Oct 11, 2012
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down.Normally it the adds 1 to every cell address, but I need some of them to remain the same while others change. More exact:I'm trying to make excelsheet where one collum is supposed to have the formula:
=F3*Dx/D3
x goes from 3 to eternity, while F3 and D3 should remain static while doing that drag thing. I remember there was a way to mark F3 and D3 so they don't change, but can't remember how.So F4 has F3*D4/D3, F5 has F3*D5/D3 and so fourth.
I have numbers e. g. 1 to 100 in excel in a particular column. If I remove any number e. g. 13 & keep that cell blank. Further cells should get automatically numbered from 13 onwards.
I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect worksheet" and after checking the box that allows people to select cells in the locked section (selection of sells in unlocked section checks automatically) I enter a password twice and the worksheet is theoretically locked.
I can still change cells in the locked area. It didn't work on any of my worksheets. So I went back and unprotected the sheets and then selected and locked the cells TWICE, after which I protected the worksheets again. This time some, but not all, of the worksheets had locked the cells protecting them from editing. I then tried to go thru the same rigmarole but locking the cells three or four times before protecting the sheets for the sheets that were still unlocked, but that only worked sporadically as well. Sometimes I had to dis-allow selection, lock the cells in the sheet, unprotect it, lock the cells again twice, and then check the select box and protect the sheet AGAIN. That FINALLY worked.
Can anyone recommend a clean, free program that will allow me to pull my windows 7 64 bit product key from my registry?I am long overdue for a format/reinstall but can't seem to find my original disk with the label on it.
I admittedly know nothing about computers. My keyboard seems to maybe be in some weird settings where it wont type, will freeze up or certain letters are pulling up certain screens. Like hitting enter make the tools menu drop down or something makes the menu bar with file, edit and such open and the file tab highlights and flashes and freezes every thing and I have to hit esc or enter to unfreeze it, I cant type in the search bar online either, it takes one letter and redirects me to a webpage previously viewed with that letter and wont let me type anything. And also my number one key wont work at all.
I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly).Certain formulas in the spreadsheet are based on values that do not change over time. For example, I assume that my widgets will sell for some unit price and monthly revenue forecasts are calculated as the projected sales volume times the unit price.Here's the problem - let's assume that my sales price changes at some point in time, after sales revenue has been generated. If I simply change the price, which is applied globally, then the historical 'projections' will be wrong.Just to be clear: When the model was first built, it assumed that widgets sell for $100 apiece. Assume that unit sales are the same as the month number. Thus, my revenue for the first six months would be $100, $200, $300, $400, $500, and $600. Assume that for the first three months, I hit my revenue numbers. In this case, the sheet that tracks actuals would show a $0 difference, for each of the first three months, between projected revenue and actual revenue. Since business is doing so well, I decide to increase the price of the widgets to $150 on a forward-going basis. Suddenly, the spreadsheet now shows that I failed to meet projections for the first three months, when, in fact, I did meet them!It seems to me that there should be some way to lock cells in the spreadsheet based on the current date. For example, when I open the spreadsheet in June, I should be able to programmatically protect cells from May and earlier. Is this possible?
Regardless of the interval I set in Power management, the screen always dims at 20 minutes and the machine goes to sleep at 30 minutes. Always, regardless of setting. [Windows 7 Pro 64-bit SP-1]
so i had a couple programs uninstalled from the MS controll panel add/remove and some of them showed a clean uninstall but i still see them on the list and i also see the folders in the program files .the folders still contain a bunch of files. is there a way to officially remove everything ? im not too familier with deleting?
My cursor wont stay as selected in windows mouse pointer configuration settings. It reverts to a gray box with a black border, blue up-down arrow in the upper right corner, and a portion of a finger in the lower right corner. I can't find a cursor file that is associated with this stubborn cursor, and I need to find out what the file is that is associated with this so I can DELETE it.
I recently formatted, and since, my pc refuses to remain in Sleep/Hibernation mode. When I select the option in the start menu, my pc does its thing, once it enters sleep/hibernation, it instantly powers back up. I have changed nothing to my pc's hardware since the format, and this issue never occurred before hand.
Some of the things I have tried are making sure the power management setting were correct. I also hard reset my motherboards cmos to manufacturer settings.
I've had IE9 on this Win7 (64-Bit) computer for a few months now and today when I opened IE9 and tried to go to a few sites, it would remain on the "Downloading" or "Waiting.." in the lower left. After about 5 minutes of so, the page would load. Clicking on the "Back" or "X" wouldn't work. I had to Del/Ctrl/Alt to get out of these pages that were not loading (quickly).
I uninstalled IE9 and IE8 seems to be behaving the same way - very slow loading of sites, AOL, etc. I ran full MSE scan and nothing shows. I installed IE9 again and still same "slowness" getting into all sites! Did the "disable add-ons" thing and that didn't work, either. FF runs fine, so I presume it is something in IE9 (and IE8) that is causing this "slowness, slugishness, etc." for pages ot load/show." I tried IE9 64-bit and same problem! If I wait and wait (maybe several minutes) the page will finally show.
Ive been working on the administrator account for more than 2 years, left it as it was yesterday. When I came back my account was assigned with guest authorization instead of administrator's. While I was working on my administrator account I disabled Super Administrator account and therefore now I am unable to log into it. My little brother account is just another guest account. So as far as I know there are two guests accounts somehow, 0 administrator accounts, and 1 super administrator account which is disabled. How can I restore my account to its previous settings?
I have Windows 7 64 bit and 8 gb ram (the most that the MB will accept. I had a spare 16gb ready boost compatiable USB drive and used it for Ready Boost. Seems a little bit quicker. My question is this: ReabyBoost is addressing 4 GB of the 16gb. I think this is all it is supposed to do. Can I used the remain 12 gb for storage or as a working area for products without compromising Ready boost?
I wanted to use my 180gb ssd as a boot drive and I do not know what to do. I installed windows and some drivers on the hdd but i want to start over and I need some guidance.I am doing a clean install now. once thats done how do i make the ssd the boot drive to make my system scream! also will i need to put drivers on both hdd and ssd?
I have two hdds (500gb 7200rpm) in my laptop and have 260gb of data on the second one. I wanted to create a partition for games at the beggining of the 2nd drive (the left side) as i heard it increased performance to put games in anoher drive and at the beggining of the drive.Will it make difference to make a partition at the beginning or at the end of this drive when it comes to gaming performance?My cousin showed me one game in the same drive installed in the 1st of four partitions of a 500gb 7200rpm (the same i have) performing with 3-5 fps more than that game installed in the 4th partition of that same drive....
Before installing Windows 7 I exported the macro's I use in Excel (Office 2007) and made a copy of the Personal.xlsb file. In Vista, the Personal.xlsb is stored at C:Usersuser nameAppDataLocalMicrosoftExcelXLSTART. I have imported the macros into visual basic but I can only save them into that particular workbook and when I reopen Excel, the macros are not avaliable.
I have a user at the moment who's excel is crashing at random points of the day. This does seem to happen when there are more than about 3 or 4 excel documents open at a time.
I've tried opening in safe mode and that opens fine (although it is a random fault this may not of shown anything...). tried checking com-in add-ins and there are not any installed.
i have an excel doc with about 300 records all in a cell each, i want to get them all in to a specific field on a website in their own tab in firefox. any one know if this can be done?
I have Office 10 and I go to "find" in my excel spreadsheet and I would like to find "shot", "hospital"". "doctor" without doing 3 searches. So can I imput those 3 words and do a search and it will show me each word as they come up?
I just can't get new data to display on this graph (see below):
[URL]
I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you see, the first six sets of values are displaying fine.
to enable macros in Excel I have to go to Developer then enable macro. Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet.
However, now even this doesn't work! Result: I am unable to use my macros.
I love the new taskbar and the "right click" on a pinned programme to access recent files & pinned files. However, while this feature works perfectly for Word, when I try to open an excel file from the taskbar, or even as an attachment to a received e-mail, I get the message " there was a problem sending the command to the program". The excel program itself opens if it is not already open, but the selected file doesn't. I can only open the file by going through "office button/open". If it is an e-mail attachment, I can only open it by saving it to one of my folders, and opening it via "office button/open". Additionally, once I attempt to open an excel file from the taskbar, the excel symbol on the taskbar displays a yellow/brown border instead of the normal border.
I have a completely new Lenovo X120e computer - yes my company bought the best (sarcasm). whenever I try to copy from excel and paste into another program the excel crashes. It just shuts down completely and trys to restart.
I can not find how to use the freezeframe facility on Excel spreadsheets and when I click on 'Help' on the right of the sheet get the following message on a black background; 'Aw Snap' Something went wrong while displaying this page. To continue, reload or go to another page'.
I have done a spreadsheet, I am using the Look Up Function, there are several cells that show th N/A as a result, how do I show these as blanks so I can add them up
I have Microsoft 2003 When I open Excel I HAVE the tool bars (File, View Insert etc) on top where it should be. However the icons I put there from Tools function ie Delete columns, font size, copy, cut etc have all disappeared I tried to reinstalling them by going to Tools � Custom-. When I try to select an icon for example Edit � copy or even delete column arrow and try to move it up to the tool bar on top of the page it will not work.
I'm running Win 7 and have had no problems, but all of a sudden all my desktop applications show with an Excel 2007 icon; same in the task bar. All programs try to open with Excel. I right click and choose properties, change icon, but to no avail. I just downloaded a shareware program and noticed that it also inherited the Excel link.
