A
Abe Z
Are there icons to click for inserting rows or columns in a spreadsheet. Excel has icons to delete rows and columns.
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
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 !
---------------------------------------------------------------------------
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 !
---------------------------------------------------------------------------
Excel has icons to delete rows and columns.Abe Z said:Are there icons to click for inserting rows or columns in a spreadsheet.
C
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
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
Excel has icons to delete rows and columns.U¿ytkownik "Abe Z said:Are there icons to click for inserting rows or columns in a spreadsheet.
V
Valmont
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.
K
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!!
----------------------------------------------------------------------------
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!!
----------------------------------------------------------------------------
Excel has icons to delete rows and columns.Abe Z said:Are there icons to click for inserting rows or columns in a spreadsheet.
D
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
= = = = = = = = = = = = = = = = =
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
= = = = = = = = = = = = = = = = =
Excel has icons to delete rows and columns.Abe Z said:Are there icons to click for inserting rows or columns in a spreadsheet.
R
Ragdyer
That's neat, Dana.
Around here, you learn something new every day !
Around here, you learn something new every day !