#1
|
||||
|
||||
Properties of a Cell
Hello,
I figured if you copied a cell, the properties of that cell would follow. The information would too but you can edit that. No cell merging either. The only formatting I've done is to stretch out the four columns so that they cover the screen with column D being the widest. Here's the setup: 2 rows - four columns column A - 1 line, centered both ways, bolded column B - 2 lines, underscored, centered vertically column C - 1 line, centered both ways column D - word wrap on but using Alt+Enter to create each line, bottom row 1 - 4 linesI copied 1D to 2D and edited 2D. What I'm seeing is that 2D seems to have a blank line/row (well it looks like an extra line/row) regardless if I change Bottom to Top or Centered or turn off Word Wrap. If I type Line 1, Line 2, etc. in four columns in another Sheet and not copying anything, especially cell properties, it comes out right! I want these cells (1D and 2D) to be snug against their respective lines, above and below, without the extra space. This is what I already see in 1D. What can I check in 2D (or even one of the other cells)? Something different about word wrap or reaching the end of a column perhaps? I hope this makes sense. Let me know if you need more info. Thanks. |
#2
|
||||
|
||||
Properties of a Cell
An update ...
I found out that using special characters may be causing this. Try these two lines. Extra context menu item: &Google Search - res://c:\windows\GoogleToolbar1.dll/cmsearch.htmlRemoving the ampersand (&) or both slashes (//) puts the cell as I would like to see it. So are these characters preventing this or is it still something else? Thanks. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add custom doc properties in "Doc properties control" | eazysnatch | Word | 2 | 09-13-2017 08:08 PM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |