Calgarypuck Forums - The Unofficial Calgary Flames Fan Community

Go Back   Calgarypuck Forums - The Unofficial Calgary Flames Fan Community > Main Forums > The Off Topic Forum > Tech Talk
Register Forum Rules FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Search this Thread
Old 03-07-2008, 01:34 PM   #1
iggypop
Powerplay Quarterback
 
iggypop's Avatar
 
Join Date: Apr 2006
Exp:
Default Excel help

Im trying to print off a sheet within excel, but I don't want the totals to be show, but rather the calculations instead. I know it's possible to do but I can't figure out how. Oh I'm using a mac, but any instruction will be helpful. TIA
iggypop is offline   Reply With Quote
Old 03-07-2008, 01:52 PM   #2
llama64
First Line Centre
 
llama64's Avatar
 
Join Date: Nov 2006
Location: /dev/null
Exp:
Default

Select the area you want to print, then under the "File" menu select "Set Print Area".

Is that what you're looking for?

...

err wait. You want the exact formulas to print?

I found this:
To print Excel Formulas:
1. click 'Tools' menu, then 'Options' option, then the 'View' tab.
2. click on the 'Formulas' option (under Window Options section) then click OK
- see formulas.
3. click on 'File' menu then 'Print' option, then OK.

Last edited by llama64; 03-07-2008 at 01:55 PM.
llama64 is offline   Reply With Quote
Old 03-07-2008, 01:53 PM   #3
REDVAN
Franchise Player
 
REDVAN's Avatar
 
Join Date: Mar 2004
Location: Calgary
Exp:
Default

You want the calculations to show, but not the actual answer? I have needed this over the years but never known what to do.
__________________
REDVAN!
REDVAN is offline   Reply With Quote
Old 03-07-2008, 01:53 PM   #4
TurnedTheCorner
Lifetime Suspension
 
TurnedTheCorner's Avatar
 
Join Date: Nov 2003
Exp:
Default

Under Tools --> Options, choose the View tab and tick off 'Formulas'. The formulas should now show instead of the calculated values, and the print should reflect this.
TurnedTheCorner is offline   Reply With Quote
Old 03-07-2008, 11:52 PM   #5
iggypop
Powerplay Quarterback
 
iggypop's Avatar
 
Join Date: Apr 2006
Exp:
Default

Thanks guys. This worked once I transferred my file to my PC, but the mac version doesn't have an Options under Tools. Kinda odd, oh well.
iggypop is offline   Reply With Quote
Old 03-09-2008, 06:54 PM   #6
Rathji
Franchise Player
 
Rathji's Avatar
 
Join Date: Nov 2006
Location: Supporting Urban Sprawl
Exp:
Default

People who use macs are too cool for a spreadsheet.
__________________
"Wake up, Luigi! The only time plumbers sleep on the job is when we're working by the hour."
Rathji is offline   Reply With Quote
Old 03-10-2008, 08:54 AM   #7
llama64
First Line Centre
 
llama64's Avatar
 
Join Date: Nov 2006
Location: /dev/null
Exp:
Default

Quote:
Originally Posted by iggypop View Post
Thanks guys. This worked once I transferred my file to my PC, but the mac version doesn't have an Options under Tools. Kinda odd, oh well.
Whoops, should have Mac'ified my original post. It's under the Excel menu as "Preferences".

Once you click on that, select "View" and you should see an option for this. This is based on the Excel 2008 for Mac, so earlier versions might be a bit different.
llama64 is offline   Reply With Quote
Old 03-10-2008, 11:05 AM   #8
Flames89
First Line Centre
 
Flames89's Avatar
 
Join Date: Aug 2003
Location: Toronto, ON
Exp:
Default

Ctrl + ~

? i think?
Flames89 is offline   Reply With Quote
Old 03-10-2008, 11:48 AM   #9
llama64
First Line Centre
 
llama64's Avatar
 
Join Date: Nov 2006
Location: /dev/null
Exp:
Default

Quote:
Originally Posted by Flames89 View Post
Ctrl + ~

? i think?

Awesome, works for me on my Mac. I assume it works for Windows versions as well.
llama64 is offline   Reply With Quote
Old 03-11-2008, 01:21 AM   #10
iggypop
Powerplay Quarterback
 
iggypop's Avatar
 
Join Date: Apr 2006
Exp:
Default

Quote:
Originally Posted by Rathji View Post
People who use macs are too cool for a spreadsheet.
Not to cool, too creative! Luckily my mac allows me to creatively make spread sheets, write emails, and surf the internet!
iggypop is offline   Reply With Quote
Old 03-11-2008, 09:21 PM   #11
llama64
First Line Centre
 
llama64's Avatar
 
Join Date: Nov 2006
Location: /dev/null
Exp:
Default

Quote:
Originally Posted by iggypop View Post
Not to cool, too creative! Luckily my mac allows me to creatively make spread sheets, write emails, and surf the internet!
Apparently: http://www.gamasutra.com/view/featur...ionary_3d_.php
llama64 is offline   Reply With Quote
Old 04-29-2010, 10:23 AM   #12
Bean
Scoring Winger
 
Join Date: May 2004
Exp:
Default

Searched Google and CP and couldn't find a suitable answer.

Does anybody out there know of a free program to recover passwords to open *.xls files?

Many of the 'free' programs limit to only 3 characters.

Help please! (and thank you in advance)
Bean is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 03:57 PM.

Calgary Flames
2024-25




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2021 | See Our Privacy Policy