Icons

[Guest]

Are there icons to click for inserting rows or columns in a spreadsheet. Excel has icons to delete rows and columns.

 

[Ragdyer]

Right click in the tool bar and choose "Customize".
Click on "Commands" tab,
In the "Categories " window, click "Insert",
In the "Commands" window, click and drag "Rows" icon to the tool bar.
Then repeat with the "Columns" icon.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Are there icons to click for inserting rows or columns in a spreadsheet.

Excel has icons to delete rows and columns.

 

[count]

Sure thing:
Go Tools...Customize
Choose Commands
Choose Insert (on the left)
Click icon Rows and drag it to some toolbar above.
Done.
BTW: you can even place icons on Menu bar i.e. to the right of Help.
HTH
Paul

Are there icons to click for inserting rows or columns in a spreadsheet.

Excel has icons to delete rows and columns.

 

[Guest]

Hi Abe - In Excel 2003 use View | Toolbars | Customize | Commands and then you will see the icons for inserting rows and columns. Hope that helps.

 

[Ken Wright]

You've had your answers, but personally I prefer a keyboard shortcut for this
one. Simply click on a row/column header and then do CTRL & + or CTRL & - to
add/delete. If you select 5 row headers at once and do this you will get 5 new
rows.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------

Are there icons to click for inserting rows or columns in a spreadsheet.

Excel has icons to delete rows and columns.

 

[Dana DeLouis]

Just to mention if you're not aware of it...
If you hold the Shift key while you click on the "Delete Rows" or "Delete
Columns" button, it will do the opposite. If will Insert instead. Works
the other way also if you have the Insert Rows toolbar button displayed.
Hold the Click button down a moment while doing this and you will see the
picture change as well. HTH.

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

Are there icons to click for inserting rows or columns in a spreadsheet.

Excel has icons to delete rows and columns.

 

[Ragdyer]

That's neat, Dana.
Around here, you learn something new every day !