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

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

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:

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

WD My Book 1TB, not recognised by XP


Hi,

Appreciate the direct "Ask Me".

A couple of ideas:
  • initially, confirm that it is the PC's USB ports that is the issue by trying the WD on another PC;
  • try plugging in a flashdrive, camera to your PC's USB port;
  • if it has been verified that the WD works in other PCs and that the USB port of your computer works, then it could be a registry entry.
Please open "regedit":
  • go to HKLM\system\currentcontrolset\services\USBstor;
  • check the value of the DWORD "Start" it should be 3;
  • If the DWORD "Start" does not exist, pls create it. Right click, New, DWORD value, Start, Value Data = 3.
Incidentally, there is Microsoft KB about disabled/disabling USB here.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Sep 26, 2008 | Western Digital My Book Essential Edition...

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:

541 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...