Using MS Excel, how do I lock all the rows and columns so I can sort columns without mixing up the data?
90555
Click on the little grey cell in the upper left corner of the workbook.  This will select all columns and rows.\n\nControl-A does the same thing
1121474
Well there are a few ways.... the easiest way is.........\n\nLets say you want to get rid of everything in row 5, you can move your mouse over the letter 5 at the very left and highlight that row by left clicking once, then right click your mouse and select delete. This however will only delete information you entered like letters or numbers. If you applied any borders or the like you will need to highlight the row as stated above, right click and go to "Format cells" then to the  borders tab and choose "none".\n\nThis will work for deleting entire columns also.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
36375
Here are a few. Obviously, mark every cell with its possibilities. Once new information is found eliminate that # from both the row, column, and section - often times people forget the section. 1) Look for singulars by row and column. Check if there is only one cell that contains the possibility of #, and therefore by default must be that #. This generally reveals nothing early on but may be necessary when you're gridlocked. 2) Look for pairs. For example, if you had 3 cells left in a row and they had the possibilities {237, 37, 37, 2468, 12} you immediately know that the first cell must be 2. Huh? Yeah, because the pair of 37's requires that they be either a 3 or a 7 and therefore you know that the cell that can only be a 237 must be the 2. This works within a section and within rows and columns. This can work with triples but if you have triples of triples you generally have too much unknown. 3) Look within the section and rows. This is hard to explain but let's say that you need a 5 in two out of the three cells in each section of a row. Let's say that the first section you know needs a 5 in one of those two cells, then by default you can eliminate the 5's in all of the other cells in that row because you know that the 5 must be in the first section. Not a very good explanation and it might be redundant, but I already typed it so I won't delete it. Good luck.
283027
Click on the "Favorites" to open them and then use drag and drop to move the items around. Clicking the Organize button at the top of the column works well too.\nGood Luck!
1059707
As much as I know about Excel, I have never seen the ability to do that. Your best bet would be to Merge multiple Cells in 25-50. This is about the only way to get the desired effect but it isn't exactly what you want to do I am guessing.
659348
next to insert table button on the standard toolbar you have insert microsoft excel sheet button. click and drag the number of rows and columns you need.
626155
Use a flat database file format. One unique value in one column and the rest is employee data. All the data in a contiguous range. This way you can use pivot tables, auto filters, etc. to analyze data.\n\nI would suggest you use the latest version of Excel. Excel 2000 has a limit of 65,536 rows and 256 columns but Excel 2006 (out later this year...MAYBE) has 1,000,000 rows and 16,0000 columns.
881302
Obviously depends on what you're using it for.  Some easy ones:\n\n* Formula updates - can do hours of manual calculations for you automatically in a second, and redo them if a base value changes.\n\n* Sorting - can be sorted on one or more columns, allowing you to easily rank data or create an alphabetical list.\n\n* Cut/Paste - changes/additions/deletions are all relatively painless, whereas on paper they might make you redo the entire thing.
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. :)
135478
This is cool.  Use the Print Area function.  From File menu, choose Print Area.  Choose to clear it, first of all.  Then highlight all the portions of your spreadsheet that you wish to print.  \n\nYou can highlight sections that are not next to each other (noncontiguous) by using the CTRL key while blocking w/the mouse.  So, for example, use the mouse to highlight columns A and B.  Let go of the mouse button and see that those areas are highlighted. Without doing anything more (don't click anywhere, don't use an arrow key, etc.), press down the CTRL key and then click on column D. You will then see that columns A,B and D are highlighted (but not C).  You can choose your own print area in this fashion.  \n\nAfter you've gotten your print area highlighted, go to the File menu, choose Print Area, and choose Set Print Area.  Now only the things that were highlighted are going to print.  You can see this on the print preview screen. \n\nEnjoy!
665008
you can't sort tabs unless you move them manually
460847
to do something like that in word you would have to convert the text into a table (found under the table menu) then sort the table (sort is also found in the table menu)
494290
Yes, this is possible, except the idea is a little backward. Instead of protecting one column, you will actually be protecting the entire sheet and making all other columns editable.\n\nTo do this, identify the cells you want to editable. So let's say you wanted to protect column C. You would want columns A:B,D:IV editable.\n\nIn the menu go to Tools > Protection > Allow Users to Edit Ranges.\n\nA box pops up. Click the "New" button. This will allow you to specify the range of cells you want to leave editable. So in our case, in the "Refers to Cells" box, you would type in: =A:B,D:IV\nAnd then click OK. Excel will automatically add dollar signs to 'lock in' the range.\n\nNow click "Apply" button. Then click the "Protect Sheet..." button. Another pop-up will show asking for you to enter a password. Once you complete that, all the cells in the "editable" range will still be free to edit. The cells in the protected column will be locked.\n\nNote: Depending on the check boxes you select in the "protect sheet..." box, the user may or may not be able to add or delete columns. If you want to grant the user this functionality, you must activate those check boxes.
631376
I can help you with this question only If you submit more info.  Mean while try Consolidate function in the data menu, you have to have a blank worksheet and it will consolidate all pages in the blank one.
221896
There's an easy way to do this. I've given you some very basic code.\n\nCopy and past this code into your VBA code under the same sheet as your data. (Press ALT-F11 to get to the VB editor and double click the sheet name of the tab you are working on).\n\nSub SortText()\n    LookRow = 2\n    PutRow = 2\n    txtCounter = 1\n    Do\n        txtColor = Cells(LookRow, 1)\n        If txtColor = "" Then Exit Do\n        txtSize = Cells(LookRow, 2)\n        txtRange = Cells(LookRow, 3)\n        Cells(PutRow, 5) = "Trial #" & txtCounter\n        Cells(PutRow + 1, 5) = "Color " & txtColor\n        Cells(PutRow + 2, 5) = "Size " & txtSize\n        Cells(PutRow + 3, 5) = "Range " & txtRange\n        PutRow = PutRow + 5\n        LookRow = LookRow + 1\n    Loop\nEnd Sub\n\n\nWhen you run the macro it will take the data and arrange it into the columns you wish. Be aware that it will paste the data into column E of the same page and will overwrite anything you have there, so backup your data first.\n\nYou can also assign this to a shortcut-key with Tools>Macro>Macros... You will need your security set to Medium for this to work.\n\nIf you wish the data to be saved on a seperate page, please email me at wabbitt1970 @ hotmail.com
646340
To completely automate the deletion of duplicates you have to code (not record) a macro. However, with some manual intervention you can do it without any code.\n\nThese methods assume your data is in one or many columns of contiguus data with a label in the first row)\n\nMethod 1 (more manual)\nSort your data\nScan for the dups and delete the rows\n\nMethod 2 (less manual)\nClick anywhere in the data you are working on\nGo to Data, Filter, Advanced Filter\nIn this new window select the following:\n Copy list to another location\n Your list range should already be selected\n Click in Copy To and select a destination cell\n Click Unique Records Only\n Click OK