Search results

  1. K

    Acrobat stamp to be filled out with check boxes/radio buttons, name and date

    Thanks! I have both, and actually I tend to use Reader to fill out forms for my supervisor (type in his name and title, date, and place his signature.) But I don't actually edit the form. I think in Reader I can add a big gray checkbox in any of the boxes. It does sound like I will have to...
  2. K

    Acrobat stamp to be filled out with check boxes/radio buttons, name and date

    Hello all, At the office we have Acrobat X/XI (varies by desk) and Reader. I don't think anyone has Pro or DC. I'm looking for a relatively easy way to take an old (literal) rubber stamp and make it fillable as a form to be stamped into an existing document. I've watched some tutorials on...
  3. K

    12 week isolation

    Best of luck to you. On the other side of the twelve weeks, you'll be well trained for that trip to Mars.
  4. K

    tab movement

    I was having trouble submitting my reply and on the third try, forgot to attach this image that shows where (for me) is the easiest place on the Home ribbon to get to Lock/Unlock and Protect Sheet commands. Best, Ann
  5. K

    tab movement

    Select all cells, then Lock Cells. Then select only your yellow cells where numbers will be typed. Select Unlock Cells on them. Then protect your worksheet, making sure you uncheck "Select locked cells" but leave "select unlocked cells" checked.
  6. K

    Update Cells from Another Workbook

    Did you ever sort this out? I'd think that the easiest way to do this is to take your existing Worksheet A and upload it to the database, assuming the columns that both datasets have in common are labeled and formatted the same, and do a query that would match up based on the Invoice Number and...
  7. K

    Getting image in Excel header to center/fit as background letterhead

    Ah, I forgot to say -- it's Excel 2010. Yes, I do have those features, but though I did have hope for the check-boxes for "Scale with Document" and "Align with Page Margins," I tried those in every combination of on and off, and none of them re-aligned the background. I just tried making the...
  8. K

    Getting image in Excel header to center/fit as background letterhead

    I was sent a problem sheet to try to fix it. It's a simple spreadsheet used as a rundown of fees, and apparently the user wanted our "second sheet" letterhead as a background. I'm attaching a snip of how it looks in Print Preview - with the letterhead image starting about .7 inch to the right...
  9. K

    Top 10 Pivot Table

    Did you find a solution? I see Uncle Gizmo gave you some good links but those all seem to be MS Access solutions. If you have Microsoft Access as part of your Office suite, that's probably going to work best for you over time. You can set up your report options, and all you'd have to do is...
  10. K

    Generating a series of tables-as-forms

    Just wanted to update to say that this setup actually worked really well using Mail Merge to transfer a lot of information in and create as many tables as needed for the full report. The only drawback was that some of the original information was in paragraph form so that needed to be retyped...
  11. K

    Pictures Default Layout in Word

    That's where I'd start - even if the table is just a one-cell one. They'd want to go in and turn off the feature where the table automatically resizes to contents though. Another possibility, or to be used in combination with the table, is a Picture Control. To do this, Maxmangion, you'd...
  12. K

    Generating a series of tables-as-forms

    Oh, sorry, by "report" I meant the series of tables will be added to a Word document we term a report. It's not a report in the sense of MS Access. I actually wish I could use Access for some things - we don't even have it on our computers at this workplace. (I have it on my personal laptop.)...
  13. K

    Generating a series of tables-as-forms

    Me again. I've been asked to try to sort a way to get a lot of complex information into a report, where previously a table was on one page and a photo on the following. After a series of back-and-forth drafts, I've come up with each record going into a 1 x 3 table format, where the first...
  14. K

    auto number with duplicate -first-last bench

    To populate the answer to "First Bench in all school" and "last bench in all school", For School 1 =MIN(D$3:D$10) should yield the lowest number bench =MAX(D$3:D$10) should yield the highest number bench But you'd need to redo the formula for each school and do they always have a consistent...
  15. K

    auto number with duplicate -first-last bench

    SECOND REQUEST column: You want to copy over the number from "First Request" (you'll want to check your spelling on "first", by the way). The way I would do this with a formula is put your cursor in cell G3 and use: =IF(F3="",G2,F3) What this says is, if there's no number to the left of this...
  16. K

    Customizing ribbon and QAT on a shared work computer

    I should note that this may differ depending on how the overall system is set up, but as long as people have independent user log-ins and separate folders set up, I'm guessing these changes reside somewhere in a file that, along with my individual "normal.dot" template, resides in my user area.
  17. K

    Customizing ribbon and QAT on a shared work computer

    So the answer seems to be, it's user specific. I got to stretch my legs AND check on it. Her QAT doesn't reflect the items I added, and her Insert Header doesn't have our letterhead options in it, and she's happy the way it is. I guess I can customize away! Thanks all! And happy weekend! Ann
  18. K

    Customizing ribbon and QAT on a shared work computer

    I know that's true about general Windows settings, but not sure how it works within Office toolbars, etc. I did make some changes to the Building Blocks (added our letterhead headers and second-sheet background under Insert Headers) so that should be a relatively low-impact, and actually...
  19. K

    Customizing ribbon and QAT on a shared work computer

    Hmm, I think I'm going to tread lightly then. I suppose I could just try to work around it, and only temporarily add what I like. Most of the time I'm revising reports someone else has made from a variety of old reports used as templates, and it's mostly small typing revisions, and looking for...
  20. K

    Customizing ribbon and QAT on a shared work computer

    At lunchtime, I cover the front desk in my office and log in as myself on the receptionist's computer, taking whatever desk work I can with me. If I want to replicate some of my custom ribbon features, and Quick Access Toolbar, on her computer, those are user-specific, aren't they? When she...
Back
Top Bottom