Hi. I’m trying to create an inventory spreadsheet that has 4 columns. Instead of just having 4 columns per page I would like to maximize the space on the page by having Excel automatically continue those 4 columns in adjacent columns on the same page (divided by one column width) before it then continues to the next page. I hope I’m being clear as to what I’m trying to do. Not sure if it’s possible or not. Obviously I can manually create the eight columns myself and then fill in my information. The problem comes in when I have to add an inventory item to a previously created page. I now have to manually move all the data down one set of columns to the adjacent set of columns which then has to bump the data on the next page down and so on and so forth. It wouldn’t really work. Anyone with any ideas I’d really appreciate it. Thank you.
