Author Topic: formatting  (Read 1966 times)

2southpaws

  • Newbie
  • *
  • Posts: 22
    • View Profile
formatting
« on: November 02, 2017, 09:12:50 pm »
I primarily sell collectibles, so most of my inventory are unique items. I'd like to use the Product Master list as a straight inventory list (item name, date purchased, purchase location).

I copied a long list of inventory items from the basic Excel spreadsheet I created when I started selling and pasted the list into the Product Name (Unique) column of the Product Master list. I pasted values only.

My problem is that, because my product names are of varying length and I can't adjust the width of the column or wrap the text, they are different font sizes. Shorter names are readable, but longer names are super tiny.

Is there a way I can adjust the column width and/or set that column to wrap text?

Thanks!

2southpaws

  • Newbie
  • *
  • Posts: 22
    • View Profile
Re: formatting
« Reply #1 on: November 02, 2017, 09:22:35 pm »
UPDATE: I was able to select the cells that I filled with items and wrap the text on those, but I can't select the entire column to apply wrap text to future entries.

Also, now that the text is wrapped (and thus all the same font size), I can't figure out how to adjust row height so that all of the text for each cell shows.

Getting there...just need a little more help!

Thanks!

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 270
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: formatting
« Reply #2 on: November 03, 2017, 05:21:27 am »
You can edit using all of the standard excel formatting tools:

Click the FULL SCREEN button to exit the full screen mode which will display the Ribbon Bar and Row and Column labeling.
At that point you can change any column sizes, font sizes, wrap settings, etc, let me know if you need assistance with any of it.

Note: The item description column is the column that links to the sold item tab to automatically populate (they need to match).
This column was used because many sellers dont utilize the SKU data.
You can use other columns (such as SKU) to fill in a more basic name, etc.

I hope that helps!