How do you autoformat an excel database to automatically make both the cell length, and width the exact size it needs to be to display the full name,numbers, etc of your data?
For instance in the attached file many of the variable names are cut off, for instance "state_abbreviation" is not fully visible.
edit: This may be the wrong forum, please remove if so.
Last edited by cmf0106; 10-22-2009 at 03:03 PM.
In the top left corner, above (row) 1 you'll see cell with some triangle in it.
Click on it, whole table will be selected, then just click twice any line between top of columns (for example between letters A and B)
Or put cursors outside data and click CTRL+A (to select all, instead of step 1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks