| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 121649 | 2011-11-04 08:05:00 | One for the excel users / gurus | Myth (110) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1241852 | 2011-11-04 08:05:00 | I am wondering if it is possible to copy the comments from one cell on a worksheet; to a specific cell or cellrange on another worksheet. Or more preferentially; if I can copy a cell or cellrange from one worksheet into the comments of a cell on another worksheet Being rather noob at excel, you may need to give specific instructions (initially anyway) Also, how do I create a "static titlebar" in xcel; whereby when one scrolls down; a row (or rows) containing the headings remains static |
Myth (110) | ||
| 1241853 | 2011-11-04 09:15:00 | I can answer your second question - the feature you're after is called "Freeze Panes". Click on the cell that you want to be the "top left hand" corner of the bit of your spreadsheet that moves. Then click on the "Freeze Panes" button (which will either be in the ribbon for Office 2k7/2k10 or the Window menu in 2k3). | somebody (208) | ||
| 1241854 | 2011-11-04 19:11:00 | This macro may help you if no other solution comes to light Sub FillComments() On Error Resume Next For Each cell In Selection.Cells cell.AddComment cell.Comment.Text Text:=cell.Value Next End Sub It copy's text cell contents to the comment area of the same cell It would then be simply a matter of copying the cells to where you want them and using excel's Paste Special.comments function which will place the comments only into the cells where you want them located. Trev |
TeejayR (4271) | ||
| 1241855 | 2011-11-04 22:29:00 | To scroll down your spreadsheet while keeping your headers at the top: move the cursor to the top of the scroll bar. just above the 'arrow' there is a narrow line. put the cursor over the top of that and it changes to 2 horizontal lines with an arrow above and below. Leftclick on that and drag it down to where you want the top of the page to be. To remove it drag it back to the top or just doubleclick on it. Works on the vertical as well. You can have both at the same time too. | bugalugs67 (9647) | ||
| 1241856 | 2011-11-06 09:11:00 | 1. I am wondering if it is possible to copy the comments from one cell on a worksheet; to a specific cell or cellrange on another worksheet. Or more preferentially; if I can copy a cell or cellrange from one worksheet into the comments of a cell on another worksheet 2. Also, how do I create a "static titlebar" in xcel; whereby when one scrolls down; a row (or rows) containing the headings remains static 1. Select the cells with the comments that you want, copy them (Ctrl + C, right click, however), and then go to Edit tab, paste special, and select 'Comments'. 2. Select the row underneath the ones you want held in place. Click on the 'Windows' tab, and then click on 'Freezepanes'. Hope these are sufficient. :thumbs: |
Sick Puppy (6959) | ||
| 1 | |||||