Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Adjust a column below without moving the one above?

How do I move the column width in my spreadsheet below without moving the
column width above?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default Adjust a column below without moving the one above?

column width refers to the ENTIRE column

--
Don Guillett
SalesAid Software

"Danelle" wrote in message
...
How do I move the column width in my spreadsheet below without moving the
column width above?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Adjust a column below without moving the one above?

You don't.

Column width and row height is a property of the entire column and row.

Several workarounds if just for appearance.

Copy your lower data to a new sheet.

Adjust your column width.

Take a picture of your range using SHIFT + Edit and copy picture or use the
Camera Tool to take a picture.

Paste below the upper range on sheet1.

OR

Use the Center Across Selection format from FormatCellsAlignment.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 08:46:01 -0700, Danelle
wrote:

How do I move the column width in my spreadsheet below without moving the
column width above?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically adjust column widths stu_padassol Excel Discussion (Misc queries) 1 July 27th 06 09:13 AM
Adjust column width tlee Excel Discussion (Misc queries) 2 May 5th 06 12:58 AM
Adjust Column Width? CDAK Excel Discussion (Misc queries) 0 June 16th 05 11:26 PM
adjust column width coolbeans Excel Discussion (Misc queries) 1 May 15th 05 01:34 PM
Column widths to adjust automatically? lambola Excel Discussion (Misc queries) 1 January 21st 05 01:35 AM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"