Welcome Guest!Register Login Contact Us Site Map FAQ

Home

Charcha

Select section:

Microsoft Excel - formula print help needed

Jump to Page:
< Previous [ 1 ] [ 2 ] Next >

Happy
Member since: Aug 03

Posts: 309
Location: INDIA (sometimes Canada)
Post ID: #PID

Posted on: 24-03-09 22:56:08

when we write formulas in some cells it just shows the numbers (calculated data).

I want to see the formulas in the cells and print that sheet with the formulas.

e.g. showing =F4*23, =G5+F5 etc etc..

Can anyone suggest me, how do I do that.

thanks.

-----------------------------------------------------------------
Enjoy Happiness -- Happy from India

ftfl
Member since: Jul 06

Posts: 2335
Location:
Post ID: #PID

Posted on: 25-03-09 00:24:11

Quote:
Originally posted by Happy

when we write formulas in some cells it just shows the numbers (calculated data).

I want to see the formulas in the cells and print that sheet with the formulas.

e.g. showing =F4*23, =G5+F5 etc etc..

Can anyone suggest me, how do I do that.

thanks.

__________________________________________________________

Here is some help : MathMagic XTension 2.6.1 (Mac)
MathMagic provides intuitive and easy-to-use interface to write and edit any mathematical expressions within QuarkXPress documents. In addition, it supports import/export TeX, the professional mathematical markup language, so all kinds of equations can be handled with MathMagic. EPS, PICT, JPEG, GIF, PDF can be easily created with MathMagic. [Math+Magic] provides...
Tags: Apple Macintosh, Equation, MathMagic, Desktop Publishing

And you can explore further here. They will also answer your questions.
http://search.techrepublic.com.com/index.php?q=mathematical+formulae+on+key+board&t=0

There is some software available, that will also provide you with stickers to the computer keyboard, which after adding can be used with the Tab and function buttons and will utilize the computer as a scientific calculator. It will also post it to the screen and will also do the formulae that you are seeking.

Hope this explains a little and gets you going.

Freddie.

vikshr
Member since: Aug 07

Posts: 157
Location:
Post ID: #PID

Posted on: 25-03-09 09:11:54

Quote:
Originally posted by Happy

when we write formulas in some cells it just shows the numbers (calculated data).

I want to see the formulas in the cells and print that sheet with the formulas.

e.g. showing =F4*23, =G5+F5 etc etc..

Can anyone suggest me, how do I do that.

thanks.

TOOLS
OPTIONS
VIEWS
WINDOWS OPTIONS
CHECK FORMULA

You are done !

-----------------------------------------------------------------
Vik

dimple2001
Member since: Apr 04

Posts: 2873
Location: Western Hemisphere
Post ID: #PID

Posted on: 25-03-09 09:25:29

Quote:
Originally posted by vikshr

Quote:
Originally posted by Happy

when we write formulas in some cells it just shows the numbers (calculated data).

I want to see the formulas in the cells and print that sheet with the formulas.

e.g. showing =F4*23, =G5+F5 etc etc..

Can anyone suggest me, how do I do that.

thanks.

TOOLS
OPTIONS
VIEWS
WINDOWS OPTIONS
CHECK FORMULA

You are done !

Vikshr:
Thanks for the tip. I learned something.

I used to type '=F4*20 to make it look like a regular text. But this is much better.

-----------------------------------------------------------------
Dimple2001

hchheda
Member since: Aug 05

Posts: 2245
Location: Woodbridge
Post ID: #PID

Posted on: 25-03-09 09:34:30

Happy,

http://www.mrexcel.com/articles/show-formulas-in-cells.php

Does this work for you?

Trust I understood your question well.

Good luck.
Hiren

vikshr
Member since: Aug 07

Posts: 157
Location:
Post ID: #PID

Posted on: 25-03-09 10:07:03

Quote:
Originally posted by hchheda

Happy,

http://www.mrexcel.com/articles/show-formulas-in-cells.php

Does this work for you?

Trust I understood your question well.

Good luck.
Hiren

Even better !!

-----------------------------------------------------------------
Vik

frnd
Member since: May 07

Posts: 239
Location: GTA
Post ID: #PID

Posted on: 25-03-09 10:49:31

How about this one, Guys?

ctrl + `

(Control key + Key above tab) Don't know what to call `!!

Contributors: Happy(2) vikshr(2) frnd(2) RBO(1) ftfl(1) dimple2001(1) hchheda(1)

Jump to Page: < Previous [ 1 ] [ 2 ] Next >

Show Printable version

Send this page to a friend

Add to favorites

Discussions similar to: Microsoft Excel - formula print help needed
	Topic	Forum	Views	Replies
	Microsoft Clippy helping US President..	Have Fun!	1571	1
	Print C Option and Financial Evaluation for Spouse	Family Class	1206	0
	NOC for Customer Service Representative	Ask Immigration Expert	1174	0
	Q & A : Timepass	Have Fun!	1280	1
	abt U of windsor	Study	2511	5
	PIO Card for Infants ( 1 2 )	Public Services	8863	9
	Tech help needed	Science & Technology	1229	2
	Updates format ?	Ask Immigration Expert	1245	2
	Cord Blood Bank	Health and Wellness	1680	3
	Vista Print Problem	Science & Technology	2002	5
	Java Developers who want to get Canadian Expereience ( 1 2 )	Available	5019	11
	Wanted Accounts tutor for adult student	Study	1762	0
	On the rocks...!!!	Have Fun!	1442	4
	Kismet Konnection DVD Release date?	Filmi Gupshup	1694	4
	printing Big size PDF map	Science & Technology	1058	0
	What is svchost.exe and why is it running?	Science & Technology	1521	3
	Microsoft Excel - formula print help needed ( 1 2 )	Science & Technology	1719	9
	Fingerprint request ( 1 2 3 )	Citizenship	8805	19
	Desi Researchers at McMaster make blood from skin stem cells	Science & Technology	1351	0
	Desi barbershops ( 1 2 )	Life	3380	8
	Mathematical finance program	Study	1603	1
	Saheb Biwi aur Gangster [Spoiler Warning] ( 1 2 3 4 )	Filmi Gupshup	5349	21
	OCI application in BLS Brampton / Toronto ( 1 2 3 ... Last )	General	52782	75
	PAN card photo ( 1 2 )	General	3046	7
	Power point update from Excel	Science & Technology	2755	2

Charcha

Microsoft Excel - formula print help needed

Discussions similar to: Microsoft Excel - formula print help needed