On Excel, how do I freeze a cell heading so it can scroll down with the screen?
116902
Select cell below the heading, preferably the first column, and choose freeze panes from the windows menu.
598149
If you have a scroll mouse then hold control down and scroll downwards whilst your cursor is above text.
317426
Don't understand.\n If you want to move it to top or either side?\n Put curser over task bar. Left click and hold. Drag it to the side or top. Release left button.
630142
Set up a loop like this:\n\nExitFlag=false\nDo\n   Range("B8") = Format(Now(), "HH:MM:SS")\n   DoEvents\nLoop Until ExitFlag=true\n\nThe point of my variable ExitFlag is that you might want to break out of this loop at some point.  You could set this variable in a macro for pushing a Cancel button - if needed.  You don't have to have it though, you could just use Do... Loop\n\n(A more efficient way is to link this to some kind of system timer event, but I don't know how to do that in Excel.)
879236
First, I don't think you should be using Excel. Excel is a spreadsheet program that is designed to work as one.  It is not meant to work with large amounts of text.  Excel will only allow 255 characters into a cell, regardless of how large it is.  Even if you manage to cut and paste into the cell, it will automatically trunkate at the 256th character.  If you are putting multiple paragraphs into each cell, I ask you why?  If you are going for the look, you can use Word and make a table.  The characters are unlimited in a Word table, so your formatting should come right it, without trunkating your hard work.  \n\nIf you must use Excel, the key to getting a forced (ie paragraph seperation) you should press and hold the Alt key while pressing the Enter key.  This will force a line break into the cell.  You should also change the wrapping of your cells by highlighting the cells and choosing Format, Cells, and on the Alignment tab- check the Wrapping box.\n\nI highly recommend using Word in a table format.  You can make it look exactly like an Excel printout, but will not run into the problems of the character limit.
658400
Scroll Lock is a toggle function key like the Num Lock key, meaning it is either on or off, like a light switch.\n\nIt is intended to stop the scrolling of text in a program, or in some cases stop a routine within a program(a set of instructions that are being run by a program).  It is a rather antiquated key that for whatever reason has never been phased out of the keyboard.  Few progams actually utilize the effect of scroll lock being on.\n\nOne example of a program that does still have a use for scroll lock is MS Excel.  In Excel, you may wish to look at a different part of a spreadsheet without actually moving from your current position.  Placing the scrool lock "on" will lock the position of the spreadsheet curser, but allow you to use the arrow keys to move around within the sheet and look at other areas.  Pesonally, I never use this feature, and I use Excel alot.\n\nI suppose folks who still work with old payroll programs or work extensivly in data processing or financial progams probably make use of the key a bit.  But the average user like you and I will likely never need it.\n\nBottomline don't fear the key, it will not blow-up your computer.  Just know that it is an extra key left over from the early days of computing, that still has a "few" tricks up its sleeve, so nobody is ready to get rid of it yet.\n\nI hope this enlightened you.
125876
Simple: Open the sheet you want to lock --> select the Tools menu --> select Protection --> click "Protect Sheet..." --> enter a password --> in the list box labeled "Allow all users of this worksheet to:", check the box labeled "Format cells".\n\nNote: I am doing this in Excel 2003; it is possible that it is done differently in other versions, but it is probably a very similar--if not identical--process.
930016
Right click on that cell and go to Format Cells.  Now, go to the Alignment tab and check the box that says "Wrap Text"
1070116
hold control and scroll the scroll wheel on your mouse down
341996
For the alphabetizing, use "filters".\n\n1) Add a row to the top of your spreadsheet (it will be row one)\n2) Label each column (i.e. Title, Author, Publisher)\n3) Select that top row.\n4) Go to the Bar menu and select "Data", then "Filter", then "AutoFilter".\nWhat this will do is add a pull down select box for each column.\n5) The pull down select box will allow you to alphabetize each item in the column.  You could do all sorts of data sorting.\n\nAs for symbols, I may be doing it the hard way, but I copy/paste from word into the cells.\n\nGood luck. :)
15882
go to view -> text size and pick your choice or you can press the ctrl key and scroll wheel on your mouse and move it down.
393718
It sounds like you are using Excel as a form template of sorts.  I gather that your goal here is to prevent people from entering endless text answers, and instead keep their replies brief.\n\nWhat you may need to do is limit the text answers to a certain number of characters, rather than words.  If you select the cell that will hold the text answer, and go on the menu to Data > Validation, then under the Settings tab, select text length.\n\nSet this to some value like 1000 characters, and you will get the result you seek.  Also you can adjust the error message that the user will see in here.\n\nIn old versions of Excel there was a frequent limit of 255 characters in a cell.  As long as you have a recent version (such as Excel 2003) you will be able to store and save worksheets with more than 255 characters.  However if you attempt to copy the entire worksheet you will receive a truncation warning.  To get around this, just copy and paste the individual cells, and the Excel will let you get away with it.
106988
try this \nopen microsot excel, and use the arrows to move, you'll see that the pointer will move one cell at a time.\n\nnow turn the scroll lock on, and try again, you'll see that the page moves up and down.. and so on
827910
Go to View - Text size and choose Normal\nor\nHold down CTRL key and scroll.
685919
go up to View - text size\n\nor hold Ctrl and scroll the wheel on your mouse
1177830
You have to put this if condition\n\ngoto b1 cell and put this formula =if(a1="ON",1,if(a1="OFF",0,"EMPTY"))\n\nif you can't read full formula please move your mouse pointer over it. then it will be displayed full.\n\nso when you put ON in a1 cell, that will display 1 and when you put OFF b1 cell will display   0   if a1 cell remains empty, then b1 will display "EMPTY"
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.