+ Reply to Thread
Results 1 to 10 of 10

Text Within Table Cells - How?

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    5

    Text Within Table Cells - How?

    Hi all!

    I'm struggling with a problem long time ago. we have many printed sheets with a table on it, and we use to fill it with hand.
    it's getting tiring, so i'd like to make a table for it in excel, so after that, we only have to type it, and print it on the printed sheets.
    i could not make it work to have the text inside the cells. Any tutorial on that?

    Thanks Peter.
    Last edited by AliGW; 09-10-2019 at 03:32 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,875

    Re: Text Within Table Cells - How?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,875

    Re: Text Within Table Cells - How?

    Your query makes no sense to me. What issues are you having with text in cells? Can you attach a workbook showing the problem?

  4. #4
    Registered User
    Join Date
    09-10-2019
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    5

    Re: Text Within Table Cells - How?

    Attachment 640814
    So we have this form, and i'd like to make it possible to fill in this with excel.
    So we just quickly type in the data, and print it onto this form.
    Last edited by nettroka; 09-10-2019 at 04:06 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,875

    Re: Text Within Table Cells - How?

    In what format is this document?

  6. #6
    Registered User
    Join Date
    09-10-2019
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    5

    Re: Text Within Table Cells - How?

    They are preprinted sheets.
    I started it like:
    Attachment 640816
    But the margins and sizes freaking me out.
    But it's more complicated than this. That's why i'm interested in a tutorial video or something.
    Last edited by nettroka; 09-10-2019 at 04:18 AM.

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,786

    Re: Text Within Table Cells - How?

    It seems to me that you're wanting to

    1. Record various bits of information about something like a Customer Order, Invoice etc, e.g. Date, item reference, item description, price, quantity, cost...etc..
    2. From that data populate the from you showed in your attachment.

    Wold you confirm that's the case?

    If so please upload the form you're currently using - presumably it's already either in an Excel sheet or perhaps a Word document.
    Along with the form, for every piece of information (i.e. 'box' on the form) indicate whether its' something that you add manually or whether it's information that can be derived from some pre-defined list of information. For instance you might manually add a product code, and the description could be filled in by a formula which uses the code and looks the description up from a table of code descriptions somewhere else.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  8. #8
    Registered User
    Join Date
    09-10-2019
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    5

    Re: Text Within Table Cells - How?

    Yes, exactly.

    We get the sheets from a printing office. I have no permission to give out any specific info about this sheet. I'd like to make the fill in easier for myself.
    I have tried scanning it, setting as a background in excel, and matching the lines. but it didn't work out so well.

  9. #9
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,786

    Re: Text Within Table Cells - How?

    I'm not sure that is a 'Yes Exactly'.


    I was seeking to find out whether you manually enter some stuff into an Excel worksheet from which you then want to fill in a template form held in the workbook with some of the form being taken from the data you've manually added and other parts of the form containing information that has been calculated.

    When you say you 'get sheets' from a printing office' do you mean you get sheets of paper or is the stuff you get from the office an Excel workbook sheet?
    It sounds like you may just have a picture of the form rather than anything you can manipulate electronically

    Either way it's doubtful we can help you much unless you can share the printing office file/document with us. Anonymise it if necessary, we don't need sensitive data.

  10. #10
    Registered User
    Join Date
    09-10-2019
    Location
    Hungary
    MS-Off Ver
    2007
    Posts
    5

    Re: Text Within Table Cells - How?

    Yes, it's a paper sheet, as it can be seen from the first attachment, and i mentioned that i have scanned it. the attachment i have sent is a true A/4 format.
    And yes, i can not manipulate it electronically, otherwise, i would be able to maage it by myself.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA assigning tabel from excel to multiple words
    By Somish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2018, 06:20 AM
  2. Export an excel sheet to access tabel
    By smasma in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2018, 01:49 AM
  3. Can't find file when updating Excel tabel with PowerPivot - Where is the file?
    By oleisbest in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 12-16-2014, 12:06 PM
  4. Interpolating data in excel tabel with missing data
    By Onno Kramer in forum Excel General
    Replies: 11
    Last Post: 06-03-2014, 01:17 PM
  5. Excel 2007 : Vlookup & Pivot Tabel Usage in Excel VB
    By Sirisha.P in forum Excel General
    Replies: 1
    Last Post: 05-28-2011, 01:19 AM
  6. Update access tabel from excel
    By vish2025 in forum Access Tables & Databases
    Replies: 4
    Last Post: 09-22-2010, 08:24 AM
  7. totals from a tabel
    By Streep in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2005, 08:05 PM

Tags for this Thread

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