K
koolkat
Is there a way to insert multiple columns at once?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rod Gill
No, but as you have to select what each one is individually this wouldn't
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
koolkat said:Is there a way to insert multiple columns at once?
__________ Information from ESET Smart Security, version of virus
signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
R
Rob Schneider
The Project interface provides the ability to add only one column at a
time (Menu: Insert, Column). But if you wanted to automate ... create a
VBA program that inserts all the columns that you want to insert. When
you run that program it will look as if it happens as once (but in fact
it will be sequentially as the program runs).
Create the program by recording the macro that you do manually. Then
edit the resulting VBA macro to make it robust enough to work all the
time. Could attach the launch of the program to a tool bar button, or a
menu, or simply call it from the list of available macros.
--rms
www.rmschneider.com
time (Menu: Insert, Column). But if you wanted to automate ... create a
VBA program that inserts all the columns that you want to insert. When
you run that program it will look as if it happens as once (but in fact
it will be sequentially as the program runs).
Create the program by recording the macro that you do manually. Then
edit the resulting VBA macro to make it robust enough to work all the
time. Could attach the launch of the program to a tool bar button, or a
menu, or simply call it from the list of available macros.
--rms
www.rmschneider.com
J
Jan De Messemaeker
Hi,
View menu, table..., select more tables, edit.
There you can insert several rows (becoming columns in the view) but as Rod
pointed out, you have to name them individually.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
View menu, table..., select more tables, edit.
There you can insert several rows (becoming columns in the view) but as Rod
pointed out, you have to name them individually.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
J
Jim Aksel
No
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
T
Tim Copeland
This is a curious thing to me. It took me many minutes of searching to find even any discussion about this. I use VS 2005 constantly at work (school database SQL management) and I produce many SQL scripts with attached Layouts for export. It's a wonderful product. So, it was very soon after beginning to use VS that I became annoyed at the cumbersome way I have to add new columns to a table layout. This can be described as nothing but a gross oversight in design. The layouts I usually create are 10 to 30 columns wide. It would be a trivial design change to make it possible to add any number of columns at once rather than ONE AT A TIME. No, it is not irrelevant because you have to title and link the column also. Sitting and doing "Right Click - Left click 'Insert Col To Right'" 30 times is not an efficient way to design a layout. This should be fixed. It's a bug.
Rod Gill wrote:
No, but as you have to select what each one is individually this would notmake
19-Nov-09
No, but as you have to select what each one is individually this would not
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Previous Posts In This Thread:
Insert Multiple Columns
Is there a way to insert multiple columns at once?
No, but as you have to select what each one is individually this would notmake
No, but as you have to select what each one is individually this would not
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
The Project interface provides the ability to add only one column at atime
The Project interface provides the ability to add only one column at a
time (Menu: Insert, Column). But if you wanted to automate ... create a
VBA program that inserts all the columns that you want to insert. When
you run that program it will look as if it happens as once (but in fact
it will be sequentially as the program runs).
Create the program by recording the macro that you do manually. Then
edit the resulting VBA macro to make it robust enough to work all the
time. Could attach the launch of the program to a tool bar button, or a
menu, or simply call it from the list of available macros.
--rms
www.rmschneider.com
koolkat wrote:
Hi,View menu, table..., select more tables, edit.
Hi,
View menu, table..., select more tables, edit.
There you can insert several rows (becoming columns in the view) but as Rod
pointed out, you have to name them individually.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
No--If this post was helpful, please consider rating it.
No
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Refactoring with the Parameterized Factory Pattern
http://www.eggheadcafe.com/tutorial...e-790afdea5895/refactoring-with-the-para.aspx
Rod Gill wrote:
No, but as you have to select what each one is individually this would notmake
19-Nov-09
No, but as you have to select what each one is individually this would not
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Previous Posts In This Thread:
Insert Multiple Columns
Is there a way to insert multiple columns at once?
No, but as you have to select what each one is individually this would notmake
No, but as you have to select what each one is individually this would not
make things any faster.
With the keyboard press Ctrl+Space to select the current column then the
Insert key to insert a column. Select the field then repeat.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4623 (20091119) __________
The message was checked by ESET Smart Security.
http://www.eset.com
The Project interface provides the ability to add only one column at atime
The Project interface provides the ability to add only one column at a
time (Menu: Insert, Column). But if you wanted to automate ... create a
VBA program that inserts all the columns that you want to insert. When
you run that program it will look as if it happens as once (but in fact
it will be sequentially as the program runs).
Create the program by recording the macro that you do manually. Then
edit the resulting VBA macro to make it robust enough to work all the
time. Could attach the launch of the program to a tool bar button, or a
menu, or simply call it from the list of available macros.
--rms
www.rmschneider.com
koolkat wrote:
Hi,View menu, table..., select more tables, edit.
Hi,
View menu, table..., select more tables, edit.
There you can insert several rows (becoming columns in the view) but as Rod
pointed out, you have to name them individually.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
No--If this post was helpful, please consider rating it.
No
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Refactoring with the Parameterized Factory Pattern
http://www.eggheadcafe.com/tutorial...e-790afdea5895/refactoring-with-the-para.aspx
R
Rob Schneider
If you think this is bug, then please report to Microsoft.
In any event, VS 2005 (whatever that is) is not Microsoft Project. This
newsgroup is about Microsoft Project and is not Microsoft anyway.
--rms
www.rmschneider.com
In any event, VS 2005 (whatever that is) is not Microsoft Project. This
newsgroup is about Microsoft Project and is not Microsoft anyway.
--rms
www.rmschneider.com
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.