formating issue

Hello,

I use excel 07.

I have an excel sheet. On the sheet I have tables spread vertically and not 
horizontally.
That is, I have three tables placed beneath each other.
Now, If i play around with the width of a column, of course the width of the 
cells on the same column chnage accordingly.
This is what i dont want it to happen. I want to arrange cells widths 
independent from each other, while at the same time the keep other tables' 
cell widths fixed.
Now you will suggest to put tables horizontally and change widths then.
The problem is that I copy and paste the tables to word. in the word file 
tables will be placed vertically.
hence, I want to arrange tables in excel the tables vertically placed 
because this tells me already how they will look like in word.

Put in other words: I somehow want to split the excel sheet into several 
parts and be able to change column widths indepenent from one another



0
t24680 (116)
6/20/2008 3:50:36 PM
excel 39879 articles. 2 followers. Follow

2 Replies
666 Views

Similar Articles

[PageSpeed] 10

I don't think there's any way of genuinely splitting the worksheet
into separate sections (with separate widths).  Given that you clearly
don't want to have these presented horizontally, and therefore I
assume won't want the tables to appear on different worksheets either,
I would suggest using merged cells.

Depending on the layout of the tables you are working with, you should
be able to merge cells within each table such that you can have
columns with different widths between the tables (although the overall
Excel columns will of course be the same throughout).  As an example,
you could have very narrow columns (e.g. columns with width of 1) and
merge quite a few cells together for each 'cell' within each of the
three tables, thereby giving you a reasonable amount of flexibility as
to how wide each table column is.
0
rewb2 (15)
6/20/2008 4:34:33 PM
thanks
I tried merging.
Sometimes it works for my purposes, but sometimes not...



<rewb2@yahoo.co.uk> wrote in message 
news:efb2d471-5edc-43c3-875c-0858a946c818@w7g2000hsa.googlegroups.com...
>
> I don't think there's any way of genuinely splitting the worksheet
> into separate sections (with separate widths).  Given that you clearly
> don't want to have these presented horizontally, and therefore I
> assume won't want the tables to appear on different worksheets either,
> I would suggest using merged cells.
>
> Depending on the layout of the tables you are working with, you should
> be able to merge cells within each table such that you can have
> columns with different widths between the tables (although the overall
> Excel columns will of course be the same throughout).  As an example,
> you could have very narrow columns (e.g. columns with width of 1) and
> merge quite a few cells together for each 'cell' within each of the
> three tables, thereby giving you a reasonable amount of flexibility as
> to how wide each table column is. 


0
t24680 (116)
6/20/2008 5:19:30 PM
Reply:

Similar Artilces:

flip a sheet format
Hi, I am looking for a solution where I could change the table in a different format. Any office product solution, Excel or Access or any other tool could be used where the process can be automated (macro, SQL query, etc) I have this table: T1 App1, App2, App3 T2 App4, App5 T3 App6, App7, App8 I want to create this table of the previous table: App1 T1 App2 T1 App3 T1 App4 T2 App5 T2 App6 T3 App7 T3 App8 T3 Thank you for any help Hi The following code should do what you want. Sub ChangeLayout() Dim i As Long, j As Long, k As Long, lr As Long, lc As Long Dim wss As...

Excel 2007 How To Add New Number Formats to Styles
The Styles Functional Group in the Home Tab contains the following Style choices Custom Good Bad Neutral Data Model Titles and Headings Number Format When I created a new style it went into the Custom category but I'd like to move it to the Number Format choice. How can I add a new Style to a specific section of the Style functional group? Thanks for reading and for any help you provide. Regards (8^>)-]=[ ...

Can't get dates to format corrrectly.
Hi, I ran a MS-Access query to pull in some data from our database and one of the date fields has the data formatted as either MM/DD/YYYY or YYYY-MM-DD. I want to change the data on the Excel sheet so that all rows display this date as MM/DD/YYYY. I tried to obvious of selecting the entire column and setting the format to just that date format but still those dates remain formatted as YYYY-MM-DD. When the data came into Excel it was set to a general format for that particular column. Any ideas on how I can accomplish this? You might try this: go to any blank cell off to the side an...

crm login issues #2
Hello, We have CRM version 3, currently all patched up, our crm clients are using Windows XP, Office 2002 (XP) with the most current Microsoft patches, and the most current CRM client. I have one person that keeps getting prompted to log in no matter what she clicks on in CRM. Example she starts outlook clicks on the CRM queue a login window pops up asking her to log in. I can either enter her login nam and password or just click cancel a few times and she is able to do her CRM work, if you close outlook and start Outlook again the first time she clicks on anything for CRM is prompt...

Multiple-Test Conditional Formatting
Hi, everyone! I have a spreadsheet in which one column (B) contains an item "type", e.g. "C" or "H". In another column (G), I put a "required" sub-item. I am trying to conditionally format the cell in column G to do the following: If Col B = "C" and Col G is blank, make background of Col G red; Otherwise, make background of Col G normal. Using normal CF, I can make G's background red if Col B = "C" (formula is), or I can make it red if Col G is blank (cell value is), but can't seem to find the trick of combinin...

