Forum Discussion
Table formatting
Are you able to attach a sample of what you are hoping to achieve? It is not clear from your description.
thanks
this is the basic setup. i just would like to be able to add a new comment where it says add and then have it auto date when i made that comment and shift all previous comments to the right so there is space for a new comment and the most recent is easily visible. i might be making this harder than i need to.
- peteryac60Jun 03, 2020Iron Contributor
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
- CaseyChrisJun 03, 2020Copper Contributor
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.
- peteryac60Jun 04, 2020Iron Contributor
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