Question about Microsoft EXCEL 2004 for Mac

1 Answer

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

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 197 Answers

I have not had that problem befor but you might look at the macro seting if not that then look in the protect work sheet section

Posted on Mar 19, 2011

  • Steven Rice Mar 20, 2011

    Thanks for your response. There are no macros in the sheet and it's not protected. The sheet is still jumping back to the beginning whenever I try to enter data elsewhere in the sheet. I finally was able to get around the problem by copying everything in the sheet and pasting it into a new workbook. Then the new workbook acted normally. I guess I'll never figure out what was wrong with the original sheet. Sometimes computers are so mysterious. -Steve

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to delete Page breaks in Excel


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. za010165475.gif
    2. Tip You can also click Page Break Preview za010181030.gif 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.
za010165475.gif
Tip You can also click Page Break Preview za010181030.gif 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.

Jul 20, 2014 | Microsoft Excel 2010

1 Answer

Excel Spreadsheet Chapter 2


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.1_26_2013_12_31_35_am.jpg

Jan 25, 2013 | YouTube Videos

1 Answer

What is the function of home


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.

Jun 16, 2011 | Microsoft Office Professional 2007 Full...

3 Answers

How can enable mail recipient as attachment excel


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

Apr 11, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Can't print line


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

Mar 24, 2009 | HP Officejet 5610 All-In-One InkJet...

1 Answer

Input data


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.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

1 Answer

LINE 100


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?

Apr 25, 2008 | Computers & Internet

2 Answers

Unsure of correct formula


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

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

Hi friends


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.

Dec 24, 2007 | Microsoft Excel for PC

2 Answers

EXCEL


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...