INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

(OP)
The solutions are probably easy but I have not been able to find a solution to these two items.

The first item is I am unable to merge cells and continue to use "Wrap Text" with "Autofit Row Height" without a Macro. I prefer not to use a Macro.

If you look at the top of the spreadsheet, you will see a cell with JOB: in it. I would like to add text in this cell while keeping JOB: in the cell and adding text to the right of it. The easy way is to have two cells but then I would need to merge the cells below preventing "Autofit Row Height" from working which will not work with merged cells.

The second issue is when I type and the row expands in width automatically due to wrapping text and autofit row height, the two outer check boxes move while the center box stays put. I have been unable to figure how to keep the check boxes in their row.

Any help would be appreciated. Thanks.

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Hi,

Is a Spreadsheet really the correct tool to use?

What about...
JOB:
This is the job for all good men by coming to the aid of their country.
 

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Please post a copy of your spreadsheet so we can see your problem.

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

(OP)
Sorry. I thought I did attach it but obviously, it did not work. Let me try again. Thanks.

Skip, I appreciate the tip but we are a small firm and I am trying to work with the tools we currently have. Thanks for the tip and will keep it in mind if we end up with bigger projects related to this one.

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Are the check boxes really significant in that they will perform an action (macro) when checked? (If so, what happens if they are subsequently unchecked?...no answer needed, just food for thought.)

If you don't really need actionable check boxes, then just make those first three columns a bit narrow, about the width of the check box, apply formatting as bold and centered vertically and horizontally, and then put an "x" there in lieu of checking the check box. You can even write macros (VBA) to take action if those cells are checked. At least this way you don't have to worry about format messing up.

ETA: I do this sort of thing "all the time" for all sorts of tables

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

What you have is an attempt at an incongruent form.

You are forcing the data above the table to have column congruency with the data in the table.

You can solve this by using the CAMERA feature of Excel. Add the icon for this feature by 1) Right-Click in your Quick Access Toolbar and select customize. (Doing this from memory in Dr's office) 2) select the dropdown for All features. 3) scroll to CAMERA 4) ADD to your QAT.


On a separate sheet, design the JOB: table the way you would do it if you didn't need to consider the table columns. You really ought not enter data in the same cell as the HEADING:. Once done select ALL the data, and name this reference something like pLegend. click the CAMERA icon and select anywhere on the sheet. This places a PICTURE() expression on the sheet. The expression should reference your range name. COPY the picture and PASTE it into your form. Position as needed.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

(OP)
Tom, thanks for the advice and simple approach. I have implemented your recommendations for this spreadsheet.

Skip, thanks for your approach. I am working this right now.

I appreciate the help. Have a good rest of the week and weekend.

RE: Format Challenges - Check Boxes floating when row expands & Preventing Overwriting of Title in C

Use a custom format that precedes the text with "Job:"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close