In Microsoft Excel, how do I repeat a row on only the first 3 pages, not the rest of my worksheet?
106939
to put something say a line you copy from a text file and put it in the same place of sheet 1 to sheet 3, click sheet1 and hold down ctrl click the sheet 2 and 3, place the cursor on A1 and paste, for all 3 sheets you have the same line on A1\n\nif you want to link the 3 sheets with the same data, say A1 on sheet 2 and 3 will change as A1 on sheet 1 change, then put =Sheet1!$A$1 on A1 of Sheet 2 and 3.\n\nhope this will help.
944170
=HYPERLINK("http://"&A1)\n\nCopy this formula down alongside the column where you non-linked URLs are. (obviously change the A1 in the formula to be the appropriate cell reference for your first URL)\n\nYou can then Copy | Paste Special... | Values to eliminate the formulas.
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
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.
130234
Insert a break (section Break)\n\nthen go to Insert page numbers and click on the format button. unclick continue from previous section, and click on "start at" and type 1 in the box
903933
2 ways you can do it, maybe 3. fastest would be type the first 3 numbers in a row, like A1=60000 A2=60001 A3=60002 then select those 3 numbers and put your mouse at the bottom right corner of the selection and (there should be a small black box there) and the cursor should look like a + then click/hold mouse and drag down 500 rows and it will auto increment. other way would be to write a macro.
1005550
Use excel, somewhat easy and really organized
649904
click on print, and where is says pages click on the options where is says 'page range' then just enter the number 3. easy!! - this is on windows mind you; i'm not sure what a Mac is like
861985
********************************************\n\nI have Office 2000, so these instructions may or may not be the same for your version.\nThe easiest way for me is to first know how many rows and columns I need. Then I right click and hold the button down while moving the mouse over the rows and columns I want included in the table. For example: If i want a table that is 4 columns wide, I would select A through D. Then, while still holding the right click down, I select the rows that I want. If I want 10 rows down, I select 1 through 10. After they are all selected in blue, I release the right button on the mouse. The rows and columns selected should remain highlighted.\n\nNext at the top of the page there should be a grid of squares button to select. If there isn't, you can find the little arrows button to find more buttons. It will be in there. Click it or the little arrow pointing down beside it for more selections. This will give you a grid and different types of line thicknesses.\n\nIf you can't find it this way, then after highlighting the areas you want included, right click again in the middle of a highlighted square and another window will open. Click 'Format Cells' in the box that opens. Next click the 'Border' tab. Then choose the formatting you want. You can do this more than once to get more than one effect on your table.\n\nIf none of this is what you want to do, then go to Microsoft Templates at this link: http://office.microsoft.com/en-us/templates/default.aspx\nThere are as many templates there as there are hours that you have to look through them. You can do a search for the specific type of table you want. After you download the template (these are small files) you can customize it how you want it after you open it.\n\nHope this helps. Good luck.\n\n****************************************************
626387
You have three options:\n\n1) resize fonts, graphics, margins, et cetera.\n\n2) use larger paper.\n\n3) insert page breaks where you need to advance to another page (CTRL + ENTER), although I can't imagine why Word would not automatically go to the next page!
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.
1072460
Paste this macro into VBA\n(The >s represent tabs, please replace them. Tabs are really just for aesthetics, but help in macro troubleshooting)\n\nSub Del_Mt_Rows()\nDim lastRow As Long\nDim r As Long\n>lastRow = ActiveSheet.UsedRange.Row - 1 + _\n>>ActiveSheet.UsedRange.Rows.C...\n>Application.ScreenUpdating = False\n>For r = lastRow To 1 Step -1\n>>If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete\n>Next r\nEnd Sub\n\nThen just run the macro and it will remove empty rows
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.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
720639
You may want to switch between shared and protected workbooks. Go to your Excel's Help and see the difference between the two. It will also help you set the workbook up how you want it.\n\nSHARED-   If you want several users to work in the same workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data, insert rows and columns, add and change formulas, and change formatting. How to set up a shared workbook.\n\nLimit viewing and editing of an individual worksheet\nWhen you protect the worksheet, the cells and graphic objects that you did not unlock in steps 2 and 3 are protected and cannot be changed.\n\nPROTECTED SHEETS-\nSwitch to the worksheet you want to protect.\n\nUnlock any cells that you want to be able to change after you protect the worksheet.
1118432
Scroll until you get just the header rows at the top of the sheet (they should be there anyhow). Drag the little bar just above the top arrow on the vertical scroll bar for the workbook, down to below the header rows (the "splitter"). You should now see the header rows, then a thin divider line (the splitter bar) and the rest of your document below that. Now, go to the Window menu and select 'Freeze panes'. Voila!\n\nTo undo this, just go Window->Unfreeze panes.
627836
Well, Start a new Excel work sheet. In the main menu go to the tab "View". Click it. You find the following two items in the pull down menu: \n1.   Normal\n2.  Page Break Preview\n3.  ....\n4.  ....\n\nYou have, most probably, already clicked "Page Break Preview". This is basically designed for advance user and facilitates them how their work shall appear when printed. This does not show grids between columns and rows.\nClick the "Normal". The grids in light gray color shall appear!\nEnjoy !!!