Computers & Internet Logo

Related Topics:

Posted on Jul 23, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Disable formulas with in a work sheet of Microsoft exl

Dear Sir,

Pls help me out on "disable existing formulas with in a work book"

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Governor:

An expert whose answer got voted for 20 times.

  • Expert 113 Answers
  • Posted on Jul 24, 2008
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Governor:

An expert whose answer got voted for 20 times.

Joined: Oct 25, 2007
Answers
113
Questions
1
Helped
57537
Points
187

  1. Select the cells with the formulas you want to disable.
  2. You can now either hide the formula by pressing CTRL and ` at the same time, or you can delete the formula by pressing the delet key on your keyboard.
Here's an easy way to select multiple formulas:
  1. Do one of the following:
  2. On the Edit menu, click Go To.
  3. Click Special.
  4. Click Formulas, and then select the check box next to the type of data you want to select.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3helpful
2answers
0helpful
2answers

Why my qeep account is disable

i delated my account. I need help to open my account reagain
0helpful
1answer

Dear sir i unable to print from outlook express IE8. I able to print when i have IE6. pls tell som solution for this problem thanks, keerthi

Try to disable Protected Mode under Internet Options>Security. IE8 has some kind of protection against printing anything you view.

Hope this helps.
0helpful
1answer

Sir i am having problem with internet explorer it gives error as AppName: iexplore.exe AppVer: 6.0.2900.2180 ModName: tb7scr.dll ModVer: 5.7.2.2 Offset: 0014ba56 pls help i have done system restore...

Disable 3rd party browser extensions and then try again.
Disable any toolbars etc...
if no effect try to install Internet Explorer 8.0 or alternate browser like Firefox or Google Chrome
0helpful
1answer

Tools protect workbook& sheet

Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.
0helpful
1answer

Lookup function

i have one date sheet old one another new with some modifications how to share the data from old sheet to new sheet pls tel me with formula and example
0helpful
1answer

Hello..I have just purchased a now printerc4200 .It works great but the printing starts with the last sheet and runs backwards.....What can I do so it prints sheet 1 first instead of ...

on the driver settting or preferences there is an option to collate print out or option to set to printin reverse order, disable that,on the application when you click file print there should be an option to disable print in reverse order

pls dont forget to rate solution, if you have further inquiries feel free
0helpful
1answer

Exel 2003

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.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 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.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.
0helpful
2answers

EXCEL ALL SHORT FORMULA

hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...
Not finding what you are looking for?

565 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...