| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Copy column from one sheet to another | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Linear Mode
