ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   inserting new columns (https://www.excelbanter.com/excel-discussion-misc-queries/109877-inserting-new-columns.html)

CJ

inserting new columns
 
is there any way to insert new columns just for the top 8 rows in excel, i
don't want the new columns in the whole worksheet? i'm making a calendar for
a vac ation planner. some help plz

Biff

inserting new columns
 
That's not possible.

Biff

"cj" wrote in message
...
is there any way to insert new columns just for the top 8 rows in excel, i
don't want the new columns in the whole worksheet? i'm making a calendar
for
a vac ation planner. some help plz




Jaleel

inserting new columns
 
Hi,

Select 8 rows where you want to insert new column. Press Control and hit +
(numerical keypad). Pop up will come. Select shift cells right. Say OK

Regards,

Jaleel

"cj" wrote:

is there any way to insert new columns just for the top 8 rows in excel, i
don't want the new columns in the whole worksheet? i'm making a calendar for
a vac ation planner. some help plz


Vince

inserting new columns
 

Jaleel wrote:
Hi,

Select 8 rows where you want to insert new column. Press Control and hit +
(numerical keypad). Pop up will come. Select shift cells right. Say OK

Regards,

Jaleel


How does that work on a lap top???


Jaleel

inserting new columns
 
Hi,

Instead of using short cut keys, go to Insert - Cells

Regards,

Jaleel

"Vince" wrote:


Jaleel wrote:
Hi,

Select 8 rows where you want to insert new column. Press Control and hit +
(numerical keypad). Pop up will come. Select shift cells right. Say OK

Regards,

Jaleel


How does that work on a lap top???



CJ

inserting new columns
 
hi,

shifting cells to right didn't work, i need 7 columns for top 8 rows and
only 5 columns for the rows below that.

"Jaleel" wrote:

Hi,

Instead of using short cut keys, go to Insert - Cells

Regards,

Jaleel

"Vince" wrote:


Jaleel wrote:
Hi,

Select 8 rows where you want to insert new column. Press Control and hit +
(numerical keypad). Pop up will come. Select shift cells right. Say OK

Regards,

Jaleel


How does that work on a lap top???




All times are GMT +1. The time now is 05:09 PM.

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