Click to go to Forum Home Click to go to maXbimmer Home

Go Back   maXbimmer Forums > Misc > Off-topic
User Name
Password


Welcome to Maxbimmer.com!

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

Reply
 
Thread Tools Rate Thread Display Modes
Old 10-20-2008, 02:35 AM   #1
El Gato Liso
6th Gear Member
 
El Gato Liso's Avatar
 
Join Date: May 2007
Location: Brampton
Posts: 3,223
Microsoft Excel



__________________
R.I.P. E30
El Gato Liso is offline   Reply With Quote
Old 10-20-2008, 03:04 AM   #2
ZHP_Bimmer05
Photographer/DJ/Engineer
 
Join Date: Mar 2007
Location: Brampton
Posts: 2,166
Send a message via MSN to ZHP_Bimmer05
do u hate it? or need it?
__________________

2004 Mazda RX8 GT: 6spd VR
ZHP_Bimmer05 is offline   Reply With Quote
Old 10-20-2008, 03:22 AM   #3
Boots R
Boots, not boost
 
Boots R's Avatar
 
Join Date: Jun 2006
Location: Brampton
Posts: 10,958
cool thread, martha stewart.
Boots R is offline   Reply With Quote
Old 10-20-2008, 08:16 AM   #4
Trouble65
6th Gear Member
 
Join Date: Aug 2008
Location: Niagara Region
Posts: 1,796
I love it.
Trouble65 is offline   Reply With Quote
Old 10-20-2008, 09:26 AM   #5
T.Dot_E30
Classifieds Moderator
 
T.Dot_E30's Avatar
 
Join Date: Apr 2003
Location: T.Dot / FL
Posts: 9,772
95% of the ppl i come across, don't know how to use excel properly.
__________________
T.Dot_E30 is offline   Reply With Quote
Old 10-20-2008, 09:29 AM   #6
Trouble65
6th Gear Member
 
Join Date: Aug 2008
Location: Niagara Region
Posts: 1,796
Quote:
Originally Posted by T.Dot_E30 View Post
95% of the ppl i come across, don't know how to use excel properly.
I agree. Once you learn how to use it it's great.
Trouble65 is offline   Reply With Quote
Old 10-20-2008, 09:46 AM   #7
Boots R
Boots, not boost
 
Boots R's Avatar
 
Join Date: Jun 2006
Location: Brampton
Posts: 10,958
Quote:
Originally Posted by T.Dot_E30 View Post
95% of the ppl i come across, don't know how to use excel properly.
Is there any way I can figure out what units of measure Excel measures it's columns and rows in? Is there any way to change the unit of measure? Stupid excel only shows the number.

I want to use excel for a template, but I need units of measure. halp!

Boots R is offline   Reply With Quote
Old 10-20-2008, 09:52 AM   #8
Blades
Your opinion is to long
 
Blades's Avatar
 
Join Date: Feb 2005
Location: Mississauga
Posts: 5,365
Quote:
Originally Posted by T.Dot_E30 View Post
95% of the ppl i come across, don't know how to use excel properly.
of those 5% that do .. 2% use it over extensively to the point they should be using a database like access but instead they want to have there 1 gig spreadsheets
__________________
-=[ BL/\DES ]=-



All it takes is one bad day to reduce the sanest man alive to lunacy. Thats how far the world is from where i am. just one bad day. - Unknown
Blades is offline   Reply With Quote
Old 10-20-2008, 09:59 AM   #9
BMRbudz
1st Gear Newbie
 
BMRbudz's Avatar
 
Join Date: May 2008
Location: Mississauga
Posts: 23
Unlike Microsoft Word, Excel does not provide a horizontal or vertical ruler, and there is no quick way to measure the width or height of a worksheet in inches. Excel uses characters, points, and pixels as units of measurement.

try this: http://office.microsoft.com/en-us/ex...517241033.aspx

18 points = 24 pixels = 0.25 inch
BMRbudz is offline   Reply With Quote
Old 10-20-2008, 10:00 AM   #10
T.Dot_E30
Classifieds Moderator
 
T.Dot_E30's Avatar
 
Join Date: Apr 2003
Location: T.Dot / FL
Posts: 9,772
I think this is it.

Quote:
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.
__________________
T.Dot_E30 is offline   Reply With Quote
Old 10-20-2008, 10:13 AM   #11
Boots R
Boots, not boost
 
Boots R's Avatar
 
Join Date: Jun 2006
Location: Brampton
Posts: 10,958
Perfect. Thanks!
Boots R is offline   Reply With Quote
Old 10-20-2008, 10:48 AM   #12
El Gato Liso
6th Gear Member
 
El Gato Liso's Avatar
 
Join Date: May 2007
Location: Brampton
Posts: 3,223
i was using some formula linking seperate worksheets together
in one column i have formula A. done everything is fine
in coluumn B i follow the exact same steps and it isnt WORKING.
__________________
R.I.P. E30
El Gato Liso is offline   Reply With Quote
Old 10-20-2008, 11:50 AM   #13
T.Dot_E30
Classifieds Moderator
 
T.Dot_E30's Avatar
 
Join Date: Apr 2003
Location: T.Dot / FL
Posts: 9,772
Quote:
Originally Posted by El Gato Liso View Post
i was using some formula linking seperate worksheets together
in one column i have formula A. done everything is fine
in coluumn B i follow the exact same steps and it isnt WORKING.
you need to be sure your referencing the correct worksheet and the correct column/row/cell.

What error are you getting? REF#?
__________________
T.Dot_E30 is offline   Reply With Quote
Old 10-20-2008, 12:33 PM   #14
ara_yaz
Bimmer Fan
 
ara_yaz's Avatar
 
Join Date: Jul 2002
Location: Richmond Hill
Posts: 2,424
Quote:
Originally Posted by T.Dot_E30 View Post
you need to be sure your referencing the correct worksheet and the correct column/row/cell.

What error are you getting? REF#?

Agreed...."$" is ur friend. Lookup Relative & Absolute references to understand how to use them when building multiple sheets.

Press F1 for help then search these topics.

It also helps to literally follow the links in the formula...start at the end and work ur way back to the beginning.
__________________

ethirty
ara_yaz is offline   Reply With Quote
Old 10-20-2008, 12:59 PM   #15
El Gato Liso
6th Gear Member
 
El Gato Liso's Avatar
 
Join Date: May 2007
Location: Brampton
Posts: 3,223
thats the thing i didnt get no REF#
i know i had the formula right

there was no need for$ because i had given the cell a name, so that was used in the calculation on the other worksheet. and there was only 1 value in that column.
__________________
R.I.P. E30
El Gato Liso is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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 On

Forum Jump


All times are GMT -4. The time now is 06:11 PM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Maxbimmer Copyright 2001 - 2018