On a certain worksheet, whenever I click in a cell, the page jumps back to the beginning. It's only doing this on one worksheet, but I need that worksheet. It's impossible to add new material to it because the page always jumps back to the beginning with each attempt to make an entry. Hope you can help. I'm on a MacBook Pro (2008) running OS 10.5.8. -Steve

Move a page break Important To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.
To verify that drag-and-drop is enabled, do the following:
Click the File tab.

1. Under Help, click Options.
2. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
3. Select the worksheet that you want to modify.
4. On the View tab, in the Workbook Views group, click Page Break Preview.
   1. 
   2. Tip You can also click Page Break Preview on the status bar.
   3. Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.
5. To move a page break, drag the page break to a new location.

Note: Moving an automatic page break changes it to a manual page break.

Delete a manually-inserted page break Note You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.
To delete a manually-inserted page break, do the following:

1. Select the worksheet that you want to modify.
2. On the View tab, in the Workbook Views group, click Page Break Preview.

Tip You can also click Page Break Preview on the status bar.
Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.

1. Do one of the following:
   • To delete a vertical page break, select the column to the right of the page break that you want to delete.
   • To delete a horizontal page break, select the row below the page break that you want to delete.

Note You cannot delete an automatic page break.

Firstly you would need to select all the cells in the worksheet. (Assuming you have the worksheet that needs the change in format already open.)

Click on the rectangle between the row numbers and the column names ( i.e. to the left of the A and above the 1) - Marked as Step 1

Then make sure you have selected the home option on the menu bar you need to click on the bucket like button on the ribbon - Marked as BG Button. This should open the colour drop down thinggy that i added to the right of the image. Select the colour you need in this case for the purple I have marked it as Step 2 the Yellow is step 4.

To select a certain block of cells you need to click on the cell address area ( Step 3) and type the range of cells you need to select i.e. B3:B5 .. in this case its just 3 cells and can be selected manually by just clicking on the first cell and dragging the mouse to the third.

Finally jst as you selected the purple you could select the yellow colour.

Word
Moves cursor to the beginning of the line.
CTRL+HOME moves the cursor to the beginning of the document.

Excel
Moves to the beginning of a row in a worksheet.
Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.
Selects the first command on the menu when a menu or submenu is visible.
CTRL+HOME moves to the beginning of a worksheet.
CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.

MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

Depending on what version of Excel you are using try the following:
The lines are called gridlines

1. Click the worksheet.
   
   
2. On the File menu, click Page Setup, and then click the Sheet tab.
   
   
3. Select the Gridlines check box.

Note Large worksheets print faster if you do not select the Gridlines check box.

Please rate this solution...Thanks

If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

1. Click the cell in which you want to enter the formula.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , type = (equal sign).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.