Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

insert row/insert column

  
   Macintosh computer (Home) -> Excel RSS
Related Topics:
Insert column - Whenever I try to insert a new column in Excel "08 I get the following shift objects off Can anyone throw any light on this for me?? Thanks, Regards, Holty

Insert Buttons on Toolbar for Insert Row and Insert Column.. - Has something changed that I missed? I can no longer select an entire = row=20 or column, and then click the Insert button on the toolbar. These = are grayed out.

Lock out of insert row or column - When trying to insert row or column in sheet from Excel '04 I am locked out with the following message: shift objects off Any thoughts? Sheet is not

Insert Row & Column tools on Toolbar Always Grayed Out - Running Office X, latest update, under Panther. The Insert Row and Insert Column tools on my toolbar NEVER work -- they never are available (always display I CAN insert rows and columns using commands from the menu. And yes, I have a..

Insert rows - I just installed Excel 2004. I put the insert rows icon into the toobar however it stays What am i doing wrong. How can I get it to work? Thanks
Next:  Entourage 2004 re-downloads dot-mac email (again)  
Author Message
Byrna West

External


Since: Oct 29, 2007
Posts: 3



(Msg. 1) Posted: Mon Oct 29, 2007 6:18 am
Post subject: insert row/insert column
Archived from groups: microsoft>public>mac>office>excel (more info?)
My 'insert row' and 'insert column' command buttons on the toolbar are
in a lighter shade, and don't appear to be available. I don't quite
understand why. The 'delete row' and 'delete column' command buttons
are fine. Any ideas as to why the 'insert row/column' buttons don't
work?

Also, does anyone know the control keys for insert/delete row/column?

thanks...

 >> Stay informed about: insert row/insert column 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Mon Oct 29, 2007 8:28 am
Post subject: Re: insert row/insert column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <1193663886.154327.40450.DeleteThis@57g2000hsv.googlegroups.com>,
Byrna West <byrna.DeleteThis@btinternet.com> wrote:

> My 'insert row' and 'insert column' command buttons on the toolbar are
> in a lighter shade, and don't appear to be available. I don't quite
> understand why. The 'delete row' and 'delete column' command buttons
> are fine. Any ideas as to why the 'insert row/column' buttons don't
> work?

When you customized your toolbar, you probably used the Insert buttons
from the Edit category in the Customize Toolbars/Menu dialog's Commands
pane rather than those from the Insert category.

The Edit category buttons apply to the List Manager. Unfortunately, the
icons are identical with the Insert category buttons.

> Also, does anyone know the control keys for insert/delete row/column?

You can assign anything you want via Tools/Customize Keyboard... There's
nothing assigned by default.

However, if you have an entire row/column selected, CTRL-i (which b
default is assigned to Insert/Cells...) will work.

 >> Stay informed about: insert row/insert column 
Back to top
Login to vote
CyberTaz

External


Since: Jul 20, 2005
Posts: 1758



(Msg. 3) Posted: Mon Oct 29, 2007 9:53 am
Post subject: Re: insert row/insert column [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
First some clarification - What version of Excel are you using? Always a
good thing to mention:-)

If 2003, Control+Click the button, select Properties, then click Reset.
(This is assuming you *have* added the buttons to a toolbar - they aren't
there by default.) Should that not work, go to Tools> Customize> Customize
Toolbars/Menus, drag the buttons off the toolbar & replace them with new
ones from the commands on the Commands page of that same dialog.

If you actually mean Menu commands (Insert>Row, Insert>Column) click the
black triangle at the end of a toolbar, select Customize Toolbars/Menus & go
to the Toolbars page. Click the *name* of the Menu Bar, then click Reset.

If these suggestions don't help post back with details.

Re. keyboard shortcuts: Neither command has a shortcut assigned to it, but
in the Customize dialog you can click Keyboard & assign them. Instructions
are in Excel Help. Search using the keywords: customize shortcuts.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/29/07 9:18 AM, in article
1193663886.154327.40450.RemoveThis@57g2000hsv.googlegroups.com, "Byrna West"
<byrna.RemoveThis@btinternet.com> wrote:

My 'insert row' and 'insert column' command buttons on the toolbar are
in a lighter shade, and don't appear to be available. I don't quite
understand why. The 'delete row' and 'delete column' command buttons
are fine. Any ideas as to why the 'insert row/column' buttons don't
work?

Also, does anyone know the control keys for insert/delete row/column?

thanks...
 >> Stay informed about: insert row/insert column 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]