Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ruffles the cat
 
Posts: n/a
Default How do I make a column in Excel into two columns for only A3-A8

I need to have a mini spread sheet inside the larger one. So I need to make
Column A into 2 columns at A3-A8 positions. That means that cells A1 and A2
are the same size the A3-A8 cells become two columns. I can split them with
the draw tool by putting in a vertical line, but this doesn't allow correct
alignment and formulas for those cells. HELP AND thank you. excel Microsoft
office 2003 on Windows XP
  #2   Report Post  
bj
 
Posts: n/a
Default

You can't split cells in Excel, however you could merge cells above and
below so that it looks like you have split the cells
IE merge A1 and B1, A2 and B2, A9 and B9 etc.


"ruffles the cat" wrote:

I need to have a mini spread sheet inside the larger one. So I need to make
Column A into 2 columns at A3-A8 positions. That means that cells A1 and A2
are the same size the A3-A8 cells become two columns. I can split them with
the draw tool by putting in a vertical line, but this doesn't allow correct
alignment and formulas for those cells. HELP AND thank you. excel Microsoft
office 2003 on Windows XP

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
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Excel should provide an easy way to switch a column into a row, n. samsson Excel Discussion (Misc queries) 2 March 21st 05 04:20 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 11:05 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 09:48 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"