I thought you might have solved my problem.
I use a spreadsheet in which I need to store the serial number for the product issued. The cell shows the product and I then inserted the serial number as a comment. This is fine on the main PC but when I am out on the road I am using Documents To Go to read the spreadsheet on the iPad. Unfortunately neither the Comment or the Data Validation method show up.
Do you have any other suggestions that might work?
Discussion on:
View:
Show:
put the serial no in a different cell?
or use VLOOKUP() in an adjacent cell to find it from a list?
or add it to the end of the product name?
not sure why you want to add it as a cell comment anyway; if you don't want it to be normally visible then you could use alt-enter to force it onto the next line within the cell and drag the cell height to a single line (and align text to top of cell!)
or use VLOOKUP() in an adjacent cell to find it from a list?
or add it to the end of the product name?
not sure why you want to add it as a cell comment anyway; if you don't want it to be normally visible then you could use alt-enter to force it onto the next line within the cell and drag the cell height to a single line (and align text to top of cell!)
For a continuing series of useful tips and tricks to make life easier in "Office-World!"
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
