Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default short cut for inserting rows

Dear all,

Is there a shortcut for inserting rows in the excel sheet?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default short cut for inserting rows

Ctrl + ( + on the numeric keyboard)

If you select the row or rows first you not see the Insert dialog

Ctrl - is for deleting rows


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JorisBK" wrote in message ...
Dear all,

Is there a shortcut for inserting rows in the excel sheet?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,047
Default short cut for inserting rows

ctrl and +


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JorisBK" escreveu:

Dear all,

Is there a shortcut for inserting rows in the excel sheet?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 62
Default short cut for inserting rows

Ron & Marcelo's solutions work perfectly, of course, but I prefer to
customize my toolbar by adding Insert Rows and Delete Rows. So, for example,
if I want to add rows, I just highlight the number of rows I want to add and
where I want to add them, then click the Insert Rows icon in my toolbar.
Voila!

"JorisBK" wrote:

Dear all,

Is there a shortcut for inserting rows in the excel sheet?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting rows april Excel Discussion (Misc queries) 1 December 10th 07 04:14 PM
Inserting Rows Guy Lydig Excel Discussion (Misc queries) 2 July 9th 07 09:56 PM
short definition on inserting drop caps in word lewis_shannon Excel Discussion (Misc queries) 1 March 8th 07 08:30 AM
Inserting Blank rows after every row upto 2500 rows Manju Excel Worksheet Functions 8 August 22nd 06 12:54 PM
whats the keyboard short cut for inserting a row in Excel Subin New Users to Excel 3 March 11th 05 04:24 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"