Question about Microsoft EXCEL 2004 for Mac

1 Answer

How can I hide the formula bar in excel for mac (and lock it, so that formulas etc are not visible simply by turning the view formula bar on or off?) I am running office 2004 for mac (cos I want to use macro's_ In excel for windows, you can effectvely lock and hide all the cells from individual viewing - this facility does not seem to be available in the mac versions. I need this as I need to send clients information in spreadsheets, WITHOUT them being able to see/copy the formulas (i.e the intellectual property)

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Microsoft Master
  • 126 Answers

Posted on Jun 03, 2017

Ad

6 Suggested Answers

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

Ad
Conficio
  • 9 Answers

SOURCE: Creating a holiday accrual spreadsheet.

Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Posted on Sep 06, 2007

  • 2 Answers

SOURCE: Excel Formulas

Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.

Posted on Sep 17, 2007

  • 4 Answers

SOURCE: percentage formula

=(Click cell that you want to work out 30% of)*30/100

Posted on Nov 30, 2008

label_chick
  • 407 Answers

SOURCE: VLOOKUP FORMULA PROBLEM

VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Posted on May 22, 2009

label_chick
  • 407 Answers

SOURCE: Using Macros in Excel sheet Requires Programing..

Creating Macros does not require programming. The only suggestion I would make if you are new to macros - break down your task to very small sub tasks, in order to avoid confusion.

Posted on Jun 16, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

3 Answers

Can't see coordinates in Excel Formulas


And this is when you have selected a box and simply type something ?

Dec 28, 2007 | Computers & Internet

1 Answer

Excel 2007


  1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
  2. In the menu bar, go to Format - Cells
  3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
  4. Deselect the small box tagged Locked
  5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
  6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
  7. In the menu bar, go to Format - Cells
  8. In the popup menu that opens, click on the Protection tab
  9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
  10. Click on OK
  11. In the menu bar, go to Tools - Protection - Protect Sheet
  12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
  13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Jun 25, 2009 | Computers & Internet

1 Answer

Vlookup in 2004 excel for mac o/s


First make sure there is an "=" sign at the beginning of the formula.  If there is and the formula still shows in the cell go to Preferences and click View.  Make sure the "Formulas" box under Window Options is not checked.

Jun 04, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

Wanted to learn "ALL" formulas of MS Office Excel - please guide


Ist I want to know what type of formulas u use in works

Jan 13, 2009 | Computers & Internet

6 Answers

EXCEL FORMULA NOT WORKING


No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.
ace3905.gif

Nov 26, 2008 | Microsoft Excel for PC

1 Answer

Print source code of an Access Database


Hello cbw@netzero.com,

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Good luck with your copywrite!

Oct 06, 2008 | Microsoft Office Professional 2007 Full...

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

1 Answer

Excel Coordinates don't show up in Formula Bar


Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Computers & Internet

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

Related Topics:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2851 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

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

Answer questions

Manuals & User Guides

Loading...