Date conversion issue "^" symbol
I receive a weekly file from a tool that sometimes throws a "^" character in front of date. This symbol seems to be throwing excel off and I am unable to convert the date into number format. Excel treats the cells that begin with "^" as text. Oddly enough in another part of the workbook I use the IF function to compare the start date and end date of a project. Although I am unable to convert the dates to number format the formula works. Has anyone run into issues with the "^" character preceding a date? And if so, how do I fix? Just a guess as...

macro to find date format in a cell and delete that entire row
macro to find date format in a cell and delete that entire row i have dates in a column and date keeps changing, i want that if macro find date in a column , it deletes that entire row help me thank u so much everyone for ue hel -- Message posted from http://www.ExcelForum.com try Sub deletedate() For Each c In Selection If IsDate(c) Then c.EntireRow.Delete Next End Sub -- Don Guillett SalesAid Software donaldb@281.com "vikram >" <<vikram.15ix9t@excelforum-nospam.com> wrote in message news:vikram.15ix9t@excelforum-nospam.com... > macro to find date format in a ...

CRM Email Router issue
I have Exchange Server 2007 and WIndows Server 2008 We just installed CRM 4.0 and everything seems to be working except for monitoring of incoming emails. I have installed the CRM Email Router on our Exchange server, tested and it all says successfully connected to each email box, however when a customer sends a response from a CRM email, to me it doesnt auto add it into CRM. The CRM Email router service is started These are some of the errors in the event log: #27938 - An error occurred while checking for e-mail messages to process in mailbox username@domain.com. System.Net.WebExcept...

