inserting row?

C

chaju

Board Regular
Joined
Mar 24, 2002
Messages
82
Hi , I wonder if there is any shortcut key for Inserting row.. I know shift+space bar will highlight the row,but how to insert a new row (not by mouse)???? thanks for your attention
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
On 2002-03-27 18:22, chaju wrote:
Hi , I wonder if there is any shortcut key for Inserting row.. I know shift+space bar will highlight the row,but how to insert a new row (not by mouse)???? thanks for your attention
Click to expand...

Hi chaju:
I don't know if I have understood you right, but how about
1) go to any cell above which you want to insert a row
2) then INSERT|ROW
now if you don't want to click on the INSERT key with the mouse, key-in ALT+I+R
HTH

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature
This message was edited by Yogi Anand on 2003-01-19 14:21
 
Upvote 0
You must log in or register to reply here.

Similar threads

theYaniac
  • Solved
I would like to insert a blank row between each new unique identifier in column A.
Replies
3
Views
148
MARK858
MARK858
S
  • Question
Insert Custom Rows VBA - Multiple Worksheets
2
Replies
10
Views
424
Peter_SSs
Peter_SSs
R
  • Question
How do I fill a cell with text automatically when I click on the cell?
Replies
5
Views
147
Reiper79
R
G
  • Solved
Insert a blank row when the data in a column changes
Replies
3
Views
213
Peter_SSs
Peter_SSs
K
  • Question
insert new row and insert data validation.
2
Replies
10
Views
557
KingGoku
K

Forum statistics

Threads
1,214,556
Messages
6,120,190
Members
448,949
Latest member
keycalinc

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top