Copy worksheet with row & column references
 

How can I copy and paste a portion of a worksheet including the row &
column references, like we see when we get a tip from exceltip.com?


--
ERudy
------------------------------------------------------------------------
ERudy's Profile: http://www.excelforum.com/member.php...o&userid=34365
View this thread: http://www.excelforum.com/showthread...hreadid=541708

Copy worksheet with row & column references
 

Choose FilePage Setup
On the Sheet tab, add a check mark to 'Row and column headings'
Click OK

Select the cells, and choose EditCopy
Select the cell where you want to paste
Hold the Shift key, and choose EditPaste Picture
(or, to paste in Word, choose EditPaste Special, Picture)

ERudy wrote:
How can I copy and paste a portion of a worksheet including the row &
column references, like we see when we get a tip from exceltip.com?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html