Prevent format change caused by pasting. (office '97)
Every time I paste something that was from an website (even if only one word) the column extends as far right as it allows. I found out that I can change the format (under paste special) back to text to fix this. Is there a way to prevent excel for changing format? I want it to default as text format and not change format unless I change it myself. Also is there a way to keep the text at one font and one text size, so that if I paste something that had a different size or font it would change to the size and font that I have set for my document (I want to know how to do this in Word as well.)...

Email
I use Word as my email format. How do I display the horizontal ruler on a new email message I'm trying to send? ...

conditional formatting for more than 3 conditions
Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please help. Thanks, Jai formula is =or(c1="data1",c1="data2",etc) or =or(c1={"data1","data2"}) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Jai" <Jai@discussions.microsoft.com> wrote i...

OWA 2003 Issue (Attachment corruption)
Hello everyone, We have Front-End/Back-End configuration of Exchange 2003 Std. servers (SP2 and all hot fixes after it). So, if someone sends e-mail with attachment through OWA the attachment becomes corrupted (it has same size and name but could not be read by any application / system splits attachment and put 2 parts of it into message using the same name of file). It happens to all documents (Word, Excel, PDF) image files (JPG,GIF,PNG) are affected as well. We tried to send those files through usual MS Outlook 2003 and they go just perfect. We have McAfee Groupshield 6.02 for Exch...

NAND Flash Formatting speed : WinCE 5.0 vs WinCE 6.0
Hello, I have a target device with a 256MB Nand Flash. I have both Windows CE 5.0 and Windows CE 6.0 R3 for this target device. I have observed that If I format the 256 MB NAND Flash in Windows CE 5.0 by Storage Manager, it takes about 10 minutes. If I format the NAND Flash in Windows CE 6.0 R3 it takes about 10 seconds (or less). Why ? The NAND FMD Driver is the same. I can debug the Windows CE 6.0 FAL because there are the source files but I can't debug it in Windows CE 5.0. There are some improvements in Windows CE 6.0 FAL ? Thanks, Paolo -- Paolo Patierno Embedde...

Custom Autonumber Conditional Formatting
To, The EXPERTS, ( Access Dept.) I am New to access but have managed to make a database for my patients records , my trouble is the Registration Number of the Patient,( a cloumn in my database). i want it to generate the unique ID just llike AUTONUMBER, with the format i need that should be like YYMMnn( YY= present year,MM= present month and nn = numbers 01 to 99, with reset to 01 at the start of the next month)the event to trigger the event is SAVE Form button. please can anybody help? Thanking you in advance To, Mr.Klatuu Thanks for your Promt help... I will try to put this into use i...

conditional formating for a blank cell
i'm trying to do the following conditional formatting: if the date in the cell is less than TODAY(), make the cell red. if the cell is blank, leave the cell blank with white shading. i've tried the following: cell value is equal to ="" cell value is equal to "" formula is =AND(E8="",E8<TODAY()) and some others that i can't remember at the moment. i've searched this forum and tried all the ideas i could find. anyone have any other ideas? =E8<TODAY() HTH Jason Atlanta, GA >-----Original Message----- >i'm trying to do the follo...

how do i use format cells to alpha / numeric values
HAVE A STRING OF DATA i WANT TO ENTER into a cell, but I also want to set format to set the values. eg. if I put in asd123 I want it to appear as ASD123 but there are also occasions when I will put in a different mix of letters/numbers a12s3d, which I also want to come out as A12S3D. I can do this in Access but cant seem to crack the code in excel. Please help. Try =UPPER(E2) HTH Regards, Howard "Samvid69" <Samvid69@discussions.microsoft.com> wrote in message news:701E3143-A79D-4FDE-8661-325795CE50F0@microsoft.com... > HAVE A STRING OF DATA i WANT T...

change custom format number to text
i have a long colum of custom formated dates i need to change them into text in order to prosses them -the custom format is dd/mm/yyyy h:mm the cell reads 01/09/2005 9:30 the number that shows up is 38596.39583 when i try to convert the format to standard text. is there a function that will do this for me? Just add an apostrophy in front of the date. Be sure to do it in the formula bar. So if you see 9/16/2005 make it '9/16/2005 -- Gary''s Student "joey" wrote: > i have a long colum of custom formated dates i need to change them into text > in order to p...

Number Format Pbm
Hi I have a financial spreadsheet that I imported from a CSV file. All of the number cells are showing the number left justified, which I think means that Excel sees them as text. However when I click on "Format Cells:Number", the Category setting is "General". If I attempt to apply any of the procedures in the help pages, like multiplying the content by 1 (to convert text to number) that operation seems to fail as it does not result in producing a number either. How can I convert these cells to proper numbers that will respond to formulas and conditional formatting...

Maintain formatting in linked chart title
I am linking an Excel chart title to a named range. Is there any way to maintain the formatting used in the named range in the chart title? On Tue, 15 May 2007, in microsoft.public.excel.charting, chumley <chumley@discussions.microsoft.com> said: >I am linking an Excel chart title to a named range. Is there any way to >maintain the formatting used in the named range in the chart title? Not ordinarily. Someone may be able to do it using VBA. -- Del Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send...

conditional format #7
Hi, When cel B3= "zaterdag" or "zondag" I want B1, B2, B3 and B4 to have a gray background... What should I do? Thanks JP See http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Jean-Paul De Winter" <jp.dewinter@pandora.be> wrote in message news:65x9h.201125$dB6.3127354@phobos.telenet-ops.be... > Hi, > > When cel B3= "zaterdag" or "zondag" > I want B1, B2, B3 and B4 to have a gray background... > What should I do? > Thanks > JP ...

Vlookup and Formatting
On Sheet1, I have data with cells that have different formatting (e.g different text colors/bold/etc.). On Sheet 2, I have a vlookup formul that shows the data presented on Sheet 1, but without the formatting. Is it possible while using a vlookup formula to display both the dat and the data's original formatting? If not, how else can I accomplis this? Thanks!! -- peter_river ----------------------------------------------------------------------- peter_rivera's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2449 View this thread: http://www.excelforum.com/sho...

Need help with Parameterbinding issue
Hi, I am (desperately) trying to bind the Credential-Paramater of Invoke-Command to a CSV-File and its Credential-Column like so: Credential ====== Administrator and Import-CSV Creds.csv | Invoke-Command -Scriptblock { Get-Service -Name * } -Computername Server2010 The Credential-Parameter should receive its value from the pipeline object and its credential property since the parameter supports ByPropertyName binding. But it didn't worked out - the credential object gets bound to the InputObject-Parameter instead (I did a TraceCommand). A import-csv cre...

Number Formats #2
I've been working with number formats lately. I wrote in the custo format ???.??? to align a set of numbers by their decimals. Fo example, 1.25, 12.45, and 137.98 would all align by the decimal eve though they take up different amounts of text. The problem is that I want to add superscript letters after some of th numbers. So I would want an "a" to come after 1.25 in superscript. When I add the "a," the number format no longer works and the number do not align by the decimals. How can I add the letter and still make the number format ???.?? work? Thanks -- Messa...

Change cell format containing date
I'm having problem changing a cell containing date, to text format without converting the date into number. For example, an existing cell containing 12/10/2003 in date format, to be converted to a cell in text format but the cell content must now retain 12/10/2003 as a text. Other than re-typing the figures in as text in a blank text-formatted cell, all other methods involving copy and paste in any order just don't seem to work. Using Excel, OfficeXP version. Thanks for any suggestions. One way =TEXT(A1,"mm/dd/yyyy") where A1 holds the date -- Regards, Peo Sjoblom ...

How do I set number formats that will be applied only if a number. #2
How do I write a formula to change the color of the results? Example: If a cell is feeding back 0 – 100%, and I want 90 – 100% in green, 80 – 89% in blue and less than 79% in red. Hi see 'Format - Conditional Format' for this -- Regards Frank Kabel Frankfurt, Germany "Jim Gentile" <JimGentile@discussions.microsoft.com> schrieb im Newsbeitrag news:4ED401D6-0434-4E9B-A89A-DAB45EE407C1@microsoft.com... > How do I write a formula to change the color of the results? > > Example: > > If a cell is feeding back 0 – 100%, and I want 90 – 100% in green, 80 –...