LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default When I make a row absolute, but column relative, the column stays.

I am trying to copy a formula using the fill option. When i set the column
in the range to relative and the row to absolute, the columns and rows in the
range saty the same. I thought that the dollar sign was supposed to allow
the range to change in sequential order
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change a long column of references from relative to absolute ams228 New Users to Excel 1 January 17th 07 10:17 PM
CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. june.sidwell Excel Worksheet Functions 1 December 27th 06 08:54 PM
Excel: Cant copy an relative Cell and make absolute themantheworldlovesmorethannathan Excel Discussion (Misc queries) 1 August 22nd 06 11:26 PM
Changing relative to absolute for a column John K Excel Worksheet Functions 6 May 17th 06 02:51 AM
How do I copy an absolute column and relative row to the right? Fusterated Excel Discussion (Misc queries) 1 March 23rd 06 08:49 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"