Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2010, 11:56 AM
miller.3276 miller.3276 is offline Seperate Column widths in one worksheet Windows XP Seperate Column widths in one worksheet Office 2007
Novice
Seperate Column widths in one worksheet
 
Join Date: Jan 2010
Posts: 2
miller.3276 is on a distinguished road
Default Seperate Column widths in one worksheet

Is there a way to have separate columns widths in the same document?

Ex. I would like to have column A have a width of 9 for the first 10 rows, then have a width of 3 in the remaining rows of the document. (this is a simplified example).



I am aware that I can merger two cells at the top in order to get the full 9 width but this will not accomplish what I need. The document is a template that has information at the top and a chart below (see image attached). For certain projects I will have to unhide columns E, F, G, & H. The problem is when I unhide these columns the information in row 2 is distorted due to the additional columns.

The solution I am considering but have not been able to accomplish is inserting an excel spreadsheet within an excel spreadsheet. The information at the top will be on the first spreadsheet with the one set of column widths and then the chart on an embedded spreadsheet with the hiden columns. The catch is that I don’t want this to be a link, I want it to be an embedded spreadsheet.


Hopefully someone can understand what I am asking and help me
Attached Images
File Type: jpg excel column pic.jpg (62.7 KB, 16 views)
Reply With Quote
  #2  
Old 01-27-2010, 12:51 PM
BjornS BjornS is offline Seperate Column widths in one worksheet Windows Vista Seperate Column widths in one worksheet Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi there,
I have a proposal for a solution.
(the English menu commands are translated from Swedish and might therefore not be 100% equal to the actual text in English Excel).

Create a textbox that goes over several columns. Right click on the textbox and select "Format...". Now select Select "Properties" and then the radio button "Don't move or change size when with cells". + OK.

If you donä't have a constant text in the textbox, you can link it to a cell. Mark the textbox, click the formula field an write (example): =Sheet1!M1

Now you can hide/unhide without any change of the textbox.

See my attached example.

Let me know if this helps you!

Kind regards from snowy Sweden!
Bjorn
Attached Files
File Type: xls Fixed text.xls (13.5 KB, 49 views)
Reply With Quote
  #3  
Old 01-27-2010, 02:12 PM
miller.3276 miller.3276 is offline Seperate Column widths in one worksheet Windows XP Seperate Column widths in one worksheet Office 2007
Novice
Seperate Column widths in one worksheet
 
Join Date: Jan 2010
Posts: 2
miller.3276 is on a distinguished road
Default

Great idea. This is a work around that I can use ... thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seperate Column widths in one worksheet Worksheet copying? markg2 Excel 4 01-07-2010 10:08 AM
How do I make seperate user accounts/files DramaQueenLucy Outlook 1 06-05-2009 07:38 AM
Header - seperate chapter, continue page number Cpt Black Word 0 02-03-2009 06:45 AM
TRANSFER DATA TO NEW WORKSHEET BOBN Excel 0 11-08-2007 10:34 PM
click a cell to go to a worksheet victor Excel 0 10-27-2006 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft