Forum Discussion
Table formatting
Is it not just a case that you would insert a new column after column A (your node column) and then add your comments there. You other columns would move to the left automatically?
Am i missing something?
thanks,
Peter
I did figure out with a right click on the cell and a shift it will do what i want. then I'm trying to find the command to auto date the cells in the column. so when i put a new comment in it will automatically add that days date.
Can I ask ..... are all the comments in the column made on the same date? Or will you make several comments over a period of time before you insert a new column?
If the former then I would suggest that you put the date (manually) in the first row at the top. (see column I in the attached).
If the latter I'm afraid I don't think it is possible to enter a date automatically in the same cell that you are adding a comment. It may be possible to do this with VBA (excel's programming language) but I am not sure it is worth the effort. A couple of possible alternatives for you.
1/ You can add an extra column (as per attached) but you will still have to manually add the date.
2/ Depending on the version you have you can use the Insert Comment feature for each cell. (Just to confuse you older version of Excel have a Insert Comment feature which in Office 365 has been renamed to Insert Note and the a new feature called Insert Comment - confusingly! - will generate today's date). While this works it is not particularly elegant!
Anyway I hope this has been of some help.
**bleep** luck
Peter
By the way , if you are going to add the date manually in a cell you can use the shortcut Cntrl ;
This will add the date at the start of the cell - might make it a bit easier for you.
Hope this helps.
Peter