Question about Microsoft Computers & Internet

1 Answer

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"

Posted by on

Ad

1 Answer

  • 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

  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.

Posted on Jul 24, 2008

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Why my qeep account is disable


i delated my account. I need help to open my account reagain

Jan 23, 2012 | Computers & Internet

1 Answer

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.

May 03, 2011 | Microsoft Internet Explorer 8

1 Answer

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

Dec 28, 2010 | Microsoft Windows XP Professional

1 Answer

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.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

1 Answer

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

Sep 15, 2008 | Microsoft Excel for PC

1 Answer

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

Apr 07, 2008 | Office Equipment & Supplies

1 Answer

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.

Jan 01, 2008 | Microsoft Office Standard for PC

2 Answers

EXCEL ALL SHORT FORMULA


hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

543 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2932 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18413 Answers

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

Answer questions

Manuals & User Guides

Loading...