ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   add a colum within 5 spaces of a column (https://www.excelbanter.com/excel-discussion-misc-queries/29972-add-colum-within-5-spaces-column.html)

Bruce

add a colum within 5 spaces of a column
 
i would like to insert a colum within 5 rows of a column.
how do i do this?
thank you.

JE McGimpsey

You can't split cells. However, you could merge two columns for all
cells except your 5 rows (i.e., select columns B & C, merge them, select
your (now) 5 cells, and unmerge them).

However, merging is the spawn of the devil. It leads to problems with
sorting, formatting, copy/paste, etc.

In article ,
"Bruce" wrote:

i would like to insert a colum within 5 rows of a column.
how do i do this?
thank you.


Barb R.

Your question is a bit confusing. Do you want to add a column between other
columns? Something else?

"Bruce" wrote:

i would like to insert a colum within 5 rows of a column.
how do i do this?
thank you.



All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com