I'm struggling with this issue for quite some time now and can't find the solution I want to. I'm looking for a solution to tab between two or three words/values inside a single Excel 2010 cell. I'm organising multiple types of cameras with different aspects as listed below:
- 800x600 pixels, fixed iris, etc, etc.
- 1280x720 pixels, DC-iris, etc, etc.
- 1920x1080 pixels, P-iris, etc, etc.
One solution is to use the Courier font and just use spaces to get all the data properly aligned because all letters have the same X ratio with this font. However this font is not part of our company policy and I don't like the font either so it's not the thing I'm looking for.
Another solution is to create multiple smaller columns ofcourse and put every type of data in a single column. Unfortunatly this is getting quite messy as well because eventually 99% of all the cameras are filtered out and only 1% is shown (it's some sort of standard calculation sheet). It can occur that this 1% misses some aspects and the huge blank lines appear.
I hope I explained my problem properly. Does anyone have a solution for this or isn't it possible at all?