Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2007, 01:09 PM
curlymal curlymal is offline
Novice
formula in excell
 
Join Date: Jan 2007
Location: Thirsk England
Posts: 2
curlymal
Default formula in excell

I know this sounds to simple but i can't absolute a cell in excel anyone guide me through it please
Reply With Quote
  #2  
Old 02-09-2007, 06:34 AM
jhweaver jhweaver is offline
Novice
 
Join Date: Jan 2007
Posts: 6
jhweaver
Default Absolute referencing

I take it by 'not able to do absolute referencing', you mean you do not know the syntax of using it. I am assuming you know the difference between absolute and relative referencing.

Relative = A1

Absolute = $A$1

You can mix them;

A$1 = 'A' (the column) is relative '1' (the row) is absolute. The column will adjust relative to how far you copy the formulae from left to right, or vice versa), but the row will ALWAYS point to row 1 (it's absolute).

$A1 = 'A' (the column) is absolute. '1' (the row) is relative. The column will ALWAYS point to column 'A' (it's absolute), but the row will adjust relative to how far you copy the formulae up or down the column (it's relative).

When typing the formulae into the formulae bar, pressing F4 will toggle the cell reference between A1,$A$1,A$1,$A1 and back to A1 but you must press F4 immediately after typing the cell reference (it only affect the cell ref immediately to the left of the cursor bar.

Sorry if this reply is a bit long winded, but (as you suggest) it really IS simmply once you have got the grasp of it.
Reply With Quote
  #3  
Old 02-09-2007, 11:34 AM
curlymal curlymal is offline
Novice
formula in excell
 
Join Date: Jan 2007
Location: Thirsk England
Posts: 2
curlymal
Default

Many thanks for that it was a great help and has cleared things up for me
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula in excell Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM
formula in excell Excell stopped working TomC Excel 4 05-26-2006 11:40 PM
formula in excell Stuck on this formula!!!! CADmanJP Excel 2 03-10-2006 02:06 AM
power point excell dshar PowerPoint 0 03-09-2006 04:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft