#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Copying a Cell

If I copied a cell (A10) form another worksheet to B10 of my current
worksheet. If I copy B10 from my current worksheet and paste it to N10, what
symbol should I use to maintain the information from A10 insted of I10.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Copying a Cell

Back in B10 of the current worksheet there should be a formula that looks like:
=[Book1]Sheet1!$A$10
If it is missing the $ symbols, put them into it. Now no matter where you
copy that cell to, the column and row references will remain the same. This
is called absolute addressing.

If the $ in front of the column reference is not there, then the column
indicator will change as you copy left or right of the original column; if
the $ is missing in front of the row indicator then the row number will
change as you copy it into rows above or below the original location.

These rules apply to cell references within a book also. See Help on
Absolute and Relative addressing.
"Need HELP" wrote:

If I copied a cell (A10) form another worksheet to B10 of my current
worksheet. If I copy B10 from my current worksheet and paste it to N10, what
symbol should I use to maintain the information from A10 insted of I10.

Reply
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
Copying the data in and format of a cell to another cell cyberdude Excel Discussion (Misc queries) 1 January 6th 07 12:22 PM
When copying a cell to another cell the information is duplicated. sicap Excel Worksheet Functions 0 December 30th 05 08:03 PM
Copying format to a new cell, w/o overwriting destination cell contents James C Excel Discussion (Misc queries) 1 October 18th 05 08:02 PM
copying the function contained within a cell to anouther cell. DMB Excel Worksheet Functions 2 September 1st 05 05:49 PM
Copying excel format from cell to cell Loopy Darren Excel Discussion (Misc queries) 2 April 12th 05 04:29 PM


All times are GMT +1. The time now is 06:03 PM.

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"