Question about Microsoft Excel for PC

2 Answers

How do I get the calculate button to work on my spreadsheet. My fomulas dont work or update. The spread sheet is not protected.

Posted by on

Ad

2 Answers

  • 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.

    Teacher:

    An expert who has written 2 tips or uploaded 1 video tip.

  • Expert
  • 98 Answers

Normally excel should automaticallly update the values on the spreadsheet. However, in certain cases when it doesn't work, you can use the manual update key which is the "F9" key on the keyboard.

Hope this answer your question.

Posted on Aug 19, 2010

Ad
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 12 Answers

In excel, go to tools - options - under calculation make sure that you have selected 'Automatic'.

Posted on Sep 11, 2010

Ad

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 do I pull a figure from a spread sheet and add it to another in the same file.....


Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

1 Answer

Add information to grayed columns


any greyed out area is a non accessible are
either the spread sheet your are using is not advanced enough or that area is read only requiring an administrator's authority to access it
suspect that it is read only and is not for editing
if you go google and type in -- user manual for excel spread sheet-- there is a pdf version ( around 900 pages ) which has everything you need to know for excel spreadsheets
a good publication if you spend lots of time in excel as it misses nothing

May 11, 2017 | Savy Soda iSpreadsheet Free

1 Answer

Release the scroll key


    • 1 Open and power on the laptop.
    • 2 Wait for the laptop to fully boot.
    • 3 Locate the "Scroll" button at the top-left of the keyboard. It is under the volume panel and between the "F12" and "Pause" keys.
    • 4 Press the "Scroll" button.
    • 5 Test it by opening a spreadsheet and using the arrow keys to move around on it. You can open your Microsoft Excel program or create a spreadsheet online by using Google Docs (free online productivity software). The "Scroll Lock" function will keep the current cell selected while the screen moves.
    • 6 Press "Scroll Lock" again to turn it off.

Apr 17, 2012 | Logitech Cordless Desktop MX3200 Keyboard...

1 Answer

Specify that selected cells will be locked when the protect sheet feature is turned on


Basically this means that in Excel, you can protect your spreadsheet, making other users unable to edit certain cells on your sheet.
This is useful for advanced or complex spread sheets, where you have cells you don't want users to mess with.

Mar 14, 2011 | Computers & Internet

1 Answer

Excel 2007 Toolbar


Use "drag and drop". Move the toolbar into the other toolbar if exists.

Nov 05, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Average handle time


I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

EXCEL


I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

215 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2780 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

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

Answer questions

Manuals & User Guides

Loading...