+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Listing comments and cell contents

  1. #1
    Registered User
    Join Date
    02-05-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Listing comments and cell contents

    Hello all,

    I have an issue with a spreadsheet that I am hoping you can help me with. As you can see in the attached file, several of the cells have comments in them. What I want to do is print a list of all the comments in one spot and have the cell contents appear right next to them so my inventory manager can tell what comments belong with what contents. I know that you can print the comments at the end of the page but it ends up being 12 pages and in 8-point font. Is there a way to consolidate them?

    Thanks,

    MSP
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Listing comments and cell contents

    Hi MSP,
    One way would be to limit the row length.
    When the row count is 20 it moves the data to the next column
    Please Login or Register  to view this content.
    all the comments will be on sheet three
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    02-05-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Listing comments and cell contents

    It looks like this will work. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1